phpmyadmin / sql-parser

src/Tools/ContextGenerator.php

Spacing +4 added lines, -4 removed lines

@@ -170,7 +170,7 @@ 
 
             // Reserved, data types, keys, functions, etc. keywords.
             foreach (static::$labelsFlags as $label => $flags) {
-                if (! str_contains($value, $label)) {
+                if (!str_contains($value, $label)) {
                     continue;
                 }
 
@@ -190,7 +190,7 @@ 
             }
 
             $value = strtoupper($value);
-            if (! isset($types[$value])) {
+            if (!isset($types[$value])) {
                 $types[$value] = $type;
             } else {
                 $types[$value] |= $type;
@@ -200,11 +200,11 @@ 
         $ret = [];
         foreach ($types as $word => $type) {
             $len = strlen($word);
-            if (! isset($ret[$type])) {
+            if (!isset($ret[$type])) {
                 $ret[$type] = [];
             }
 
-            if (! isset($ret[$type][$len])) {
+            if (!isset($ret[$type][$len])) {
                 $ret[$type][$len] = [];
             }
 

src/Tools/TestGenerator.php

Spacing +8 added lines, -8 removed lines

@@ -83,7 +83,7 @@ 
         // The code below extracts only the relevant information.
 
         // Extracting lexer's errors.
-        if (! empty($lexer->errors)) {
+        if (!empty($lexer->errors)) {
             /** @var LexerException $err */
             foreach ($lexer->errors as $err) {
                 $lexerErrors[] = [
@@ -98,7 +98,7 @@ 
         }
 
         // Extracting parser's errors.
-        if (! empty($parser->errors)) {
+        if (!empty($parser->errors)) {
             /** @var ParserException $err */
             foreach ($parser->errors as $err) {
                 $parserErrors[] = [
@@ -137,11 +137,11 @@ 
         string $type,
         string $input,
         string $output,
-        string|null $debug = null,
+        string | null $debug = null,
         bool $ansi = false,
     ): void {
         // Support query types: `lexer` / `parser`.
-        if (! in_array($type, ['lexer', 'parser'])) {
+        if (!in_array($type, ['lexer', 'parser'])) {
             throw new Exception('Unknown test type (expected `lexer` or `parser`).');
         }
 
@@ -186,7 +186,7 @@ 
         );
 
         // Remove the project path from .out file, it changes for each dev
-        $projectFolder = dirname(__DIR__, 2);// Jump to root
+        $projectFolder = dirname(__DIR__, 2); // Jump to root
         $encoded = str_replace($projectFolder, '<project-root>', $encoded);
 
         file_put_contents($output, $encoded);
@@ -223,11 +223,11 @@ 
             if (is_dir($inputFile)) {
                 // Creating required directories to maintain the structure.
                 // Ignoring errors if the folder structure exists already.
-                if (! is_dir($outputFile)) {
+                if (!is_dir($outputFile)) {
                     mkdir($outputFile);
                 }
 
-                if (($debug !== null) && (! is_dir($debugFile))) {
+                if (($debug !== null) && (!is_dir($debugFile))) {
                     mkdir($debugFile);
                 }
 
@@ -242,7 +242,7 @@ 
                 }
 
                 // Building the test.
-                if (! file_exists($outputFile)) {
+                if (!file_exists($outputFile)) {
                     echo sprintf("Building test for %s...\n", $inputFile);
                     static::build(
                         str_contains($inputFile, 'lex') ? 'lexer' : 'parser',

src/Utils/Query.php

Spacing +20 added lines, -20 removed lines

@@ -299,23 +299,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)) {
@@ -330,15 +330,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;
         }
 
@@ -346,7 +346,7 @@ 
             $flags['union'] = true;
         }
 
-        if (! empty($statement->join)) {
+        if (!empty($statement->join)) {
             $flags['join'] = true;
         }
 
@@ -362,7 +362,7 @@ 
      * @return array<string, bool|string>
      * @psalm-return QueryFlagsType
      */
-    public static function getFlags(Statement|null $statement, bool $all = false): array
+    public static function getFlags(Statement | null $statement, bool $all = false): array
     {
         $flags = ['querytype' => false];
         if ($all) {
@@ -437,11 +437,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;
             }
         }
@@ -491,7 +491,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;
                 }
 
@@ -516,7 +516,7 @@ 
                         ];
                     }
 
-                    if (! in_array($arr, $ret['select_tables'])) {
+                    if (!in_array($arr, $ret['select_tables'])) {
                         $ret['select_tables'][] = $arr;
                     }
                 } else {
@@ -529,7 +529,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;
                     }
 
@@ -570,7 +570,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 [];
             }
@@ -615,7 +615,7 @@ 
         Statement $statement,
         TokensList $list,
         string $clause,
-        int|string $type = 0,
+        int | string $type = 0,
         bool $skipFirst = true,
     ): string {
         /**
@@ -747,7 +747,7 @@ 
         Statement $statement,
         TokensList $list,
         string $old,
-        string|null $new = null,
+        string | null $new = null,
         bool $onlyType = false,
     ): string {
         // TODO: Update the tokens list and the statement.
@@ -826,7 +826,7 @@ 
      *                                 the remaining part of the query and the last delimiter
      * @psalm-return array{string|null, string, string|null}
      */
-    public static function getFirstStatement(string $query, string|null $delimiter = null): array
+    public static function getFirstStatement(string $query, string | null $delimiter = null): array
     {
         $lexer = new Lexer($query, false, $delimiter);
         $list = $lexer->list;
@@ -854,7 +854,7 @@ 
 
             $statement .= $token->token;
 
-            if (($token->type === TokenType::Delimiter) && ! empty($token->token)) {
+            if (($token->type === TokenType::Delimiter) && !empty($token->token)) {
                 $delimiter = $token->token;
                 $fullStatement = true;
                 break;
@@ -863,7 +863,7 @@ 
 
         // No statement was found so we return the entire query as being the
         // remaining part.
-        if (! $fullStatement) {
+        if (!$fullStatement) {
             return [
                 null,
                 $query,

src/Utils/CLI.php

Spacing +11 added lines, -11 removed lines

@@ -36,7 +36,7 @@ 
     {
         foreach ($longopts as $value) {
             $value = rtrim($value, ':');
-            if (! isset($params[$value])) {
+            if (!isset($params[$value])) {
                 continue;
             }
 
@@ -55,13 +55,13 @@ 
      *
      * @return string[]|false[]|false
      */
-    public function getopt(string $opt, array $long): array|false
+    public function getopt(string $opt, array $long): array | false
     {
         return getopt($opt, $long);
     }
 
     /** @return string[]|false[]|false */
-    public function parseHighlight(): array|false
+    public function parseHighlight(): array | false
     {
         $longopts = [
             'help',
@@ -75,11 +75,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;
@@ -101,7 +101,7 @@ 
             return 0;
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -136,7 +136,7 @@ 
     }
 
     /** @return string[]|false[]|false */
-    public function parseLint(): array|false
+    public function parseLint(): array | false
     {
         $longopts = [
             'help',
@@ -171,7 +171,7 @@ 
             Context::load($params['c']);
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -211,7 +211,7 @@ 
     }
 
     /** @return string[]|false[]|false */
-    public function parseTokenize(): array|false
+    public function parseTokenize(): array | false
     {
         $longopts = [
             'help',
@@ -241,7 +241,7 @@ 
             return 0;
         }
 
-        if (! isset($params['q'])) {
+        if (!isset($params['q'])) {
             $stdIn = $this->readStdin();
 
             if ($stdIn) {
@@ -277,7 +277,7 @@ 
         return 1;
     }
 
-    public function readStdin(): string|false|null
+    public function readStdin(): string | false | null
     {
         $read = [STDIN];
         $write = [];

src/Token.php

Spacing +3 added lines, -3 removed lines

@@ -128,7 +128,7 @@ 
         switch ($this->type) {
             case TokenType::Keyword:
                 $this->keyword = strtoupper($this->token);
-                if (! ($this->flags & self::FLAG_KEYWORD_RESERVED)) {
+                if (!($this->flags & self::FLAG_KEYWORD_RESERVED)) {
                     // Unreserved keywords should stay the way they are because they
                     // might represent field names.
                     return $this->token;
@@ -153,7 +153,7 @@ 
                     }
                 } elseif (($this->flags & self::FLAG_NUMBER_APPROXIMATE) || ($this->flags & self::FLAG_NUMBER_FLOAT)) {
                     $ret = (float) $ret;
-                } elseif (! ($this->flags & self::FLAG_NUMBER_BINARY)) {
+                } elseif (!($this->flags & self::FLAG_NUMBER_BINARY)) {
                     $ret = (int) $ret;
                 }
 
@@ -188,7 +188,7 @@ 
                     // in PHP 5.3- the `null` parameter isn't handled correctly.
                     $str = mb_substr(
                         $str,
-                        ! empty($str[1]) && ($str[1] === '@') ? 2 : 1,
+                        !empty($str[1]) && ($str[1] === '@') ? 2 : 1,
                         mb_strlen($str),
                         'UTF-8',
                     );

src/Components/DataType.php

Spacing +4 added lines, -4 removed lines

@@ -78,9 +78,9 @@ 
      * @param OptionsArray   $options    the options of this data type
      */
     public function __construct(
-        string|null $name = null,
+        string | null $name = null,
         array $parameters = [],
-        OptionsArray|null $options = null,
+        OptionsArray | null $options = null,
     ) {
         $this->name = $name;
         $this->parameters = $parameters;
@@ -92,7 +92,7 @@ 
      * @param TokensList           $list    the list of tokens that are being parsed
      * @param array<string, mixed> $options parameters for parsing
      */
-    public static function parse(Parser $parser, TokensList $list, array $options = []): DataType|null
+    public static function parse(Parser $parser, TokensList $list, array $options = []): DataType | null
     {
         $ret = new static();
 
@@ -122,7 +122,7 @@ 
 
             if ($state === 0) {
                 $ret->name = strtoupper((string) $token->value);
-                if (($token->type !== TokenType::Keyword) || (! ($token->flags & Token::FLAG_KEYWORD_DATA_TYPE))) {
+                if (($token->type !== TokenType::Keyword) || (!($token->flags & Token::FLAG_KEYWORD_DATA_TYPE))) {
                     $parser->error('Unrecognized data type.', $token);
                 }
 

src/Components/IntoKeyword.php

Spacing +7 added lines, -7 removed lines

@@ -113,12 +113,12 @@ 
      * @param bool|null              $fieldsKeyword options for OPTIONS keyword
      */
     public function __construct(
-        string|null $type = null,
-        string|Expression|null $dest = null,
-        array|null $columns = null,
-        array|null $values = null,
-        OptionsArray|null $fieldsOptions = null,
-        bool|null $fieldsKeyword = null,
+        string | null $type = null,
+        string | Expression | null $dest = null,
+        array | null $columns = null,
+        array | null $values = null,
+        OptionsArray | null $fieldsOptions = null,
+        bool | null $fieldsKeyword = null,
     ) {
         $this->type = $type;
         $this->dest = $dest;
@@ -254,7 +254,7 @@ 
     public function build(): string
     {
         if ($this->dest instanceof Expression) {
-            $columns = ! empty($this->columns) ? '(`' . implode('`, `', $this->columns) . '`)' : '';
+            $columns = !empty($this->columns) ? '(`' . implode('`, `', $this->columns) . '`)' : '';
 
             return $this->dest . $columns;
         }

src/Components/IndexHint.php

Spacing +6 added lines, -6 removed lines

@@ -19,17 +19,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
@@ -45,9 +45,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/Components/Expression.php

Spacing +22 added lines, -22 removed lines

@@ -112,10 +112,10 @@ 
      * @param string|null $alias    the name of the alias
      */
     public function __construct(
-        string|null $database = null,
-        string|null $table = null,
-        string|null $column = null,
-        string|null $alias = null,
+        string | null $database = null,
+        string | null $table = null,
+        string | null $column = null,
+        string | null $alias = null,
     ) {
         if (($column === null) && ($alias === null)) {
             $this->expr = $database; // case 1
@@ -160,7 +160,7 @@ 
      *
      * @throws ParserException
      */
-    public static function parse(Parser $parser, TokensList $list, array $options = []): Expression|null
+    public static function parse(Parser $parser, TokensList $list, array $options = []): Expression | null
     {
         $ret = new static();
 
@@ -203,7 +203,7 @@ 
         ];
 
         // When a field is parsed, no parentheses are expected.
-        if (! empty($options['parseField'])) {
+        if (!empty($options['parseField'])) {
             $options['breakOnParentheses'] = true;
             $options['field'] = $options['parseField'];
         }
@@ -230,14 +230,14 @@ 
             }
 
             if ($token->type === TokenType::Keyword) {
-                if (($brackets > 0) && empty($ret->subquery) && ! empty(Parser::STATEMENT_PARSERS[$token->keyword])) {
+                if (($brackets > 0) && empty($ret->subquery) && !empty(Parser::STATEMENT_PARSERS[$token->keyword])) {
                     // A `(` was previously found and this keyword is the
                     // beginning of a statement, so this is a subquery.
                     $ret->subquery = $token->keyword;
                 } elseif (
                     ($token->flags & Token::FLAG_KEYWORD_FUNCTION)
                     && (empty($options['parseField'])
-                    && ! $alias)
+                    && !$alias)
                 ) {
                     $isExpr = true;
                 } elseif (($token->flags & Token::FLAG_KEYWORD_RESERVED) && ($brackets === 0)) {
@@ -249,7 +249,7 @@ 
                     }
 
                     if ($token->keyword === 'AS') {
-                        if (! empty($options['breakOnAlias'])) {
+                        if (!empty($options['breakOnAlias'])) {
                             break;
                         }
 
@@ -272,7 +272,7 @@ 
                     }
 
                     $isExpr = true;
-                } elseif ($brackets === 0 && strlen((string) $ret->expr) > 0 && ! $alias) {
+                } elseif ($brackets === 0 && strlen((string) $ret->expr) > 0 && !$alias) {
                     /* End of expression */
                     break;
                 }
@@ -288,7 +288,7 @@ 
                 || (($token->type === TokenType::Operator)
                 && ($token->value !== '.'))
             ) {
-                if (! empty($options['parseField'])) {
+                if (!empty($options['parseField'])) {
                     break;
                 }
 
@@ -298,7 +298,7 @@ 
             }
 
             if ($token->type === TokenType::Operator) {
-                if (! empty($options['breakOnParentheses']) && (($token->value === '(') || ($token->value === ')'))) {
+                if (!empty($options['breakOnParentheses']) && (($token->value === '(') || ($token->value === ')'))) {
                     // No brackets were expected.
                     break;
                 }
@@ -322,7 +322,7 @@ 
 
                     --$brackets;
                     if ($brackets === 0) {
-                        if (! empty($options['parenthesesDelimited'])) {
+                        if (!empty($options['parenthesesDelimited'])) {
                             // The current token is the last bracket, the next
                             // one will be outside the expression.
                             $ret->expr .= $token->token;
@@ -348,7 +348,7 @@ 
 
             if ($alias) {
                 // An alias is expected (the keyword `AS` was previously found).
-                if (! empty($ret->alias)) {
+                if (!empty($ret->alias)) {
                     $parser->error('An alias was previously found.', $token);
                     break;
                 }
@@ -362,15 +362,15 @@ 
                     && ($prev[0] === null
                         || (($prev[0]->type !== TokenType::Operator || $prev[0]->token === ')')
                             && ($prev[0]->type !== TokenType::Keyword
-                                || ! ($prev[0]->flags & Token::FLAG_KEYWORD_RESERVED))))
+                                || !($prev[0]->flags & Token::FLAG_KEYWORD_RESERVED))))
                     && (($prev[1]->type === TokenType::String)
                         || ($prev[1]->type === TokenType::Symbol
-                            && ! ($prev[1]->flags & Token::FLAG_SYMBOL_VARIABLE)
-                            && ! ($prev[1]->flags & Token::FLAG_SYMBOL_PARAMETER))
+                            && !($prev[1]->flags & Token::FLAG_SYMBOL_VARIABLE)
+                            && !($prev[1]->flags & Token::FLAG_SYMBOL_PARAMETER))
                         || ($prev[1]->type === TokenType::None
                             && $prev[1]->token !== 'OVER'))
                 ) {
-                    if (! empty($ret->alias)) {
+                    if (!empty($ret->alias)) {
                         $parser->error('An alias was previously found.', $token);
                         break;
                     }
@@ -401,7 +401,7 @@ 
                     // Found a `.` which means we expect a column name and
                     // the column name we parsed is actually the table name
                     // and the table name is actually a database name.
-                    if (! empty($ret->database) || $dot) {
+                    if (!empty($ret->database) || $dot) {
                         $parser->error('Unexpected dot.', $token);
                     }
 
@@ -418,11 +418,11 @@ 
                         $dot = false;
                     } else {
                         // No alias is expected.
-                        if (! empty($options['breakOnAlias'])) {
+                        if (!empty($options['breakOnAlias'])) {
                             break;
                         }
 
-                        if (! empty($ret->alias)) {
+                        if (!empty($ret->alias)) {
                             $parser->error('An alias was previously found.', $token);
                             break;
                         }
@@ -470,7 +470,7 @@ 
             $ret = implode('.', Context::escapeAll($fields));
         }
 
-        if (! empty($this->alias)) {
+        if (!empty($this->alias)) {
             $ret .= ' AS ' . Context::escape($this->alias);
         }