phpmyadmin / sql-parser

src/Statements/WithStatement.php

Spacing +4 added lines, -4 removed lines

@@ -133,7 +133,7 @@ 
                     break;
                 }
             } elseif ($state === 2) {
-                if (! ($token->type === Token::TYPE_KEYWORD && $token->keyword === 'AS')) {
+                if (!($token->type === Token::TYPE_KEYWORD && $token->keyword === 'AS')) {
                     $parser->error('AS keyword was expected.', $token);
                     break;
                 }
@@ -145,7 +145,7 @@ 
                 $list->idx++; // Ignore the current token
                 $nextKeyword = $list->getNext();
 
-                if (! ($token->value === '(' && ($nextKeyword && $nextKeyword->value === 'SELECT'))) {
+                if (!($token->value === '(' && ($nextKeyword && $nextKeyword->value === 'SELECT'))) {
                     $parser->error('Subquery of the CTE was expected.', $token);
                     $list->idx = $idxBeforeGetNext;
                     break;
@@ -295,7 +295,7 @@ 
     /**
      * Get tokens within the WITH expression to use them in another parser
      */
-    private function getSubTokenList(TokensList $list): ParserException|TokensList
+    private function getSubTokenList(TokensList $list): ParserException | TokensList
     {
         $idx = $list->idx;
         $token = $list->tokens[$list->idx];
@@ -311,7 +311,7 @@ 
             }
 
             ++$list->idx;
-            if (! isset($list->tokens[$list->idx])) {
+            if (!isset($list->tokens[$list->idx])) {
                 break;
             }
 

src/Utils/CLI.php

Spacing +11 added lines, -11 removed lines

@@ -39,7 +39,7 @@ 
     {
         foreach ($longopts as $value) {
             $value = rtrim($value, ':');
-            if (! isset($params[$value])) {
+            if (!isset($params[$value])) {
                 continue;
             }
 
@@ -62,7 +62,7 @@ 
      *
      * @return string[]|false[]|false
      */
-    public function getopt($opt, $long): array|false
+    public function getopt($opt, $long): array | false
     {
         return getopt($opt, $long);
     }
@@ -70,7 +70,7 @@ 
     /**
      * @return string[]|false[]|false
      */
-    public function parseHighlight(): array|false
+    public function parseHighlight(): array | false
     {
         $longopts = [
             'help',
@@ -84,11 +84,11 @@ 
         }
 
         $this->mergeLongOpts($params, $longopts);
-        if (! isset($params['f'])) {
+        if (!isset($params['f'])) {
             $params['f'] = 'cli';
         }
 
-        if (! in_array($params['f'], ['html', 'cli', 'text'])) {
+        if (!in_array($params['f'], ['html', 'cli', 'text'])) {
             echo "ERROR: Invalid value for format!\n";
 
             return false;
@@ -113,7 +113,7 @@ 
             return 0;
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -153,7 +153,7 @@ 
     /**
      * @return string[]|false[]|false
      */
-    public function parseLint(): array|false
+    public function parseLint(): array | false
     {
         $longopts = [
             'help',
@@ -187,7 +187,7 @@ 
             Context::load($params['c']);
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -232,7 +232,7 @@ 
     /**
      * @return string[]|false[]|false
      */
-    public function parseTokenize(): array|false
+    public function parseTokenize(): array | false
     {
         $longopts = [
             'help',
@@ -261,7 +261,7 @@ 
             return 0;
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -297,7 +297,7 @@ 
         return 1;
     }
 
-    public function readStdin(): string|false|null
+    public function readStdin(): string | false | null
     {
         $read = [STDIN];
         $write = [];

src/Statements/LoadStatement.php

Spacing +2 added lines, -2 removed lines

@@ -149,14 +149,14 @@
      *
      * @var Expression[]|null
      */
-    public array|null $columnNamesOrUserVariables = null;
+    public array | null $columnNamesOrUserVariables = null;
 
     /**
      * SET clause's updated values(optional).
      *
      * @var SetOperation[]|null
      */
-    public array|null $set = null;
+    public array | null $set = null;
 
     /**
      * Ignore 'number' LINES/ROWS.

src/Statements/DeleteStatement.php

Spacing +6 added lines, -6 removed lines

@@ -106,28 +106,28 @@ 
      *
      * @var Expression[]|null
      */
-    public array|null $from = null;
+    public array | null $from = null;
 
     /**
      * Joins.
      *
      * @var JoinKeyword[]|null
      */
-    public array|null $join = null;
+    public array | null $join = null;
 
     /**
      * Tables used as sources for this statement.
      *
      * @var Expression[]|null
      */
-    public array|null $using = null;
+    public array | null $using = null;
 
     /**
      * Columns used in this statement.
      *
      * @var Expression[]|null
      */
-    public array|null $columns = null;
+    public array | null $columns = null;
 
     /**
      * Partitions used as source for this statement.
@@ -141,14 +141,14 @@ 
      *
      * @var Condition[]|null
      */
-    public array|null $where = null;
+    public array | null $where = null;
 
     /**
      * Specifies the order of the rows in the result set.
      *
      * @var OrderKeyword[]|null
      */
-    public array|null $order = null;
+    public array | null $order = null;
 
     /**
      * Conditions used for limiting the size of the result set.

src/Statements/SelectStatement.php

Spacing +6 added lines, -6 removed lines

@@ -391,28 +391,28 @@ 
         $expressions = $this->from;
 
         // Adding expressions from JOIN.
-        if (! empty($this->join)) {
+        if (!empty($this->join)) {
             foreach ($this->join as $join) {
                 $expressions[] = $join->expr;
             }
         }
 
         foreach ($expressions as $expr) {
-            if (! isset($expr->table) || ($expr->table === '')) {
+            if (!isset($expr->table) || ($expr->table === '')) {
                 continue;
             }
 
             $thisDb = isset($expr->database) && ($expr->database !== '') ?
                 $expr->database : $database;
 
-            if (! isset($retval[$thisDb])) {
+            if (!isset($retval[$thisDb])) {
                 $retval[$thisDb] = [
                     'alias' => null,
                     'tables' => [],
                 ];
             }
 
-            if (! isset($retval[$thisDb]['tables'][$expr->table])) {
+            if (!isset($retval[$thisDb]['tables'][$expr->table])) {
                 $retval[$thisDb]['tables'][$expr->table] = [
                     'alias' => isset($expr->alias) && ($expr->alias !== '') ?
                         $expr->alias : null,
@@ -420,7 +420,7 @@ 
                 ];
             }
 
-            if (! isset($tables[$thisDb])) {
+            if (!isset($tables[$thisDb])) {
                 $tables[$thisDb] = [];
             }
 
@@ -428,7 +428,7 @@ 
         }
 
         foreach ($this->expr as $expr) {
-            if (! isset($expr->column, $expr->alias) || ($expr->column === '') || ($expr->alias === '')) {
+            if (!isset($expr->column, $expr->alias) || ($expr->column === '') || ($expr->alias === '')) {
                 continue;
             }
 

src/Components/IndexHint.php

Spacing +6 added lines, -6 removed lines

@@ -20,17 +20,17 @@ 
     /**
      * The type of hint (USE/FORCE/IGNORE)
      */
-    public string|null $type;
+    public string | null $type;
 
     /**
      * What the hint is for (INDEX/KEY)
      */
-    public string|null $indexOrKey;
+    public string | null $indexOrKey;
 
     /**
      * The clause for which this hint is (JOIN/ORDER BY/GROUP BY)
      */
-    public string|null $for;
+    public string | null $for;
 
     /**
      * List of indexes in this hint
@@ -46,9 +46,9 @@ 
      * @param Expression[] $indexes    List of indexes in this hint
      */
     public function __construct(
-        string|null $type = null,
-        string|null $indexOrKey = null,
-        string|null $for = null,
+        string | null $type = null,
+        string | null $indexOrKey = null,
+        string | null $for = null,
         array $indexes = []
     ) {
         $this->type = $type;

src/Parser.php

Spacing +3 added lines, -3 removed lines

@@ -496,7 +496,7 @@ 
                 $list->idx = $lastIdx;
             } elseif (empty(static::$statementParsers[$token->keyword])) {
                 // Checking if it is a known statement that can be parsed.
-                if (! isset(static::$statementParsers[$token->keyword])) {
+                if (!isset(static::$statementParsers[$token->keyword])) {
                     // A statement is considered recognized if the parser
                     // is aware that it is a statement, but it does not have
                     // a parser for it yet.
@@ -536,7 +536,7 @@ 
 
             // Handles unions.
             if (
-                ! empty($unionType)
+                !empty($unionType)
                 && ($lastStatement instanceof SelectStatement)
                 && ($statement instanceof SelectStatement)
             ) {
@@ -623,7 +623,7 @@ 
      *
      * @throws ParserException throws the exception, if strict mode is enabled.
      */
-    public function error($msg, Token|null $token = null, $code = 0): void
+    public function error($msg, Token | null $token = null, $code = 0): void
     {
         $error = new ParserException(
             Translator::gettext($msg),

src/Utils/Formatter.php

Spacing +6 added lines, -6 removed lines

@@ -436,7 +436,7 @@ 
                 // The options of a clause should stay on the same line and everything that follows.
                 if (
                     $this->options['parts_newline']
-                    && ! $formattedOptions
+                    && !$formattedOptions
                     && empty(self::$inlineClauses[$lastClause])
                     && (
                         $curr->type !== Token::TYPE_KEYWORD
@@ -496,7 +496,7 @@ 
                         end($blocksLineEndings) === true
                         || (
                             empty(self::$inlineClauses[$lastClause])
-                            && ! $shortGroup
+                            && !$shortGroup
                             && $this->options['parts_newline']
                         )
                     ) {
@@ -532,7 +532,7 @@ 
                     $lineEnded = false;
                 } elseif (
                     $prev->keyword === 'DELIMITER'
-                    || ! (
+                    || !(
                     ($prev->type === Token::TYPE_OPERATOR && ($prev->value === '.' || $prev->value === '('))
                     // No space after . (
                     || ($curr->type === Token::TYPE_OPERATOR
@@ -648,12 +648,12 @@ 
         static $prev;
 
         foreach ($this->options['formats'] as $format) {
-            if ($token->type !== $format['type'] || ! (($token->flags & $format['flags']) === $format['flags'])) {
+            if ($token->type !== $format['type'] || !(($token->flags & $format['flags']) === $format['flags'])) {
                 continue;
             }
 
             // Running transformation function.
-            if (! empty($format['function'])) {
+            if (!empty($format['function'])) {
                 $func = $format['function'];
                 $text = $func($text);
             }
@@ -764,7 +764,7 @@ 
      *
      * @psalm-return 1|2|false
      */
-    public static function isClause($token): int|false
+    public static function isClause($token): int | false
     {
         if (
             ($token->type === Token::TYPE_KEYWORD && isset(Parser::$statementParsers[$token->keyword]))

src/Utils/Query.php

Spacing +16 added lines, -16 removed lines

@@ -300,23 +300,23 @@ 
             $flags['distinct'] = true;
         }
 
-        if (! empty($statement->group) || ! empty($statement->having)) {
+        if (!empty($statement->group) || !empty($statement->having)) {
             $flags['is_group'] = true;
         }
 
-        if (! empty($statement->into) && ($statement->into->type === 'OUTFILE')) {
+        if (!empty($statement->into) && ($statement->into->type === 'OUTFILE')) {
             $flags['is_export'] = true;
         }
 
         $expressions = $statement->expr;
-        if (! empty($statement->join)) {
+        if (!empty($statement->join)) {
             foreach ($statement->join as $join) {
                 $expressions[] = $join->expr;
             }
         }
 
         foreach ($expressions as $expr) {
-            if (! empty($expr->function)) {
+            if (!empty($expr->function)) {
                 if ($expr->function === 'COUNT') {
                     $flags['is_count'] = true;
                 } elseif (in_array($expr->function, static::$functions)) {
@@ -331,15 +331,15 @@ 
             $flags['is_subquery'] = true;
         }
 
-        if (! empty($statement->procedure) && ($statement->procedure->name === 'ANALYSE')) {
+        if (!empty($statement->procedure) && ($statement->procedure->name === 'ANALYSE')) {
             $flags['is_analyse'] = true;
         }
 
-        if (! empty($statement->group)) {
+        if (!empty($statement->group)) {
             $flags['group'] = true;
         }
 
-        if (! empty($statement->having)) {
+        if (!empty($statement->having)) {
             $flags['having'] = true;
         }
 
@@ -347,7 +347,7 @@ 
             $flags['union'] = true;
         }
 
-        if (! empty($statement->join)) {
+        if (!empty($statement->join)) {
             $flags['join'] = true;
         }
 
@@ -438,11 +438,11 @@ 
             || ($statement instanceof UpdateStatement)
             || ($statement instanceof DeleteStatement)
         ) {
-            if (! empty($statement->limit)) {
+            if (!empty($statement->limit)) {
                 $flags['limit'] = true;
             }
 
-            if (! empty($statement->order)) {
+            if (!empty($statement->order)) {
                 $flags['order'] = true;
             }
         }
@@ -492,7 +492,7 @@ 
             // Finding tables' aliases and their associated real names.
             $tableAliases = [];
             foreach ($statement->from as $expr) {
-                if (! isset($expr->table, $expr->alias) || ($expr->table === '') || ($expr->alias === '')) {
+                if (!isset($expr->table, $expr->alias) || ($expr->table === '') || ($expr->alias === '')) {
                     continue;
                 }
 
@@ -517,7 +517,7 @@ 
                         ];
                     }
 
-                    if (! in_array($arr, $ret['select_tables'])) {
+                    if (!in_array($arr, $ret['select_tables'])) {
                         $ret['select_tables'][] = $arr;
                     }
                 } else {
@@ -530,7 +530,7 @@ 
             // extracted from the FROM clause.
             if ($ret['select_tables'] === []) {
                 foreach ($statement->from as $expr) {
-                    if (! isset($expr->table) || ($expr->table === '')) {
+                    if (!isset($expr->table) || ($expr->table === '')) {
                         continue;
                     }
 
@@ -571,7 +571,7 @@ 
         } elseif (($statement instanceof AlterStatement) || ($statement instanceof TruncateStatement)) {
             $expressions = [$statement->table];
         } elseif ($statement instanceof DropStatement) {
-            if (! $statement->options->has('TABLE')) {
+            if (!$statement->options->has('TABLE')) {
                 // No tables are dropped.
                 return [];
             }
@@ -847,7 +847,7 @@ 
 
             $statement .= $token->token;
 
-            if (($token->type === Token::TYPE_DELIMITER) && ! empty($token->token)) {
+            if (($token->type === Token::TYPE_DELIMITER) && !empty($token->token)) {
                 $delimiter = $token->token;
                 $fullStatement = true;
                 break;
@@ -856,7 +856,7 @@ 
 
         // No statement was found so we return the entire query as being the
         // remaining part.
-        if (! $fullStatement) {
+        if (!$fullStatement) {
             return [
                 null,
                 $query,