@@ -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 | } |