@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | $builder->createDatabase($name); |
44 | 44 | $this->assertEquals(<<<T |
45 | 45 | CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; |
46 | -T |
|
46 | +t |
|
47 | 47 | , $builder->toSql()); |
48 | 48 | } |
49 | 49 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | $builder->createDatabase($name); |
56 | 56 | $this->assertEquals(<<<T |
57 | 57 | CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc; |
58 | -T |
|
58 | +t |
|
59 | 59 | , $builder->toSql()); |
60 | 60 | } |
61 | 61 | |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | $builder = new Builder('SQLite'); |
67 | 67 | $builder->createDatabase($name); |
68 | 68 | $this->assertEquals(<<<T |
69 | -T |
|
69 | +t |
|
70 | 70 | , $builder->toSql()); |
71 | 71 | } |
72 | 72 | |
@@ -80,7 +80,7 @@ discard block |
||
80 | 80 | CREATE DATABASE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; |
81 | 81 | |
82 | 82 | USE $name; |
83 | -T |
|
83 | +t |
|
84 | 84 | , $builder->toSql()); |
85 | 85 | } |
86 | 86 | |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | $builder->createDatabaseWithUse($name); |
93 | 93 | $this->assertEquals(<<<T |
94 | 94 | CREATE DATABASE $name COLLATE latin1_general_100_ci_ai_sc; |
95 | -T |
|
95 | +t |
|
96 | 96 | , $builder->toSql()); |
97 | 97 | } |
98 | 98 | |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | $builder = new Builder('SQLite'); |
104 | 104 | $builder->createDatabaseWithUse($name); |
105 | 105 | $this->assertEquals(<<<T |
106 | -T |
|
106 | +t |
|
107 | 107 | , $builder->toSql()); |
108 | 108 | } |
109 | 109 | |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | $builder->createUser($name, $password); |
117 | 117 | $this->assertEquals(<<<T |
118 | 118 | CREATE USER '$name'@'%' IDENTIFIED BY '$password'; |
119 | -T |
|
119 | +t |
|
120 | 120 | , $builder->toSql()); |
121 | 121 | } |
122 | 122 | |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | GO |
133 | 133 | CREATE USER $name FOR LOGIN $name; |
134 | 134 | GO |
135 | -T |
|
135 | +t |
|
136 | 136 | , $builder->toSql()); |
137 | 137 | } |
138 | 138 | |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | $builder = new Builder('SQLite'); |
145 | 145 | $builder->createUser($name, $password); |
146 | 146 | $this->assertEquals(<<<T |
147 | -T |
|
147 | +t |
|
148 | 148 | , $builder->toSql()); |
149 | 149 | } |
150 | 150 | |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | CREATE USER '$name'@'host' IDENTIFIED BY '$password'; |
160 | 160 | |
161 | 161 | GRANT ALL PRIVILEGES ON *.* TO '$name'@'host'; |
162 | -T |
|
162 | +t |
|
163 | 163 | , $builder->toSql()); |
164 | 164 | } |
165 | 165 | |
@@ -178,7 +178,7 @@ discard block |
||
178 | 178 | |
179 | 179 | GRANT ALL TO $name; |
180 | 180 | GO |
181 | -T |
|
181 | +t |
|
182 | 182 | , $builder->toSql()); |
183 | 183 | } |
184 | 184 | |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | $builder = new Builder('SQLite'); |
191 | 191 | $builder->createUser($name, $password, 'host', ['ALL PRIVILEGES']); |
192 | 192 | $this->assertEquals(<<<T |
193 | -T |
|
193 | +t |
|
194 | 194 | , $builder->toSql()); |
195 | 195 | } |
196 | 196 | |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | CREATE TABLE bar ( |
203 | 203 | foo INT DEFAULT NULL COMMENT 'foo' |
204 | 204 | ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB; |
205 | -T |
|
205 | +t |
|
206 | 206 | , $builder->toSql()); |
207 | 207 | } |
208 | 208 | |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | ); |
217 | 217 | |
218 | 218 | EXEC sp_addextendedproperty N'MS_Description', N'foo', N'SCHEMA', 'dbo', N'TABLE', 'bar', N'COLUMN', foo; |
219 | -T |
|
219 | +t |
|
220 | 220 | , $builder->toSql()); |
221 | 221 | } |
222 | 222 | |
@@ -228,7 +228,7 @@ discard block |
||
228 | 228 | CREATE TABLE bar ( |
229 | 229 | foo INTEGER DEFAULT NULL |
230 | 230 | ); |
231 | -T |
|
231 | +t |
|
232 | 232 | , $builder->toSql()); |
233 | 233 | } |
234 | 234 | |
@@ -279,7 +279,7 @@ discard block |
||
279 | 279 | ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB; |
280 | 280 | |
281 | 281 | ALTER TABLE fuz ADD CONSTRAINT FK_51837B119A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id); |
282 | -T |
|
282 | +t |
|
283 | 283 | , $builder->toSql()); |
284 | 284 | } |
285 | 285 | |
@@ -346,7 +346,7 @@ discard block |
||
346 | 346 | ALTER TABLE baz ADD CONSTRAINT FK_78240498BEB399D5 FOREIGN KEY (fuzId) REFERENCES fuz (id); |
347 | 347 | |
348 | 348 | ALTER TABLE baz ADD CONSTRAINT FK_782404989A5BAE65 FOREIGN KEY (barId) REFERENCES bar (id); |
349 | -T |
|
349 | +t |
|
350 | 350 | , $builder->toSql()); |
351 | 351 | } |
352 | 352 |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | $user = new User($name, $password); |
36 | 36 | $user->setPlatform('SQLite'); |
37 | 37 | $this->assertEquals(<<<T |
38 | -T |
|
38 | +t |
|
39 | 39 | , $user->toSqlCreate()); |
40 | 40 | } |
41 | 41 | |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | $user = new User($name, $password, $host); |
49 | 49 | $user->setPlatform('SQLite'); |
50 | 50 | $this->assertEquals(<<<T |
51 | -T |
|
51 | +t |
|
52 | 52 | , $user->toSqlCreate()); |
53 | 53 | } |
54 | 54 | |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | $user = new User($name, $password, $host); |
66 | 66 | $user->setPlatform('SQLite'); |
67 | 67 | $this->assertEquals(<<<T |
68 | -T |
|
68 | +t |
|
69 | 69 | , $user->toSqlDrop()); |
70 | 70 | } |
71 | 71 | |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | $user = new User($name, $password, $host); |
79 | 79 | $user->setPlatform('SQLite'); |
80 | 80 | $this->assertEquals(<<<T |
81 | -T |
|
81 | +t |
|
82 | 82 | , $user->toSqlDrop()); |
83 | 83 | } |
84 | 84 | |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | $user->setPlatform('SQLite'); |
97 | 97 | $user->setGrant($permission); |
98 | 98 | $this->assertEquals(<<<T |
99 | -T |
|
99 | +t |
|
100 | 100 | , $user->toSqlPrivileges()); |
101 | 101 | } |
102 | 102 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | $user->setPlatform('SQLite'); |
116 | 116 | $user->setGrant($permission, $database); |
117 | 117 | $this->assertEquals(<<<T |
118 | -T |
|
118 | +t |
|
119 | 119 | , $user->toSqlPrivileges()); |
120 | 120 | } |
121 | 121 | |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | $user->setPlatform('SQLite'); |
136 | 136 | $user->setGrant($permission, $database, $table); |
137 | 137 | $this->assertEquals(<<<T |
138 | -T |
|
138 | +t |
|
139 | 139 | , $user->toSqlPrivileges()); |
140 | 140 | } |
141 | 141 | |
@@ -154,7 +154,7 @@ discard block |
||
154 | 154 | $user->setPlatform('SQLite'); |
155 | 155 | $user->setGrants($permissions, $database, $table); |
156 | 156 | $this->assertEquals(<<<T |
157 | -T |
|
157 | +t |
|
158 | 158 | , $user->toSqlPrivileges()); |
159 | 159 | } |
160 | 160 |
@@ -112,7 +112,7 @@ |
||
112 | 112 | $this->createDatabase($name); |
113 | 113 | |
114 | 114 | if ($this->isMySQLPlatform()) { |
115 | - $this->databases[] = "USE {$name};"; |
|
115 | + $this->databases[] = "use {$name};"; |
|
116 | 116 | } |
117 | 117 | } |
118 | 118 |