flexphp / flex-database

tests/Unit/BuilderTest.php

Upper-Lower-Casing +7 added lines, -7 removed lines

@@ -34,7 +34,7 @@ 
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
 CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-T
+t
 , $builder->toSql());
     }
 
@@ -46,7 +46,7 @@ 
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
 CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc;
-T
+t
 , $builder->toSql());
     }
 
@@ -59,7 +59,7 @@ 
         $builder->createUser($name, $password);
         $this->assertEquals(<<<T
 CREATE USER '$name'@'%' IDENTIFIED BY '$password';
-T
+t
 , $builder->toSql());
     }
 
@@ -75,7 +75,7 @@ 
 GO
 CREATE USER $name FOR LOGIN $name;
 GO
-T
+t
 , $builder->toSql());
     }
 
@@ -87,7 +87,7 @@ 
 CREATE TABLE bar (
     foo VARCHAR(255) DEFAULT NULL COMMENT 'foo'
 ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
-T
+t
 , $builder->toSql());
     }
 
@@ -99,7 +99,7 @@ 
 CREATE TABLE bar (
     foo NVARCHAR(255)
 );
-T
+t
 , $builder->toSql());
     }
 
@@ -138,7 +138,7 @@ 
     foo VARCHAR(100) DEFAULT NULL COMMENT 'foo',
     bar INT DEFAULT NULL COMMENT 'bar'
 ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
-T
+t
 , $builder->toSql());
     }
 

tests/Unit/Factories/User/MySQLUserFactoryTest.php

Upper-Lower-Casing +11 added lines, -11 removed lines

@@ -35,7 +35,7 @@ 
         $user = new User($name, $password);
         $this->assertEquals(<<<T
 CREATE USER '$name'@'%' IDENTIFIED BY '$password';
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -48,7 +48,7 @@ 
         $user = new User($name, $password, $host);
         $this->assertEquals(<<<T
 CREATE USER '$name'@'$host' IDENTIFIED BY '$password';
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -65,7 +65,7 @@ 
         $user = new User($name, $password, $host);
         $this->assertEquals(<<<T
 DROP USER '$name'@'%';
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -78,7 +78,7 @@ 
         $user = new User($name, $password, $host);
         $this->assertEquals(<<<T
 DROP USER '$name'@'$host';
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -95,8 +95,8 @@ 
         $user = new User($name, $password);
         $user->setGrant($permission);
         $this->assertEquals(<<<T
-GRANT $permission ON *.* TO '$name'@'%';
-T
+grant $permission ON *.* TO '$name'@'%';
+t
 , $user->toSqlPrivileges());
     }
 
@@ -114,8 +114,8 @@ 
         $user = new User($name, $password);
         $user->setGrant($permission, $database);
         $this->assertEquals(<<<T
-GRANT $permission ON $database.* TO '$name'@'%';
-T
+grant $permission ON $database.* TO '$name'@'%';
+t
 , $user->toSqlPrivileges());
     }
 
@@ -134,8 +134,8 @@ 
         $user = new User($name, $password);
         $user->setGrant($permission, $database, $table);
         $this->assertEquals(<<<T
-GRANT $permission ON $database.$table TO '$name'@'%';
-T
+grant $permission ON $database.$table TO '$name'@'%';
+t
 , $user->toSqlPrivileges());
     }
 
@@ -155,7 +155,7 @@ 
         $this->assertEquals(<<<T
 GRANT CREATE ON $database.$table TO '$name'@'%';
 GRANT UPDATE ON $database.$table TO '$name'@'%';
-T
+t
 , $user->toSqlPrivileges());
     }
 

tests/Unit/Factories/User/SQLSrvUserFactoryTest.php

Upper-Lower-Casing +9 added lines, -9 removed lines

@@ -39,7 +39,7 @@ 
 GO
 CREATE USER $name FOR LOGIN $name;
 GO
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -53,7 +53,7 @@ 
         $this->assertEquals(<<<T
 DROP USER $name;
 GO
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -70,9 +70,9 @@ 
         $user->setPlatform('SQLSrv');
         $user->setGrant($permission);
         $this->assertEquals(<<<T
-GRANT $mappingPermission TO $name;
+grant $mappingPermission TO $name;
 GO
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -90,9 +90,9 @@ 
         $user->setPlatform('SQLSrv');
         $user->setGrant($permission, $database);
         $this->assertEquals(<<<T
-GRANT $mappingPermission ON $database TO $name;
+grant $mappingPermission ON $database TO $name;
 GO
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -111,9 +111,9 @@ 
         $user->setPlatform('SQLSrv');
         $user->setGrant($permission, $database, $table);
         $this->assertEquals(<<<T
-GRANT $mappingPermission ON $database.$table TO $name;
+grant $mappingPermission ON $database.$table TO $name;
 GO
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -136,7 +136,7 @@ 
 GO
 GRANT UPDATE ON $database.$table TO $name;
 GO
-T
+t
 , $user->toSqlPrivileges());
     }
 

tests/Unit/UserTest.php

Upper-Lower-Casing +7 added lines, -7 removed lines

@@ -22,7 +22,7 @@ 
         $user->setPlatform('MySQL');
         $this->assertEquals(<<<T
 CREATE USER '$name'@'%' IDENTIFIED BY '$password';
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -35,7 +35,7 @@ 
         $user->setPlatform('MySQL');
         $this->assertEquals(<<<T
 DROP USER '$name'@'%';
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -51,7 +51,7 @@ 
         $user->setGrants(['CREATE'], $database, $table);
         $this->assertEquals(<<<T
 GRANT CREATE ON $database.$table TO '$name'@'%';
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -67,7 +67,7 @@ 
 GO
 CREATE USER $name FOR LOGIN $name;
 GO
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -81,7 +81,7 @@ 
         $this->assertEquals(<<<T
 DROP USER $name;
 GO
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -97,9 +97,9 @@ 
         $user->setPlatform('SQLSrv');
         $user->setGrants(['CREATE'], $database, $table);
         $this->assertEquals(<<<T
-GRANT $permission ON $database.$table TO $name;
+grant $permission ON $database.$table TO $name;
 GO
-T
+t
 , $user->toSqlPrivileges());
     }
 }

src/Factories/User/SQLSrvUserFactory.php

Upper-Lower-Casing +4 added lines, -4 removed lines

@@ -29,7 +29,7 @@ 
 GO
 CREATE USER %1\$s FOR LOGIN %1\$s;
 GO
-T
+t
 , $this->name, $this->password);
     }
 
@@ -38,7 +38,7 @@ 
         return \sprintf(<<<T
 DROP USER %s;
 GO
-T
+t
 , $this->name);
     }
 
@@ -107,7 +107,7 @@ 
         return \sprintf(<<<T
 GRANT %s TO %s;
 GO
-T
+t
 , $permission, $this->name);
     }
 
@@ -116,7 +116,7 @@ 
         return \sprintf(<<<T
 GRANT %s %s TO %s;
 GO
-T
+t
 , $permission, $scope, $this->name);
     }
 }