phpmyadmin / sql-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/Table.php

Spacing +6 added lines, -6 removed lines

@@ -30,7 +30,7 @@ 
      */
     public static function getForeignKeys(CreateStatement $statement): array
     {
-        if (empty($statement->fields) || (! is_array($statement->fields)) || (! $statement->options->has('TABLE'))) {
+        if (empty($statement->fields) || (!is_array($statement->fields)) || (!$statement->options->has('TABLE'))) {
             return [];
         }
 
@@ -43,7 +43,7 @@ 
 
             $columns = [];
             foreach ($field->key->columns as $column) {
-                if (! isset($column['name'])) {
+                if (!isset($column['name'])) {
                     continue;
                 }
 
@@ -55,7 +55,7 @@ 
                 'index_list' => $columns,
             ];
 
-            if (! empty($field->references)) {
+            if (!empty($field->references)) {
                 $tmp['ref_db_name'] = $field->references->table->database;
                 $tmp['ref_table_name'] = $field->references->table->table;
                 $tmp['ref_index_list'] = $field->references->columns;
@@ -96,7 +96,7 @@ 
      */
     public static function getFields(CreateStatement $statement): array
     {
-        if (empty($statement->fields) || (! is_array($statement->fields)) || (! $statement->options->has('TABLE'))) {
+        if (empty($statement->fields) || (!is_array($statement->fields)) || (!$statement->options->has('TABLE'))) {
             return [];
         }
 
@@ -113,7 +113,7 @@ 
                 'timestamp_not_null' => false,
             ];
 
-            if (! $field->options) {
+            if (!$field->options) {
                 continue;
             }
 
@@ -140,7 +140,7 @@ 
 
             $option = $field->options->has('AS');
 
-            if (! $option) {
+            if (!$option) {
                 continue;
             }
 

src/Components/Limit.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
      * @param int|string $rowCount the row count
      * @param int|string $offset   the offset
      */
-    public function __construct(int|string $rowCount = 0, int|string $offset = 0)
+    public function __construct(int | string $rowCount = 0, int | string $offset = 0)
     {
         $this->rowCount = $rowCount;
         $this->offset = $offset;
@@ -87,7 +87,7 @@ 
 
             // Skip if not a number or a bind parameter (?)
             if (
-                ! ($token->type === TokenType::Number
+                !($token->type === TokenType::Number
                     || ($token->type === TokenType::Symbol && ($token->flags & Token::FLAG_SYMBOL_PARAMETER)))
             ) {
                 break;

src/Components/FunctionCall.php

Spacing +2 added lines, -2 removed lines

@@ -34,7 +34,7 @@ 
      * @param string|null            $name       the name of the function to be called
      * @param string[]|ArrayObj|null $parameters the parameters of this function
      */
-    public function __construct(string|null $name = null, array|ArrayObj|null $parameters = null)
+    public function __construct(string | null $name = null, array | ArrayObj | null $parameters = null)
     {
         $this->name = $name;
         if (is_array($parameters)) {
@@ -87,7 +87,7 @@ 
                 if ($token->type === TokenType::Operator && $token->value === '(') {
                     --$list->idx; // ArrayObj needs to start with `(`
                     $state = 1;
-                    continue;// do not add this token to the name
+                    continue; // do not add this token to the name
                 }
 
                 $ret->name .= $token->value;

src/Components/RenameOperation.php

Spacing +2 added lines, -2 removed lines

@@ -34,7 +34,7 @@ 
      * @param Expression $old old expression
      * @param Expression $new new expression containing new name
      */
-    public function __construct(Expression|null $old = null, Expression|null $new = null)
+    public function __construct(Expression | null $old = null, Expression | null $new = null)
     {
         $this->old = $old;
         $this->new = $new;
@@ -138,7 +138,7 @@ 
         }
 
         // Last iteration was not saved.
-        if (! empty($expr->old)) {
+        if (!empty($expr->old)) {
             $ret[] = $expr;
         }
 

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/Condition.php

Spacing +4 added lines, -4 removed lines

@@ -80,7 +80,7 @@ 
     /**
      * @param string $expr the condition or the operator
      */
-    public function __construct(string|null $expr = null)
+    public function __construct(string | null $expr = null)
     {
         $this->expr = trim((string) $expr);
     }
@@ -147,7 +147,7 @@ 
                 } else {
                     // The expression ended.
                     $expr->expr = trim($expr->expr);
-                    if (! empty($expr->expr)) {
+                    if (!empty($expr->expr)) {
                         $ret[] = $expr;
                     }
 
@@ -165,7 +165,7 @@ 
             if (
                 ($token->type === TokenType::Keyword)
                 && ($token->flags & Token::FLAG_KEYWORD_RESERVED)
-                && ! ($token->flags & Token::FLAG_KEYWORD_FUNCTION)
+                && !($token->flags & Token::FLAG_KEYWORD_FUNCTION)
             ) {
                 if ($token->value === 'BETWEEN') {
                     $betweenBefore = true;
@@ -208,7 +208,7 @@ 
 
         // Last iteration was not processed.
         $expr->expr = trim($expr->expr);
-        if (! empty($expr->expr)) {
+        if (!empty($expr->expr)) {
             $ret[] = $expr;
         }
 

src/Components/GroupKeyword.php

Spacing +4 added lines, -4 removed lines

@@ -18,7 +18,7 @@ 
 final class GroupKeyword implements Component
 {
     /** @var 'ASC'|'DESC'|null */
-    public string|null $type = null;
+    public string | null $type = null;
 
     /**
      * The expression that is used for grouping.
@@ -30,7 +30,7 @@ 
     /**
      * @param Expression $expr the expression that we are sorting by
      */
-    public function __construct(Expression|null $expr = null)
+    public function __construct(Expression | null $expr = null)
     {
         $this->expr = $expr;
     }
@@ -88,7 +88,7 @@ 
                 ) {
                     $expr->type = $token->keyword;
                 } elseif (($token->type === TokenType::Operator) && ($token->value === ',')) {
-                    if (! empty($expr->expr)) {
+                    if (!empty($expr->expr)) {
                         $ret[] = $expr;
                     }
 
@@ -101,7 +101,7 @@ 
         }
 
         // Last iteration was not processed.
-        if (! empty($expr->expr)) {
+        if (!empty($expr->expr)) {
             $ret[] = $expr;
         }
 

src/Components/AlterOperation.php

Spacing +5 added lines, -5 removed lines

@@ -264,9 +264,9 @@ 
      * @param Token[]                    $unknown    unparsed tokens found at the end of operation
      */
     public function __construct(
-        OptionsArray|null $options = null,
-        Expression|string|null $field = null,
-        array|null $partitions = null,
+        OptionsArray | null $options = null,
+        Expression | string | null $field = null,
+        array | null $partitions = null,
         public array $unknown = []
     ) {
         $this->partitions = $partitions;
@@ -401,7 +401,7 @@ 
                     } elseif (($token->value === ',') && ($brackets === 0)) {
                         break;
                     }
-                } elseif (! self::checkIfTokenQuotedSymbol($token) && $token->type !== TokenType::String) {
+                } elseif (!self::checkIfTokenQuotedSymbol($token) && $token->type !== TokenType::String) {
                     if (isset(Parser::STATEMENT_PARSERS[$arrayKey]) && Parser::STATEMENT_PARSERS[$arrayKey] !== '') {
                         $list->idx++; // Ignore the current token
                         $nextToken = $list->getNext();
@@ -424,7 +424,7 @@ 
                     } elseif (
                         (array_key_exists($arrayKey, self::DATABASE_OPTIONS)
                         || array_key_exists($arrayKey, self::TABLE_OPTIONS))
-                        && ! self::checkIfColumnDefinitionKeyword($arrayKey)
+                        && !self::checkIfColumnDefinitionKeyword($arrayKey)
                     ) {
                         // This alter operation has finished, which means a comma
                         // was missing before start of new alter operation