@@ -54,7 +54,7 @@ |
||
54 | 54 | $statement = ''; |
55 | 55 | if (!empty($limit) || !empty($offset)) { |
56 | 56 | //When limit is not provided but offset does we can replace limit value with PHP_INT_MAX |
57 | - $statement = 'LIMIT ' . ($limit ?: '18446744073709551615') . ' '; |
|
57 | + $statement = 'LIMIT '.($limit ?: '18446744073709551615').' '; |
|
58 | 58 | } |
59 | 59 | |
60 | 60 | if (!empty($offset)) { |
@@ -35,9 +35,9 @@ discard block |
||
35 | 35 | $selectColumns[] = "? AS {$this->quote($column)}"; |
36 | 36 | } |
37 | 37 | |
38 | - $statement[] = 'SELECT ' . implode(', ', $selectColumns); |
|
38 | + $statement[] = 'SELECT '.implode(', ', $selectColumns); |
|
39 | 39 | } else { |
40 | - $statement[] = 'UNION SELECT ' . trim(str_repeat('?, ', count($columns)), ', '); |
|
40 | + $statement[] = 'UNION SELECT '.trim(str_repeat('?, ', count($columns)), ', '); |
|
41 | 41 | } |
42 | 42 | } |
43 | 43 | |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | $statement = ''; |
59 | 59 | |
60 | 60 | if (!empty($limit) || !empty($offset)) { |
61 | - $statement = 'LIMIT ' . ($limit ?: '-1') . ' '; |
|
61 | + $statement = 'LIMIT '.($limit ?: '-1').' '; |
|
62 | 62 | } |
63 | 63 | |
64 | 64 | if (!empty($offset)) { |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | $enumValues[] = $this->table->driver()->getPDO()->quote($value); |
117 | 117 | } |
118 | 118 | |
119 | - return "$statement CHECK ({$this->getName(true)} IN (" . implode(', ', $enumValues) . '))'; |
|
119 | + return "$statement CHECK ({$this->getName(true)} IN (".implode(', ', $enumValues).'))'; |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | /** |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | } |
169 | 169 | } |
170 | 170 | |
171 | - $options = array_map(function ($value) { |
|
171 | + $options = array_map(function($value) { |
|
172 | 172 | return intval($value); |
173 | 173 | }, explode(',', $options)); |
174 | 174 |
@@ -22,10 +22,10 @@ |
||
22 | 22 | $statement = []; |
23 | 23 | |
24 | 24 | $statement[] = 'FOREIGN KEY'; |
25 | - $statement[] = '(' . $this->table->driver()->identifier($this->column) . ')'; |
|
25 | + $statement[] = '('.$this->table->driver()->identifier($this->column).')'; |
|
26 | 26 | |
27 | - $statement[] = 'REFERENCES ' . $this->table->driver()->identifier($this->foreignTable); |
|
28 | - $statement[] = '(' . $this->table->driver()->identifier($this->foreignKey) . ')'; |
|
27 | + $statement[] = 'REFERENCES '.$this->table->driver()->identifier($this->foreignTable); |
|
28 | + $statement[] = '('.$this->table->driver()->identifier($this->foreignKey).')'; |
|
29 | 29 | |
30 | 30 | $statement[] = "ON DELETE {$this->deleteRule}"; |
31 | 31 | $statement[] = "ON UPDATE {$this->updateRule}"; |
@@ -163,7 +163,7 @@ |
||
163 | 163 | { |
164 | 164 | //Temporary table is required to copy data over |
165 | 165 | $temporary = clone $this; |
166 | - $temporary->setName('spiral_temp_' . $this->getName() . '_' . uniqid()); |
|
166 | + $temporary->setName('spiral_temp_'.$this->getName().'_'.uniqid()); |
|
167 | 167 | |
168 | 168 | //We don't need any index in temporary table |
169 | 169 | foreach ($temporary->getIndexes() as $index) { |
@@ -189,14 +189,14 @@ |
||
189 | 189 | if ($this->abstractType() == 'enum') { |
190 | 190 | |
191 | 191 | //Fetching enum values |
192 | - $this->enumValues = array_map(function ($value) { |
|
192 | + $this->enumValues = array_map(function($value) { |
|
193 | 193 | return trim($value, $value[0]); |
194 | 194 | }, explode(',', $options)); |
195 | 195 | |
196 | 196 | return; |
197 | 197 | } |
198 | 198 | |
199 | - $options = array_map(function ($value) { |
|
199 | + $options = array_map(function($value) { |
|
200 | 200 | return intval($value); |
201 | 201 | }, explode(',', $options)); |
202 | 202 |
@@ -92,6 +92,6 @@ |
||
92 | 92 | throw new SchemaException('MySQL commander can process only MySQL tables'); |
93 | 93 | } |
94 | 94 | |
95 | - return parent::createStatement($table) . " ENGINE {$table->getEngine()}"; |
|
95 | + return parent::createStatement($table)." ENGINE {$table->getEngine()}"; |
|
96 | 96 | } |
97 | 97 | } |
@@ -196,7 +196,7 @@ discard block |
||
196 | 196 | } |
197 | 197 | |
198 | 198 | return "$statement CONSTRAINT {$this->enumConstraint(true, true)} " |
199 | - . "CHECK ({$this->getName(true)} IN (" . implode(', ', $enumValues) . '))'; |
|
199 | + . "CHECK ({$this->getName(true)} IN (".implode(', ', $enumValues).'))'; |
|
200 | 200 | } |
201 | 201 | |
202 | 202 | /** |
@@ -240,7 +240,7 @@ discard block |
||
240 | 240 | } |
241 | 241 | |
242 | 242 | if ($original->abstractType() == 'enum' && !empty($this->enumConstraint)) { |
243 | - $operations[] = 'DROP CONSTRAINT ' . $this->enumConstraint(true); |
|
243 | + $operations[] = 'DROP CONSTRAINT '.$this->enumConstraint(true); |
|
244 | 244 | } |
245 | 245 | |
246 | 246 | if ($original->defaultValue != $this->defaultValue) { |
@@ -253,7 +253,7 @@ discard block |
||
253 | 253 | |
254 | 254 | if ($original->nullable != $this->nullable) { |
255 | 255 | $operations[] = "ALTER COLUMN {$this->getName(true)} " |
256 | - . (!$this->nullable ? 'SET' : 'DROP') . ' NOT NULL'; |
|
256 | + . (!$this->nullable ? 'SET' : 'DROP').' NOT NULL'; |
|
257 | 257 | } |
258 | 258 | |
259 | 259 | if ($this->abstractType() == 'enum') { |
@@ -263,7 +263,7 @@ discard block |
||
263 | 263 | } |
264 | 264 | |
265 | 265 | $operations[] = "ADD CONSTRAINT {$this->enumConstraint(true)} " |
266 | - . "CHECK ({$this->getName(true)} IN (" . implode(', ', $enumValues) . '))'; |
|
266 | + . "CHECK ({$this->getName(true)} IN (".implode(', ', $enumValues).'))'; |
|
267 | 267 | } |
268 | 268 | |
269 | 269 | return $operations; |
@@ -327,7 +327,7 @@ discard block |
||
327 | 327 | */ |
328 | 328 | protected function prepareEnum() |
329 | 329 | { |
330 | - return '(' . $this->size . ')'; |
|
330 | + return '('.$this->size.')'; |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | /** |
@@ -343,10 +343,10 @@ discard block |
||
343 | 343 | { |
344 | 344 | if (empty($this->enumConstraint)) { |
345 | 345 | if ($temporary) { |
346 | - return $this->table->getName() . '_' . $this->getName() . '_enum'; |
|
346 | + return $this->table->getName().'_'.$this->getName().'_enum'; |
|
347 | 347 | } |
348 | 348 | |
349 | - $this->enumConstraint = $this->table->getName() . '_' . $this->getName() . '_enum_' . uniqid(); |
|
349 | + $this->enumConstraint = $this->table->getName().'_'.$this->getName().'_enum_'.uniqid(); |
|
350 | 350 | } |
351 | 351 | |
352 | 352 | return $quote ? $this->table->driver()->identifier($this->enumConstraint) : $this->enumConstraint; |
@@ -377,7 +377,7 @@ discard block |
||
377 | 377 | private function resolveNativeEnum() |
378 | 378 | { |
379 | 379 | $range = $this->table->driver()->query( |
380 | - 'SELECT enum_range(NULL::' . $this->type . ')' |
|
380 | + 'SELECT enum_range(NULL::'.$this->type.')' |
|
381 | 381 | )->fetchColumn(0); |
382 | 382 | |
383 | 383 | $this->enumValues = explode(',', substr($range, 1, -1)); |
@@ -403,7 +403,7 @@ discard block |
||
403 | 403 | . "WHERE conrelid = ? AND contype = 'c' AND (consrc LIKE ? OR consrc LIKE ?)"; |
404 | 404 | |
405 | 405 | $constraints = $this->table->driver()->query( |
406 | - $query, [$tableOID, '(' . $this->name . '%', '("' . $this->name . '%'] |
|
406 | + $query, [$tableOID, '('.$this->name.'%', '("'.$this->name.'%'] |
|
407 | 407 | ); |
408 | 408 | |
409 | 409 | foreach ($constraints as $constraint) { |
@@ -235,7 +235,7 @@ discard block |
||
235 | 235 | } |
236 | 236 | |
237 | 237 | $type = "ALTER COLUMN {$this->getName(true)} varchar($enumSize)"; |
238 | - $operations[] = $type . ' ' . ($this->nullable ? 'NULL' : 'NOT NULL'); |
|
238 | + $operations[] = $type.' '.($this->nullable ? 'NULL' : 'NOT NULL'); |
|
239 | 239 | } else { |
240 | 240 | $type = "ALTER COLUMN {$this->getName(true)} {$this->type}"; |
241 | 241 | |
@@ -247,7 +247,7 @@ discard block |
||
247 | 247 | $type .= "($this->precision, $this->scale)"; |
248 | 248 | } |
249 | 249 | |
250 | - $operations[] = $type . ' ' . ($this->nullable ? 'NULL' : 'NOT NULL'); |
|
250 | + $operations[] = $type.' '.($this->nullable ? 'NULL' : 'NOT NULL'); |
|
251 | 251 | } |
252 | 252 | } |
253 | 253 | |
@@ -433,7 +433,7 @@ discard block |
||
433 | 433 | |
434 | 434 | //We made some assumptions here... |
435 | 435 | if (preg_match_all( |
436 | - '/' . $name . '=[\']?([^\']+)[\']?/i', |
|
436 | + '/'.$name.'=[\']?([^\']+)[\']?/i', |
|
437 | 437 | $checkConstraint['definition'], |
438 | 438 | $matches |
439 | 439 | )) { |
@@ -453,6 +453,6 @@ discard block |
||
453 | 453 | */ |
454 | 454 | private function generateName($type) |
455 | 455 | { |
456 | - return $this->table->getName() . '_' . $this->getName() . "_{$type}_" . uniqid(); |
|
456 | + return $this->table->getName().'_'.$this->getName()."_{$type}_".uniqid(); |
|
457 | 457 | } |
458 | 458 | } |