flexphp / flex-database

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);
     }
 }

tests/Unit/BuilderTest.php

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

@@ -43,7 +43,7 @@ 
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
 CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-T
+t
 , $builder->toSql());
     }
 
@@ -55,7 +55,7 @@ 
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
 CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc;
-T
+t
 , $builder->toSql());
     }
 
@@ -66,7 +66,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -80,7 +80,7 @@ 
 CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
 
 USE $name;
-T
+t
 , $builder->toSql());
     }
 
@@ -92,7 +92,7 @@ 
         $builder->createDatabaseWithUse($name);
         $this->assertEquals(<<<T
 CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc;
-T
+t
 , $builder->toSql());
     }
 
@@ -103,7 +103,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createDatabaseWithUse($name);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -116,7 +116,7 @@ 
         $builder->createUser($name, $password);
         $this->assertEquals(<<<T
 CREATE USER '$name'@'%' IDENTIFIED BY '$password';
-T
+t
 , $builder->toSql());
     }
 
@@ -132,7 +132,7 @@ 
 GO
 CREATE USER $name FOR LOGIN $name;
 GO
-T
+t
 , $builder->toSql());
     }
 
@@ -144,7 +144,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createUser($name, $password);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -159,7 +159,7 @@ 
 CREATE USER '$name'@'host' IDENTIFIED BY '$password';
 
 GRANT ALL PRIVILEGES ON *.* TO '$name'@'host';
-T
+t
 , $builder->toSql());
     }
 
@@ -178,7 +178,7 @@ 
 
 GRANT ALL TO $name;
 GO
-T
+t
 , $builder->toSql());
     }
 
@@ -190,7 +190,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createUser($name, $password, 'host', ['ALL PRIVILEGES']);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -202,7 +202,7 @@ 
 CREATE TABLE bar (
     foo INT DEFAULT NULL COMMENT 'foo'
 ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
-T
+t
 , $builder->toSql());
     }
 
@@ -216,7 +216,7 @@ 
 );
 
 EXEC sp_addextendedproperty N'MS_Description', N'foo', N'SCHEMA', 'dbo', N'TABLE', 'bar', N'COLUMN', foo;
-T
+t
 , $builder->toSql());
     }
 
@@ -228,7 +228,7 @@ 
 CREATE TABLE bar (
     foo INTEGER DEFAULT NULL
 );
-T
+t
 , $builder->toSql());
     }
 
@@ -279,7 +279,7 @@ 
 ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
 
 ALTER TABLE fuz ADD CONSTRAINT FK_51837B119A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id);
-T
+t
 , $builder->toSql());
     }
 
@@ -346,7 +346,7 @@ 
 ALTER TABLE baz ADD CONSTRAINT FK_78240498BEB399D5 FOREIGN KEY (fuzId) REFERENCES fuz (id);
 
 ALTER TABLE baz ADD CONSTRAINT FK_782404989A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id);
-T
+t
 , $builder->toSql());
     }
 

tests/Unit/Factories/User/SQLiteUserFactoryTest.php

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

@@ -35,7 +35,7 @@ 
         $user = new User($name, $password);
         $user->setPlatform('SQLite');
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -48,7 +48,7 @@ 
         $user = new User($name, $password, $host);
         $user->setPlatform('SQLite');
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlCreate());
     }
 
@@ -65,7 +65,7 @@ 
         $user = new User($name, $password, $host);
         $user->setPlatform('SQLite');
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -78,7 +78,7 @@ 
         $user = new User($name, $password, $host);
         $user->setPlatform('SQLite');
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlDrop());
     }
 
@@ -96,7 +96,7 @@ 
         $user->setPlatform('SQLite');
         $user->setGrant($permission);
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -115,7 +115,7 @@ 
         $user->setPlatform('SQLite');
         $user->setGrant($permission, $database);
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -135,7 +135,7 @@ 
         $user->setPlatform('SQLite');
         $user->setGrant($permission, $database, $table);
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlPrivileges());
     }
 
@@ -154,7 +154,7 @@ 
         $user->setPlatform('SQLite');
         $user->setGrants($permissions, $database, $table);
         $this->assertEquals(<<<T
-T
+t
 , $user->toSqlPrivileges());
     }
 

src/Builder.php

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

@@ -112,7 +112,7 @@
         $this->createDatabase($name);
 
         if ($this->isMySQLPlatform()) {
-            $this->databases[] = "USE {$name};";
+            $this->databases[] = "use {$name};";
         }
     }