@@ -300,23 +300,23 @@ discard block |
||
300 | 300 | $flags['distinct'] = true; |
301 | 301 | } |
302 | 302 | |
303 | - if (! empty($statement->group) || ! empty($statement->having)) { |
|
303 | + if (!empty($statement->group) || !empty($statement->having)) { |
|
304 | 304 | $flags['is_group'] = true; |
305 | 305 | } |
306 | 306 | |
307 | - if (! empty($statement->into) && ($statement->into->type === 'OUTFILE')) { |
|
307 | + if (!empty($statement->into) && ($statement->into->type === 'OUTFILE')) { |
|
308 | 308 | $flags['is_export'] = true; |
309 | 309 | } |
310 | 310 | |
311 | 311 | $expressions = $statement->expr; |
312 | - if (! empty($statement->join)) { |
|
312 | + if (!empty($statement->join)) { |
|
313 | 313 | foreach ($statement->join as $join) { |
314 | 314 | $expressions[] = $join->expr; |
315 | 315 | } |
316 | 316 | } |
317 | 317 | |
318 | 318 | foreach ($expressions as $expr) { |
319 | - if (! empty($expr->function)) { |
|
319 | + if (!empty($expr->function)) { |
|
320 | 320 | if ($expr->function === 'COUNT') { |
321 | 321 | $flags['is_count'] = true; |
322 | 322 | } elseif (in_array($expr->function, static::$functions)) { |
@@ -331,15 +331,15 @@ discard block |
||
331 | 331 | $flags['is_subquery'] = true; |
332 | 332 | } |
333 | 333 | |
334 | - if (! empty($statement->procedure) && ($statement->procedure->name === 'ANALYSE')) { |
|
334 | + if (!empty($statement->procedure) && ($statement->procedure->name === 'ANALYSE')) { |
|
335 | 335 | $flags['is_analyse'] = true; |
336 | 336 | } |
337 | 337 | |
338 | - if (! empty($statement->group)) { |
|
338 | + if (!empty($statement->group)) { |
|
339 | 339 | $flags['group'] = true; |
340 | 340 | } |
341 | 341 | |
342 | - if (! empty($statement->having)) { |
|
342 | + if (!empty($statement->having)) { |
|
343 | 343 | $flags['having'] = true; |
344 | 344 | } |
345 | 345 | |
@@ -347,7 +347,7 @@ discard block |
||
347 | 347 | $flags['union'] = true; |
348 | 348 | } |
349 | 349 | |
350 | - if (! empty($statement->join)) { |
|
350 | + if (!empty($statement->join)) { |
|
351 | 351 | $flags['join'] = true; |
352 | 352 | } |
353 | 353 | |
@@ -438,11 +438,11 @@ discard block |
||
438 | 438 | || ($statement instanceof UpdateStatement) |
439 | 439 | || ($statement instanceof DeleteStatement) |
440 | 440 | ) { |
441 | - if (! empty($statement->limit)) { |
|
441 | + if (!empty($statement->limit)) { |
|
442 | 442 | $flags['limit'] = true; |
443 | 443 | } |
444 | 444 | |
445 | - if (! empty($statement->order)) { |
|
445 | + if (!empty($statement->order)) { |
|
446 | 446 | $flags['order'] = true; |
447 | 447 | } |
448 | 448 | } |
@@ -492,7 +492,7 @@ discard block |
||
492 | 492 | // Finding tables' aliases and their associated real names. |
493 | 493 | $tableAliases = []; |
494 | 494 | foreach ($statement->from as $expr) { |
495 | - if (! isset($expr->table, $expr->alias) || ($expr->table === '') || ($expr->alias === '')) { |
|
495 | + if (!isset($expr->table, $expr->alias) || ($expr->table === '') || ($expr->alias === '')) { |
|
496 | 496 | continue; |
497 | 497 | } |
498 | 498 | |
@@ -517,7 +517,7 @@ discard block |
||
517 | 517 | ]; |
518 | 518 | } |
519 | 519 | |
520 | - if (! in_array($arr, $ret['select_tables'])) { |
|
520 | + if (!in_array($arr, $ret['select_tables'])) { |
|
521 | 521 | $ret['select_tables'][] = $arr; |
522 | 522 | } |
523 | 523 | } else { |
@@ -530,7 +530,7 @@ discard block |
||
530 | 530 | // extracted from the FROM clause. |
531 | 531 | if ($ret['select_tables'] === []) { |
532 | 532 | foreach ($statement->from as $expr) { |
533 | - if (! isset($expr->table) || ($expr->table === '')) { |
|
533 | + if (!isset($expr->table) || ($expr->table === '')) { |
|
534 | 534 | continue; |
535 | 535 | } |
536 | 536 | |
@@ -571,7 +571,7 @@ discard block |
||
571 | 571 | } elseif (($statement instanceof AlterStatement) || ($statement instanceof TruncateStatement)) { |
572 | 572 | $expressions = [$statement->table]; |
573 | 573 | } elseif ($statement instanceof DropStatement) { |
574 | - if (! $statement->options->has('TABLE')) { |
|
574 | + if (!$statement->options->has('TABLE')) { |
|
575 | 575 | // No tables are dropped. |
576 | 576 | return []; |
577 | 577 | } |
@@ -845,7 +845,7 @@ discard block |
||
845 | 845 | |
846 | 846 | $statement .= $token->token; |
847 | 847 | |
848 | - if (($token->type === TokenType::Delimiter) && ! empty($token->token)) { |
|
848 | + if (($token->type === TokenType::Delimiter) && !empty($token->token)) { |
|
849 | 849 | $delimiter = $token->token; |
850 | 850 | $fullStatement = true; |
851 | 851 | break; |
@@ -854,7 +854,7 @@ discard block |
||
854 | 854 | |
855 | 855 | // No statement was found so we return the entire query as being the |
856 | 856 | // remaining part. |
857 | - if (! $fullStatement) { |
|
857 | + if (!$fullStatement) { |
|
858 | 858 | return [ |
859 | 859 | null, |
860 | 860 | $query, |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | * Gets the next token. Skips any irrelevant token (whitespaces and |
95 | 95 | * comments). |
96 | 96 | */ |
97 | - public function getNext(): Token|null |
|
97 | + public function getNext(): Token | null |
|
98 | 98 | { |
99 | 99 | for (; $this->idx < $this->count; ++$this->idx) { |
100 | 100 | if ( |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | * Gets the previous token. Skips any irrelevant token (whitespaces and |
113 | 113 | * comments). |
114 | 114 | */ |
115 | - public function getPrevious(): Token|null |
|
115 | + public function getPrevious(): Token | null |
|
116 | 116 | { |
117 | 117 | for (; $this->idx >= 0; --$this->idx) { |
118 | 118 | if ( |
@@ -131,9 +131,9 @@ discard block |
||
131 | 131 | * |
132 | 132 | * @param TokenType|TokenType[] $type the type |
133 | 133 | */ |
134 | - public function getPreviousOfType(TokenType|array $type): Token|null |
|
134 | + public function getPreviousOfType(TokenType | array $type): Token | null |
|
135 | 135 | { |
136 | - if (! is_array($type)) { |
|
136 | + if (!is_array($type)) { |
|
137 | 137 | $type = [$type]; |
138 | 138 | } |
139 | 139 | |
@@ -151,9 +151,9 @@ discard block |
||
151 | 151 | * |
152 | 152 | * @param TokenType|TokenType[] $type the type |
153 | 153 | */ |
154 | - public function getNextOfType(TokenType|array $type): Token|null |
|
154 | + public function getNextOfType(TokenType | array $type): Token | null |
|
155 | 155 | { |
156 | - if (! is_array($type)) { |
|
156 | + if (!is_array($type)) { |
|
157 | 157 | $type = [$type]; |
158 | 158 | } |
159 | 159 | |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | * @param TokenType $type the type of the token |
173 | 173 | * @param string $value the value of the token |
174 | 174 | */ |
175 | - public function getNextOfTypeAndValue(TokenType $type, $value): Token|null |
|
175 | + public function getNextOfTypeAndValue(TokenType $type, $value): Token | null |
|
176 | 176 | { |
177 | 177 | for (; $this->idx < $this->count; ++$this->idx) { |
178 | 178 | if (($this->tokens[$this->idx]->type === $type) && ($this->tokens[$this->idx]->value === $value)) { |
@@ -189,7 +189,7 @@ discard block |
||
189 | 189 | * @param TokenType $type the type of the token |
190 | 190 | * @param int $flag the flag of the token |
191 | 191 | */ |
192 | - public function getNextOfTypeAndFlag(TokenType $type, int $flag): Token|null |
|
192 | + public function getNextOfTypeAndFlag(TokenType $type, int $flag): Token | null |
|
193 | 193 | { |
194 | 194 | for (; $this->idx < $this->count; ++$this->idx) { |
195 | 195 | if (($this->tokens[$this->idx]->type === $type) && ($this->tokens[$this->idx]->flags === $flag)) { |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | * |
221 | 221 | * @param int $offset the offset to be returned |
222 | 222 | */ |
223 | - public function offsetGet($offset): Token|null |
|
223 | + public function offsetGet($offset): Token | null |
|
224 | 224 | { |
225 | 225 | return $offset < $this->count ? $this->tokens[$offset] : null; |
226 | 226 | } |
@@ -188,7 +188,7 @@ discard block |
||
188 | 188 | } |
189 | 189 | } |
190 | 190 | |
191 | - if (! empty($expr->type)) { |
|
191 | + if (!empty($expr->type)) { |
|
192 | 192 | $ret[] = $expr; |
193 | 193 | } |
194 | 194 | |
@@ -210,9 +210,9 @@ discard block |
||
210 | 210 | $ret = []; |
211 | 211 | foreach ($component as $c) { |
212 | 212 | $ret[] = array_search($c->type, self::JOINS) . ' ' . $c->expr |
213 | - . (! empty($c->on) |
|
213 | + . (!empty($c->on) |
|
214 | 214 | ? ' ON ' . Condition::buildAll($c->on) : '') |
215 | - . (! empty($c->using) |
|
215 | + . (!empty($c->using) |
|
216 | 216 | ? ' USING ' . $c->using->build() : ''); |
217 | 217 | } |
218 | 218 |
@@ -435,7 +435,7 @@ discard block |
||
435 | 435 | // The options of a clause should stay on the same line and everything that follows. |
436 | 436 | if ( |
437 | 437 | $this->options['parts_newline'] |
438 | - && ! $formattedOptions |
|
438 | + && !$formattedOptions |
|
439 | 439 | && empty(self::$inlineClauses[$lastClause]) |
440 | 440 | && ( |
441 | 441 | $curr->type !== TokenType::Keyword |
@@ -492,7 +492,7 @@ discard block |
||
492 | 492 | end($blocksLineEndings) === true |
493 | 493 | || ( |
494 | 494 | empty(self::$inlineClauses[$lastClause]) |
495 | - && ! $shortGroup |
|
495 | + && !$shortGroup |
|
496 | 496 | && $this->options['parts_newline'] |
497 | 497 | ) |
498 | 498 | ) { |
@@ -528,7 +528,7 @@ discard block |
||
528 | 528 | $lineEnded = false; |
529 | 529 | } elseif ( |
530 | 530 | $prev->keyword === 'DELIMITER' |
531 | - || ! ( |
|
531 | + || !( |
|
532 | 532 | ($prev->type === TokenType::Operator && ($prev->value === '.' || $prev->value === '(')) |
533 | 533 | // No space after . ( |
534 | 534 | || ($curr->type === TokenType::Operator |
@@ -643,13 +643,13 @@ discard block |
||
643 | 643 | |
644 | 644 | foreach ($this->options['formats'] as $format) { |
645 | 645 | if ( |
646 | - $token->type->value !== $format['type'] || ! (($token->flags & $format['flags']) === $format['flags']) |
|
646 | + $token->type->value !== $format['type'] || !(($token->flags & $format['flags']) === $format['flags']) |
|
647 | 647 | ) { |
648 | 648 | continue; |
649 | 649 | } |
650 | 650 | |
651 | 651 | // Running transformation function. |
652 | - if (! empty($format['function'])) { |
|
652 | + if (!empty($format['function'])) { |
|
653 | 653 | $func = $format['function']; |
654 | 654 | $text = $func($text); |
655 | 655 | } |
@@ -758,7 +758,7 @@ discard block |
||
758 | 758 | * |
759 | 759 | * @psalm-return 1|2|false |
760 | 760 | */ |
761 | - public static function isClause($token): int|false |
|
761 | + public static function isClause($token): int | false |
|
762 | 762 | { |
763 | 763 | if ( |
764 | 764 | ($token->type === TokenType::Keyword && isset(Parser::STATEMENT_PARSERS[$token->keyword])) |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | ) { |
89 | 89 | $expr->type = $token->keyword; |
90 | 90 | } elseif (($token->type === TokenType::Operator) && ($token->value === ',')) { |
91 | - if (! empty($expr->expr)) { |
|
91 | + if (!empty($expr->expr)) { |
|
92 | 92 | $ret[] = $expr; |
93 | 93 | } |
94 | 94 | |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | } |
102 | 102 | |
103 | 103 | // Last iteration was not processed. |
104 | - if (! empty($expr->expr)) { |
|
104 | + if (!empty($expr->expr)) { |
|
105 | 105 | $ret[] = $expr; |
106 | 106 | } |
107 | 107 |
@@ -174,9 +174,9 @@ discard block |
||
174 | 174 | } elseif ($state === 1) { |
175 | 175 | if (($token->type === TokenType::Operator) && ($token->value === '(')) { |
176 | 176 | $positionBeforeSearch = $list->idx; |
177 | - $list->idx++;// Ignore the current token "(" or the search condition will always be true |
|
177 | + $list->idx++; // Ignore the current token "(" or the search condition will always be true |
|
178 | 178 | $nextToken = $list->getNext(); |
179 | - $list->idx = $positionBeforeSearch;// Restore the position |
|
179 | + $list->idx = $positionBeforeSearch; // Restore the position |
|
180 | 180 | |
181 | 181 | if ($nextToken !== null && $nextToken->value === '(') { |
182 | 182 | // Switch to expression mode |
@@ -225,7 +225,7 @@ discard block |
||
225 | 225 | if ($token->type === TokenType::Operator) { |
226 | 226 | // This got back to here and we reached the end of the expression |
227 | 227 | if ($token->value === ')') { |
228 | - $state = 4;// go back to state 4 to fetch options |
|
228 | + $state = 4; // go back to state 4 to fetch options |
|
229 | 229 | continue; |
230 | 230 | } |
231 | 231 | |
@@ -261,7 +261,7 @@ discard block |
||
261 | 261 | public function build(): string |
262 | 262 | { |
263 | 263 | $ret = $this->type . ' '; |
264 | - if (! empty($this->name)) { |
|
264 | + if (!empty($this->name)) { |
|
265 | 265 | $ret .= Context::escape($this->name) . ' '; |
266 | 266 | } |
267 | 267 |
@@ -236,7 +236,7 @@ discard block |
||
236 | 236 | $state = 4; |
237 | 237 | } elseif ($token->type === TokenType::Symbol || $token->type === TokenType::None) { |
238 | 238 | $expr->name = $token->value; |
239 | - if (! $expr->isConstraint) { |
|
239 | + if (!$expr->isConstraint) { |
|
240 | 240 | $state = 2; |
241 | 241 | } |
242 | 242 | } elseif ($token->type === TokenType::Keyword) { |
@@ -277,7 +277,7 @@ discard block |
||
277 | 277 | |
278 | 278 | $state = 5; |
279 | 279 | } elseif ($state === 5) { |
280 | - if (! empty($expr->type) || ! empty($expr->key)) { |
|
280 | + if (!empty($expr->type) || !empty($expr->key)) { |
|
281 | 281 | $ret[] = $expr; |
282 | 282 | } |
283 | 283 | |
@@ -297,7 +297,7 @@ discard block |
||
297 | 297 | } |
298 | 298 | |
299 | 299 | // Last iteration was not saved. |
300 | - if (! empty($expr->type) || ! empty($expr->key)) { |
|
300 | + if (!empty($expr->type) || !empty($expr->key)) { |
|
301 | 301 | $ret[] = $expr; |
302 | 302 | } |
303 | 303 | |
@@ -322,16 +322,16 @@ discard block |
||
322 | 322 | $tmp .= Context::escape($this->name) . ' '; |
323 | 323 | } |
324 | 324 | |
325 | - if (! empty($this->type)) { |
|
325 | + if (!empty($this->type)) { |
|
326 | 326 | $this->type->lowercase = true; |
327 | 327 | $tmp .= $this->type->build() . ' '; |
328 | 328 | } |
329 | 329 | |
330 | - if (! empty($this->key)) { |
|
330 | + if (!empty($this->key)) { |
|
331 | 331 | $tmp .= $this->key . ' '; |
332 | 332 | } |
333 | 333 | |
334 | - if (! empty($this->references)) { |
|
334 | + if (!empty($this->references)) { |
|
335 | 335 | $tmp .= 'REFERENCES ' . $this->references . ' '; |
336 | 336 | } |
337 | 337 |
@@ -401,7 +401,7 @@ discard block |
||
401 | 401 | } elseif (($token->value === ',') && ($brackets === 0)) { |
402 | 402 | break; |
403 | 403 | } |
404 | - } elseif (! self::checkIfTokenQuotedSymbol($token) && $token->type !== TokenType::String) { |
|
404 | + } elseif (!self::checkIfTokenQuotedSymbol($token) && $token->type !== TokenType::String) { |
|
405 | 405 | if (isset(Parser::STATEMENT_PARSERS[$arrayKey]) && Parser::STATEMENT_PARSERS[$arrayKey] !== '') { |
406 | 406 | $list->idx++; // Ignore the current token |
407 | 407 | $nextToken = $list->getNext(); |
@@ -424,7 +424,7 @@ discard block |
||
424 | 424 | } elseif ( |
425 | 425 | (array_key_exists($arrayKey, self::DATABASE_OPTIONS) |
426 | 426 | || array_key_exists($arrayKey, self::TABLE_OPTIONS)) |
427 | - && ! self::checkIfColumnDefinitionKeyword($arrayKey) |
|
427 | + && !self::checkIfColumnDefinitionKeyword($arrayKey) |
|
428 | 428 | ) { |
429 | 429 | // This alter operation has finished, which means a comma |
430 | 430 | // was missing before start of new alter operation |
@@ -269,7 +269,7 @@ discard block |
||
269 | 269 | * |
270 | 270 | * Used by all `CREATE` statements. |
271 | 271 | */ |
272 | - public Expression|null $name = null; |
|
272 | + public Expression | null $name = null; |
|
273 | 273 | |
274 | 274 | /** |
275 | 275 | * The options of the entity (table, procedure, function, etc.). |
@@ -398,7 +398,7 @@ discard block |
||
398 | 398 | public function build(): string |
399 | 399 | { |
400 | 400 | $fields = ''; |
401 | - if (! empty($this->fields)) { |
|
401 | + if (!empty($this->fields)) { |
|
402 | 402 | if (is_array($this->fields)) { |
403 | 403 | $fields = CreateDefinition::buildAll($this->fields) . ' '; |
404 | 404 | } elseif ($this->fields instanceof ArrayObj) { |
@@ -437,23 +437,23 @@ discard block |
||
437 | 437 | |
438 | 438 | $partition = ''; |
439 | 439 | |
440 | - if (! empty($this->partitionBy)) { |
|
440 | + if (!empty($this->partitionBy)) { |
|
441 | 441 | $partition .= "\nPARTITION BY " . $this->partitionBy; |
442 | 442 | } |
443 | 443 | |
444 | - if (! empty($this->partitionsNum)) { |
|
444 | + if (!empty($this->partitionsNum)) { |
|
445 | 445 | $partition .= "\nPARTITIONS " . $this->partitionsNum; |
446 | 446 | } |
447 | 447 | |
448 | - if (! empty($this->subpartitionBy)) { |
|
448 | + if (!empty($this->subpartitionBy)) { |
|
449 | 449 | $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy; |
450 | 450 | } |
451 | 451 | |
452 | - if (! empty($this->subpartitionsNum)) { |
|
452 | + if (!empty($this->subpartitionsNum)) { |
|
453 | 453 | $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum; |
454 | 454 | } |
455 | 455 | |
456 | - if (! empty($this->partitions)) { |
|
456 | + if (!empty($this->partitions)) { |
|
457 | 457 | $partition .= "\n" . PartitionDefinition::buildAll($this->partitions); |
458 | 458 | } |
459 | 459 | |
@@ -647,7 +647,7 @@ discard block |
||
647 | 647 | $token = $list->getNextOfType(TokenType::Number); |
648 | 648 | --$list->idx; // `getNextOfType` also advances one position. |
649 | 649 | $this->subpartitionsNum = $token->value; |
650 | - } elseif (! empty($field)) { |
|
650 | + } elseif (!empty($field)) { |
|
651 | 651 | /* |
652 | 652 | * Handling the content of `PARTITION BY` and `SUBPARTITION BY`. |
653 | 653 | */ |
@@ -676,7 +676,7 @@ discard block |
||
676 | 676 | $field = null; |
677 | 677 | } |
678 | 678 | } elseif (($token->type === TokenType::Operator) && ($token->value === '(')) { |
679 | - if (! empty($this->partitionBy)) { |
|
679 | + if (!empty($this->partitionBy)) { |
|
680 | 680 | $this->partitions = ArrayObj::parse( |
681 | 681 | $parser, |
682 | 682 | $list, |