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

tests/Unit/BuilderTest.php

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

@@ -44,7 +44,7 @@ 
         $this->assertEquals(<<<T
 CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -57,7 +57,7 @@ 
         $this->assertEquals(<<<T
 CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -69,7 +69,7 @@ 
         $builder->createDatabase($name);
         $this->assertEquals(<<<T
 
-T
+t
 , $builder->toSql());
     }
 
@@ -84,7 +84,7 @@ 
 
 USE $name;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -97,7 +97,7 @@ 
         $this->assertEquals(<<<T
 CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -108,7 +108,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createDatabaseWithUse($name);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -122,7 +122,7 @@ 
         $this->assertEquals(<<<T
 CREATE USER '$name'@'%' IDENTIFIED BY '$password';
 
-T
+t
 , $builder->toSql());
     }
 
@@ -139,7 +139,7 @@ 
 CREATE USER $name FOR LOGIN $name;
 GO
 
-T
+t
 , $builder->toSql());
     }
 
@@ -151,7 +151,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createUser($name, $password);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -167,7 +167,7 @@ 
 
 GRANT ALL PRIVILEGES ON *.* TO '$name'@'host';
 
-T
+t
 , $builder->toSql());
     }
 
@@ -187,7 +187,7 @@ 
 GRANT ALL TO $name;
 GO
 
-T
+t
 , $builder->toSql());
     }
 
@@ -199,7 +199,7 @@ 
         $builder = new Builder('SQLite');
         $builder->createUser($name, $password, 'host', ['ALL PRIVILEGES']);
         $this->assertEquals(<<<T
-T
+t
 , $builder->toSql());
     }
 
@@ -212,7 +212,7 @@ 
     foo INT DEFAULT NULL COMMENT 'foo'
 ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -227,7 +227,7 @@ 
 
 EXEC sp_addextendedproperty N'MS_Description', N'foo', N'SCHEMA', 'dbo', N'TABLE', 'bar', N'COLUMN', foo;
 
-T
+t
 , $builder->toSql());
     }
 
@@ -240,7 +240,7 @@ 
     foo INTEGER DEFAULT NULL
 );
 
-T
+t
 , $builder->toSql());
     }
 
@@ -292,7 +292,7 @@ 
 
 ALTER TABLE fuz ADD CONSTRAINT FK_51837B119A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id);
 
-T
+t
 , $builder->toSql());
     }
 
@@ -362,7 +362,7 @@ 
 
 ALTER TABLE baz ADD CONSTRAINT FK_782404989A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id);
 
-T
+t
 , $builder->toSql());
     }