phpmyadmin / sql-parser

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/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,

src/Components/OptionsArray.php

Spacing +10 added lines, -10 removed lines

@@ -116,7 +116,7 @@ 
 
             if ($lastOption === null) {
                 $upper = strtoupper($token->token);
-                if (! isset($options[$upper])) {
+                if (!isset($options[$upper])) {
                     // There is no option to be processed.
                     break;
                 }
@@ -153,7 +153,7 @@ 
             }
 
             if ($state === 0) {
-                if (! is_array($lastOption)) {
+                if (!is_array($lastOption)) {
                     // This is a just keyword option without any value.
                     // This is the beginning and the end of it.
                     $ret->options[$lastOptionId] = $token->value;
@@ -230,7 +230,7 @@ 
                 $ret->options[$lastOptionId]['expr'] .= $token->token;
 
                 if (
-                    ! (($token->token === '(') && ($brackets === 1)
+                    !(($token->token === '(') && ($brackets === 1)
                     || (($token->token === ')') && ($brackets === 0)))
                 ) {
                     // First pair of brackets is being skipped.
@@ -286,12 +286,12 @@ 
 
         $options = [];
         foreach ($component->options as $option) {
-            if (! is_array($option)) {
+            if (!is_array($option)) {
                 $options[] = $option;
             } else {
                 $options[] = $option['name']
-                    . (! empty($option['equals']) ? '=' : ' ')
-                    . (! empty($option['expr']) ? $option['expr'] : $option['value']);
+                    . (!empty($option['equals']) ? '=' : ' ')
+                    . (!empty($option['expr']) ? $option['expr'] : $option['value']);
             }
         }
 
@@ -311,10 +311,10 @@ 
     {
         foreach ($this->options as $option) {
             if (is_array($option)) {
-                if (! strcasecmp($key, $option['name'])) {
+                if (!strcasecmp($key, $option['name'])) {
                     return $getExpr ? $option['expr'] : $option['value'];
                 }
-            } elseif (! strcasecmp($key, $option)) {
+            } elseif (!strcasecmp($key, $option)) {
                 return true;
             }
         }
@@ -333,12 +333,12 @@ 
     {
         foreach ($this->options as $idx => $option) {
             if (is_array($option)) {
-                if (! strcasecmp($key, $option['name'])) {
+                if (!strcasecmp($key, $option['name'])) {
                     unset($this->options[$idx]);
 
                     return true;
                 }
-            } elseif (! strcasecmp($key, $option)) {
+            } elseif (!strcasecmp($key, $option)) {
                 unset($this->options[$idx]);
 
                 return true;

src/Components/CreateDefinition.php

Spacing +6 added lines, -6 removed lines

@@ -243,7 +243,7 @@ 
                     $state = 4;
                 } elseif ($token->type === Token::TYPE_SYMBOL || $token->type === Token::TYPE_NONE) {
                     $expr->name = $token->value;
-                    if (! $expr->isConstraint) {
+                    if (!$expr->isConstraint) {
                         $state = 2;
                     }
                 } elseif ($token->type === Token::TYPE_KEYWORD) {
@@ -284,7 +284,7 @@ 
 
                 $state = 5;
             } elseif ($state === 5) {
-                if (! empty($expr->type) || ! empty($expr->key)) {
+                if (!empty($expr->type) || !empty($expr->key)) {
                     $ret[] = $expr;
                 }
 
@@ -304,7 +304,7 @@ 
         }
 
         // Last iteration was not saved.
-        if (! empty($expr->type) || ! empty($expr->key)) {
+        if (!empty($expr->type) || !empty($expr->key)) {
             $ret[] = $expr;
         }
 
@@ -336,16 +336,16 @@ 
             $tmp .= Context::escape($component->name) . ' ';
         }
 
-        if (! empty($component->type)) {
+        if (!empty($component->type)) {
             $component->type->lowercase = true;
             $tmp .= DataType::build($component->type) . ' ';
         }
 
-        if (! empty($component->key)) {
+        if (!empty($component->key)) {
             $tmp .= $component->key . ' ';
         }
 
-        if (! empty($component->references)) {
+        if (!empty($component->references)) {
             $tmp .= 'REFERENCES ' . $component->references . ' ';
         }
 

src/Components/IntoKeyword.php

Spacing +1 added lines, -1 removed lines

@@ -264,7 +264,7 @@
     public static function build($component): string
     {
         if ($component->dest instanceof Expression) {
-            $columns = ! empty($component->columns) ? '(`' . implode('`, `', $component->columns) . '`)' : '';
+            $columns = !empty($component->columns) ? '(`' . implode('`, `', $component->columns) . '`)' : '';
 
             return $component->dest . $columns;
         }

src/Components/Key.php

Spacing +4 added lines, -4 removed lines

@@ -179,9 +179,9 @@ 
             } elseif ($state === 1) {
                 if (($token->type === Token::TYPE_OPERATOR) && ($token->value === '(')) {
                     $positionBeforeSearch = $list->idx;
-                    $list->idx++;// Ignore the current token "(" or the search condition will always be true
+                    $list->idx++; // Ignore the current token "(" or the search condition will always be true
                     $nextToken = $list->getNext();
-                    $list->idx = $positionBeforeSearch;// Restore the position
+                    $list->idx = $positionBeforeSearch; // Restore the position
 
                     if ($nextToken !== null && $nextToken->value === '(') {
                         // Switch to expression mode
@@ -230,7 +230,7 @@ 
                 if ($token->type === Token::TYPE_OPERATOR) {
                     // This got back to here and we reached the end of the expression
                     if ($token->value === ')') {
-                        $state = 4;// go back to state 4 to fetch options
+                        $state = 4; // go back to state 4 to fetch options
                         continue;
                     }
 
@@ -269,7 +269,7 @@ 
     public static function build($component): string
     {
         $ret = $component->type . ' ';
-        if (! empty($component->name)) {
+        if (!empty($component->name)) {
             $ret .= Context::escape($component->name) . ' ';
         }