@@ -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 | } |
@@ -847,7 +847,7 @@ discard block |
||
847 | 847 | |
848 | 848 | $statement .= $token->token; |
849 | 849 | |
850 | - if (($token->type === Token::TYPE_DELIMITER) && ! empty($token->token)) { |
|
850 | + if (($token->type === Token::TYPE_DELIMITER) && !empty($token->token)) { |
|
851 | 851 | $delimiter = $token->token; |
852 | 852 | $fullStatement = true; |
853 | 853 | break; |
@@ -856,7 +856,7 @@ discard block |
||
856 | 856 | |
857 | 857 | // No statement was found so we return the entire query as being the |
858 | 858 | // remaining part. |
859 | - if (! $fullStatement) { |
|
859 | + if (!$fullStatement) { |
|
860 | 860 | return [ |
861 | 861 | null, |
862 | 862 | $query, |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | |
117 | 117 | if ($lastOption === null) { |
118 | 118 | $upper = strtoupper($token->token); |
119 | - if (! isset($options[$upper])) { |
|
119 | + if (!isset($options[$upper])) { |
|
120 | 120 | // There is no option to be processed. |
121 | 121 | break; |
122 | 122 | } |
@@ -153,7 +153,7 @@ discard block |
||
153 | 153 | } |
154 | 154 | |
155 | 155 | if ($state === 0) { |
156 | - if (! is_array($lastOption)) { |
|
156 | + if (!is_array($lastOption)) { |
|
157 | 157 | // This is a just keyword option without any value. |
158 | 158 | // This is the beginning and the end of it. |
159 | 159 | $ret->options[$lastOptionId] = $token->value; |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | $ret->options[$lastOptionId]['expr'] .= $token->token; |
231 | 231 | |
232 | 232 | if ( |
233 | - ! (($token->token === '(') && ($brackets === 1) |
|
233 | + !(($token->token === '(') && ($brackets === 1) |
|
234 | 234 | || (($token->token === ')') && ($brackets === 0))) |
235 | 235 | ) { |
236 | 236 | // First pair of brackets is being skipped. |
@@ -286,12 +286,12 @@ discard block |
||
286 | 286 | |
287 | 287 | $options = []; |
288 | 288 | foreach ($component->options as $option) { |
289 | - if (! is_array($option)) { |
|
289 | + if (!is_array($option)) { |
|
290 | 290 | $options[] = $option; |
291 | 291 | } else { |
292 | 292 | $options[] = $option['name'] |
293 | - . (! empty($option['equals']) ? '=' : ' ') |
|
294 | - . (! empty($option['expr']) ? $option['expr'] : $option['value']); |
|
293 | + . (!empty($option['equals']) ? '=' : ' ') |
|
294 | + . (!empty($option['expr']) ? $option['expr'] : $option['value']); |
|
295 | 295 | } |
296 | 296 | } |
297 | 297 | |
@@ -311,10 +311,10 @@ discard block |
||
311 | 311 | { |
312 | 312 | foreach ($this->options as $option) { |
313 | 313 | if (is_array($option)) { |
314 | - if (! strcasecmp($key, $option['name'])) { |
|
314 | + if (!strcasecmp($key, $option['name'])) { |
|
315 | 315 | return $getExpr ? $option['expr'] : $option['value']; |
316 | 316 | } |
317 | - } elseif (! strcasecmp($key, $option)) { |
|
317 | + } elseif (!strcasecmp($key, $option)) { |
|
318 | 318 | return true; |
319 | 319 | } |
320 | 320 | } |
@@ -333,12 +333,12 @@ discard block |
||
333 | 333 | { |
334 | 334 | foreach ($this->options as $idx => $option) { |
335 | 335 | if (is_array($option)) { |
336 | - if (! strcasecmp($key, $option['name'])) { |
|
336 | + if (!strcasecmp($key, $option['name'])) { |
|
337 | 337 | unset($this->options[$idx]); |
338 | 338 | |
339 | 339 | return true; |
340 | 340 | } |
341 | - } elseif (! strcasecmp($key, $option)) { |
|
341 | + } elseif (!strcasecmp($key, $option)) { |
|
342 | 342 | unset($this->options[$idx]); |
343 | 343 | |
344 | 344 | return true; |
@@ -280,7 +280,7 @@ discard block |
||
280 | 280 | * |
281 | 281 | * Used by all `CREATE` statements. |
282 | 282 | */ |
283 | - public Expression|null $name = null; |
|
283 | + public Expression | null $name = null; |
|
284 | 284 | |
285 | 285 | /** |
286 | 286 | * The options of the entity (table, procedure, function, etc.). |
@@ -409,7 +409,7 @@ discard block |
||
409 | 409 | public function build(): string |
410 | 410 | { |
411 | 411 | $fields = ''; |
412 | - if (! empty($this->fields)) { |
|
412 | + if (!empty($this->fields)) { |
|
413 | 413 | if (is_array($this->fields)) { |
414 | 414 | $fields = CreateDefinition::build($this->fields) . ' '; |
415 | 415 | } elseif ($this->fields instanceof ArrayObj) { |
@@ -448,23 +448,23 @@ discard block |
||
448 | 448 | |
449 | 449 | $partition = ''; |
450 | 450 | |
451 | - if (! empty($this->partitionBy)) { |
|
451 | + if (!empty($this->partitionBy)) { |
|
452 | 452 | $partition .= "\nPARTITION BY " . $this->partitionBy; |
453 | 453 | } |
454 | 454 | |
455 | - if (! empty($this->partitionsNum)) { |
|
455 | + if (!empty($this->partitionsNum)) { |
|
456 | 456 | $partition .= "\nPARTITIONS " . $this->partitionsNum; |
457 | 457 | } |
458 | 458 | |
459 | - if (! empty($this->subpartitionBy)) { |
|
459 | + if (!empty($this->subpartitionBy)) { |
|
460 | 460 | $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy; |
461 | 461 | } |
462 | 462 | |
463 | - if (! empty($this->subpartitionsNum)) { |
|
463 | + if (!empty($this->subpartitionsNum)) { |
|
464 | 464 | $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum; |
465 | 465 | } |
466 | 466 | |
467 | - if (! empty($this->partitions)) { |
|
467 | + if (!empty($this->partitions)) { |
|
468 | 468 | $partition .= "\n" . PartitionDefinition::build($this->partitions); |
469 | 469 | } |
470 | 470 | |
@@ -488,7 +488,7 @@ discard block |
||
488 | 488 | . OptionsArray::build($this->options) . ' ' |
489 | 489 | . Expression::build($this->name) . ' ' |
490 | 490 | . $fields . ' AS ' . $builtStatement |
491 | - . (! empty($this->body) ? TokensList::build($this->body) : '') . ' ' |
|
491 | + . (!empty($this->body) ? TokensList::build($this->body) : '') . ' ' |
|
492 | 492 | . OptionsArray::build($this->entityOptions); |
493 | 493 | } |
494 | 494 | |
@@ -658,7 +658,7 @@ discard block |
||
658 | 658 | $token = $list->getNextOfType(Token::TYPE_NUMBER); |
659 | 659 | --$list->idx; // `getNextOfType` also advances one position. |
660 | 660 | $this->subpartitionsNum = $token->value; |
661 | - } elseif (! empty($field)) { |
|
661 | + } elseif (!empty($field)) { |
|
662 | 662 | /* |
663 | 663 | * Handling the content of `PARTITION BY` and `SUBPARTITION BY`. |
664 | 664 | */ |
@@ -687,7 +687,7 @@ discard block |
||
687 | 687 | $field = null; |
688 | 688 | } |
689 | 689 | } elseif (($token->type === Token::TYPE_OPERATOR) && ($token->value === '(')) { |
690 | - if (! empty($this->partitionBy)) { |
|
690 | + if (!empty($this->partitionBy)) { |
|
691 | 691 | $this->partitions = ArrayObj::parse( |
692 | 692 | $parser, |
693 | 693 | $list, |
@@ -357,13 +357,13 @@ discard block |
||
357 | 357 | * |
358 | 358 | * @param bool $isReserved checks if the keyword is reserved |
359 | 359 | */ |
360 | - public static function isKeyword(string $string, bool $isReserved = false): int|null |
|
360 | + public static function isKeyword(string $string, bool $isReserved = false): int | null |
|
361 | 361 | { |
362 | 362 | $upperString = strtoupper($string); |
363 | 363 | |
364 | 364 | if ( |
365 | - ! isset(static::$keywords[$upperString]) |
|
366 | - || ($isReserved && ! (static::$keywords[$upperString] & Token::FLAG_KEYWORD_RESERVED)) |
|
365 | + !isset(static::$keywords[$upperString]) |
|
366 | + || ($isReserved && !(static::$keywords[$upperString] & Token::FLAG_KEYWORD_RESERVED)) |
|
367 | 367 | ) { |
368 | 368 | return null; |
369 | 369 | } |
@@ -374,7 +374,7 @@ discard block |
||
374 | 374 | /** |
375 | 375 | * Checks if the given string is an operator and returns the appropriate flag for the operator. |
376 | 376 | */ |
377 | - public static function isOperator(string $string): int|null |
|
377 | + public static function isOperator(string $string): int | null |
|
378 | 378 | { |
379 | 379 | return static::$operators[$string] ?? null; |
380 | 380 | } |
@@ -392,7 +392,7 @@ discard block |
||
392 | 392 | * |
393 | 393 | * @return int|null the appropriate flag for the comment type |
394 | 394 | */ |
395 | - public static function isComment(string $string, bool $end = false): int|null |
|
395 | + public static function isComment(string $string, bool $end = false): int | null |
|
396 | 396 | { |
397 | 397 | if ($string === '') { |
398 | 398 | return null; |
@@ -455,7 +455,7 @@ discard block |
||
455 | 455 | * |
456 | 456 | * @return int|null the appropriate flag for the symbol type |
457 | 457 | */ |
458 | - public static function isSymbol(string $string): int|null |
|
458 | + public static function isSymbol(string $string): int | null |
|
459 | 459 | { |
460 | 460 | if ($string === '') { |
461 | 461 | return null; |
@@ -483,7 +483,7 @@ discard block |
||
483 | 483 | * |
484 | 484 | * @return int|null the appropriate flag for the string type |
485 | 485 | */ |
486 | - public static function isString(string $string): int|null |
|
486 | + public static function isString(string $string): int | null |
|
487 | 487 | { |
488 | 488 | if ($string === '') { |
489 | 489 | return null; |
@@ -537,7 +537,7 @@ discard block |
||
537 | 537 | $context = self::$contextPrefix . $context; |
538 | 538 | } |
539 | 539 | |
540 | - if (! class_exists($context)) { |
|
540 | + if (!class_exists($context)) { |
|
541 | 541 | return false; |
542 | 542 | } |
543 | 543 | |
@@ -559,7 +559,7 @@ discard block |
||
559 | 559 | * |
560 | 560 | * @return string|null The loaded context. `null` if no context was loaded. |
561 | 561 | */ |
562 | - public static function loadClosest(string $context = ''): string|null |
|
562 | + public static function loadClosest(string $context = ''): string | null |
|
563 | 563 | { |
564 | 564 | $length = strlen($context); |
565 | 565 | for ($i = $length; $i > 0;) { |
@@ -573,7 +573,7 @@ discard block |
||
573 | 573 | $i -= 2; |
574 | 574 | $part = substr($context, $i, 2); |
575 | 575 | /* No more numeric parts to strip */ |
576 | - if (! is_numeric($part)) { |
|
576 | + if (!is_numeric($part)) { |
|
577 | 577 | break 2; |
578 | 578 | } |
579 | 579 | } while (intval($part) === 0 && $i > 0); |
@@ -675,7 +675,7 @@ discard block |
||
675 | 675 | */ |
676 | 676 | public static function escape(string $str, string $quote = '`') |
677 | 677 | { |
678 | - if ((static::$mode & self::SQL_MODE_NO_ENCLOSING_QUOTES) && (! static::isKeyword($str, true))) { |
|
678 | + if ((static::$mode & self::SQL_MODE_NO_ENCLOSING_QUOTES) && (!static::isKeyword($str, true))) { |
|
679 | 679 | return $str; |
680 | 680 | } |
681 | 681 | |
@@ -719,7 +719,7 @@ discard block |
||
719 | 719 | * |
720 | 720 | * @return bool false on empty param, true/false on given constant/int value |
721 | 721 | */ |
722 | - public static function hasMode(int|null $flag = null): bool |
|
722 | + public static function hasMode(int | null $flag = null): bool |
|
723 | 723 | { |
724 | 724 | if (empty($flag)) { |
725 | 725 | return false; |
@@ -243,7 +243,7 @@ discard block |
||
243 | 243 | $state = 4; |
244 | 244 | } elseif ($token->type === Token::TYPE_SYMBOL || $token->type === Token::TYPE_NONE) { |
245 | 245 | $expr->name = $token->value; |
246 | - if (! $expr->isConstraint) { |
|
246 | + if (!$expr->isConstraint) { |
|
247 | 247 | $state = 2; |
248 | 248 | } |
249 | 249 | } elseif ($token->type === Token::TYPE_KEYWORD) { |
@@ -284,7 +284,7 @@ discard block |
||
284 | 284 | |
285 | 285 | $state = 5; |
286 | 286 | } elseif ($state === 5) { |
287 | - if (! empty($expr->type) || ! empty($expr->key)) { |
|
287 | + if (!empty($expr->type) || !empty($expr->key)) { |
|
288 | 288 | $ret[] = $expr; |
289 | 289 | } |
290 | 290 | |
@@ -304,7 +304,7 @@ discard block |
||
304 | 304 | } |
305 | 305 | |
306 | 306 | // Last iteration was not saved. |
307 | - if (! empty($expr->type) || ! empty($expr->key)) { |
|
307 | + if (!empty($expr->type) || !empty($expr->key)) { |
|
308 | 308 | $ret[] = $expr; |
309 | 309 | } |
310 | 310 | |
@@ -336,16 +336,16 @@ discard block |
||
336 | 336 | $tmp .= Context::escape($component->name) . ' '; |
337 | 337 | } |
338 | 338 | |
339 | - if (! empty($component->type)) { |
|
339 | + if (!empty($component->type)) { |
|
340 | 340 | $component->type->lowercase = true; |
341 | 341 | $tmp .= DataType::build($component->type) . ' '; |
342 | 342 | } |
343 | 343 | |
344 | - if (! empty($component->key)) { |
|
344 | + if (!empty($component->key)) { |
|
345 | 345 | $tmp .= $component->key . ' '; |
346 | 346 | } |
347 | 347 | |
348 | - if (! empty($component->references)) { |
|
348 | + if (!empty($component->references)) { |
|
349 | 349 | $tmp .= 'REFERENCES ' . $component->references . ' '; |
350 | 350 | } |
351 | 351 |
@@ -264,7 +264,7 @@ |
||
264 | 264 | public static function build($component): string |
265 | 265 | { |
266 | 266 | if ($component->dest instanceof Expression) { |
267 | - $columns = ! empty($component->columns) ? '(`' . implode('`, `', $component->columns) . '`)' : ''; |
|
267 | + $columns = !empty($component->columns) ? '(`' . implode('`, `', $component->columns) . '`)' : ''; |
|
268 | 268 | |
269 | 269 | return $component->dest . $columns; |
270 | 270 | } |
@@ -179,9 +179,9 @@ discard block |
||
179 | 179 | } elseif ($state === 1) { |
180 | 180 | if (($token->type === Token::TYPE_OPERATOR) && ($token->value === '(')) { |
181 | 181 | $positionBeforeSearch = $list->idx; |
182 | - $list->idx++;// Ignore the current token "(" or the search condition will always be true |
|
182 | + $list->idx++; // Ignore the current token "(" or the search condition will always be true |
|
183 | 183 | $nextToken = $list->getNext(); |
184 | - $list->idx = $positionBeforeSearch;// Restore the position |
|
184 | + $list->idx = $positionBeforeSearch; // Restore the position |
|
185 | 185 | |
186 | 186 | if ($nextToken !== null && $nextToken->value === '(') { |
187 | 187 | // Switch to expression mode |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | if ($token->type === Token::TYPE_OPERATOR) { |
231 | 231 | // This got back to here and we reached the end of the expression |
232 | 232 | if ($token->value === ')') { |
233 | - $state = 4;// go back to state 4 to fetch options |
|
233 | + $state = 4; // go back to state 4 to fetch options |
|
234 | 234 | continue; |
235 | 235 | } |
236 | 236 | |
@@ -269,7 +269,7 @@ discard block |
||
269 | 269 | public static function build($component): string |
270 | 270 | { |
271 | 271 | $ret = $component->type . ' '; |
272 | - if (! empty($component->name)) { |
|
272 | + if (!empty($component->name)) { |
|
273 | 273 | $ret .= Context::escape($component->name) . ' '; |
274 | 274 | } |
275 | 275 |
@@ -50,7 +50,7 @@ |
||
50 | 50 | */ |
51 | 51 | public static function build($component): string |
52 | 52 | { |
53 | - if (! isset($component->statement)) { |
|
53 | + if (!isset($component->statement)) { |
|
54 | 54 | throw new RuntimeException('No statement inside WITH'); |
55 | 55 | } |
56 | 56 |
@@ -424,7 +424,7 @@ discard block |
||
424 | 424 | } elseif (($token->value === ',') && ($brackets === 0)) { |
425 | 425 | break; |
426 | 426 | } |
427 | - } elseif (! self::checkIfTokenQuotedSymbol($token)) { |
|
427 | + } elseif (!self::checkIfTokenQuotedSymbol($token)) { |
|
428 | 428 | // If the current token is "SET" or "ENUM", we want to avoid the token between their parenthesis in |
429 | 429 | // the unknown tokens. |
430 | 430 | if (in_array($token->value, ['SET', 'ENUM'], true)) { |
@@ -443,7 +443,7 @@ discard block |
||
443 | 443 | ); |
444 | 444 | break; |
445 | 445 | } |
446 | - } elseif (! empty(Parser::$statementParsers[$token->value])) { |
|
446 | + } elseif (!empty(Parser::$statementParsers[$token->value])) { |
|
447 | 447 | // We have reached the end of ALTER operation and suddenly found |
448 | 448 | // a start to new statement, but have not found a delimiter between them |
449 | 449 | $parser->error( |
@@ -454,7 +454,7 @@ discard block |
||
454 | 454 | } elseif ( |
455 | 455 | (array_key_exists($arrayKey, self::$databaseOptions) |
456 | 456 | || array_key_exists($arrayKey, self::$tableOptions)) |
457 | - && ! self::checkIfColumnDefinitionKeyword($arrayKey) |
|
457 | + && !self::checkIfColumnDefinitionKeyword($arrayKey) |
|
458 | 458 | ) { |
459 | 459 | // This alter operation has finished, which means a comma |
460 | 460 | // was missing before start of new alter operation |