flexphp / flex-database

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