phpmyadmin / sql-parser

src/Components/OptionsArray.php

Spacing +10 added lines, -10 removed lines

@@ -123,7 +123,7 @@ 
 
             if ($lastOption === null) {
                 $upper = strtoupper($token->token);
-                if (! isset($options[$upper])) {
+                if (!isset($options[$upper])) {
                     // There is no option to be processed.
                     break;
                 }
@@ -160,7 +160,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;
@@ -234,7 +234,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.
@@ -292,12 +292,12 @@ 
 
         $options = [];
         foreach ($component->options as $option) {
-            if (! is_array($option)) {
+            if (!is_array($option)) {
                 $options[] = $option;
             } else {
                 $options[] = $option['name']
-                    . (! empty($option['equals']) && $option['equals'] ? '=' : ' ')
-                    . (! empty($option['expr']) ? $option['expr'] : $option['value']);
+                    . (!empty($option['equals']) && $option['equals'] ? '=' : ' ')
+                    . (!empty($option['expr']) ? $option['expr'] : $option['value']);
             }
         }
 
@@ -317,10 +317,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;
             }
         }
@@ -339,12 +339,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/GroupKeyword.php

Spacing +2 added lines, -2 removed lines

@@ -94,7 +94,7 @@ 
                 ) {
                     $expr->type = $token->keyword;
                 } elseif (($token->type === Token::TYPE_OPERATOR) && ($token->value === ',')) {
-                    if (! empty($expr->expr)) {
+                    if (!empty($expr->expr)) {
                         $ret[] = $expr;
                     }
 
@@ -107,7 +107,7 @@ 
         }
 
         // Last iteration was not processed.
-        if (! empty($expr->expr)) {
+        if (!empty($expr->expr)) {
             $ret[] = $expr;
         }
 

src/Components/CaseExpression.php

Spacing +3 added lines, -3 removed lines

@@ -211,7 +211,7 @@ 
 
                 // Handle optional AS keyword before alias
                 if ($token->type === Token::TYPE_KEYWORD && $token->keyword === 'AS') {
-                    if ($asFound || ! empty($ret->alias)) {
+                    if ($asFound || !empty($ret->alias)) {
                         $parser->error('Potential duplicate alias of CASE expression.', $token);
                         break;
                     }
@@ -233,11 +233,11 @@ 
                 if (
                     $asFound
                     || $token->type === Token::TYPE_STRING
-                    || ($token->type === Token::TYPE_SYMBOL && ! $token->flags & Token::FLAG_SYMBOL_VARIABLE)
+                    || ($token->type === Token::TYPE_SYMBOL && !$token->flags & Token::FLAG_SYMBOL_VARIABLE)
                     || $token->type === Token::TYPE_NONE
                 ) {
                     // 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;
                     }

src/Components/Condition.php

Spacing +3 added lines, -3 removed lines

@@ -154,7 +154,7 @@ 
                 } else {
                     // The expression ended.
                     $expr->expr = trim($expr->expr);
-                    if (! empty($expr->expr)) {
+                    if (!empty($expr->expr)) {
                         $ret[] = $expr;
                     }
 
@@ -172,7 +172,7 @@ 
             if (
                 ($token->type === Token::TYPE_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;
@@ -215,7 +215,7 @@ 
 
         // Last iteration was not processed.
         $expr->expr = trim($expr->expr);
-        if (! empty($expr->expr)) {
+        if (!empty($expr->expr)) {
             $ret[] = $expr;
         }
 

src/Statement.php

Spacing +11 added lines, -11 removed lines

@@ -173,7 +173,7 @@ 
 
             // Checking if this field was already built.
             if ($type & 1) {
-                if (! empty($built[$field])) {
+                if (!empty($built[$field])) {
                     continue;
                 }
 
@@ -186,7 +186,7 @@ 
             }
 
             // Checking if the result of the builder should be added.
-            if (! ($type & 1)) {
+            if (!($type & 1)) {
                 continue;
             }
 
@@ -317,10 +317,10 @@ 
 
             // Looking for duplicated clauses.
             if (
-                ! empty(Parser::$KEYWORD_PARSERS[$token->value])
-                || ! empty(Parser::$STATEMENT_PARSERS[$token->value])
+                !empty(Parser::$KEYWORD_PARSERS[$token->value])
+                || !empty(Parser::$STATEMENT_PARSERS[$token->value])
             ) {
-                if (! empty($parsedClauses[$token->value])) {
+                if (!empty($parsedClauses[$token->value])) {
                     $parser->error('This type of clause was previously parsed.', $token);
                     break;
                 }
@@ -333,18 +333,18 @@ 
             // but it might be the beginning of a statement of truncate,
             // so let the value use the keyword field for truncate type.
             $tokenValue = in_array($token->keyword, ['TRUNCATE']) ? $token->keyword : $token->value;
-            if (! empty(Parser::$KEYWORD_PARSERS[$tokenValue]) && $list->idx < $list->count) {
+            if (!empty(Parser::$KEYWORD_PARSERS[$tokenValue]) && $list->idx < $list->count) {
                 $class = Parser::$KEYWORD_PARSERS[$tokenValue]['class'];
                 $field = Parser::$KEYWORD_PARSERS[$tokenValue]['field'];
-                if (! empty(Parser::$KEYWORD_PARSERS[$tokenValue]['options'])) {
+                if (!empty(Parser::$KEYWORD_PARSERS[$tokenValue]['options'])) {
                     $options = Parser::$KEYWORD_PARSERS[$tokenValue]['options'];
                 }
             }
 
             // Checking if this is the beginning of the statement.
-            if (! empty(Parser::$STATEMENT_PARSERS[$token->keyword])) {
+            if (!empty(Parser::$STATEMENT_PARSERS[$token->keyword])) {
                 if (
-                    ! empty(static::$CLAUSES) // Undefined for some statements.
+                    !empty(static::$CLAUSES) // Undefined for some statements.
                     && empty(static::$CLAUSES[$token->value])
                 ) {
                     // Some keywords (e.g. `SET`) may be the beginning of a
@@ -359,7 +359,7 @@ 
                     break;
                 }
 
-                if (! $parsedOptions) {
+                if (!$parsedOptions) {
                     if (empty(static::$OPTIONS[$token->value])) {
                         // Skipping keyword because if it is not a option.
                         ++$list->idx;
@@ -529,7 +529,7 @@ 
                 if ($minJoin === 0 && stripos($clauseType, 'JOIN')) {
                     // First JOIN clause is detected
                     $minJoin = $maxJoin = $clauseStartIdx;
-                } elseif ($minJoin !== 0 && ! stripos($clauseType, 'JOIN')) {
+                } elseif ($minJoin !== 0 && !stripos($clauseType, 'JOIN')) {
                     // After a previous JOIN clause, a non-JOIN clause has been detected
                     $maxJoin = $lastIdx;
                 } elseif ($maxJoin < $clauseStartIdx && stripos($clauseType, 'JOIN')) {

src/Utils/Query.php

Spacing +18 added lines, -18 removed lines

@@ -232,7 +232,7 @@ 
         $flags['querytype'] = 'SELECT';
         $flags['is_select'] = true;
 
-        if (! empty($statement->from)) {
+        if (!empty($statement->from)) {
             $flags['select_from'] = true;
         }
 
@@ -240,23 +240,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)) {
@@ -271,23 +271,23 @@ 
             $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;
         }
 
-        if (! empty($statement->union)) {
+        if (!empty($statement->union)) {
             $flags['union'] = true;
         }
 
-        if (! empty($statement->join)) {
+        if (!empty($statement->join)) {
             $flags['join'] = true;
         }
 
@@ -377,11 +377,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;
             }
         }
@@ -426,7 +426,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;
                 }
 
@@ -451,7 +451,7 @@ 
                         ];
                     }
 
-                    if (! in_array($arr, $ret['select_tables'])) {
+                    if (!in_array($arr, $ret['select_tables'])) {
                         $ret['select_tables'][] = $arr;
                     }
                 } else {
@@ -464,7 +464,7 @@ 
             // extracted from the FROM clause.
             if (empty($ret['select_tables'])) {
                 foreach ($statement->from as $expr) {
-                    if (! isset($expr->table) || ($expr->table === '')) {
+                    if (!isset($expr->table) || ($expr->table === '')) {
                         continue;
                     }
 
@@ -505,7 +505,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 [];
             }
@@ -791,7 +791,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;
@@ -800,7 +800,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/Formatter.php

Spacing +5 added lines, -5 removed lines

@@ -429,7 +429,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::$INLINE_CLAUSES[$lastClause])
                     && (
                         $curr->type !== Token::TYPE_KEYWORD
@@ -489,7 +489,7 @@ 
                         end($blocksLineEndings) === true
                         || (
                             empty(self::$INLINE_CLAUSES[$lastClause])
-                            && ! $shortGroup
+                            && !$shortGroup
                             && $this->options['parts_newline']
                         )
                     ) {
@@ -531,7 +531,7 @@ 
                     if (
                         // A space after delimiters that are longer than 2 characters.
                         $prev->keyword === 'DELIMITER'
-                        || ! (
+                        || !(
                             ($prev->type === Token::TYPE_OPERATOR && ($prev->value === '.' || $prev->value === '('))
                             // No space after . (
                             || ($curr->type === Token::TYPE_OPERATOR
@@ -645,12 +645,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);
             }

src/Utils/Misc.php

Spacing +7 added lines, -7 removed lines

@@ -25,7 +25,7 @@ 
      */
     public static function getAliases($statement, $database)
     {
-        if (! ($statement instanceof SelectStatement) || empty($statement->expr) || empty($statement->from)) {
+        if (!($statement instanceof SelectStatement) || empty($statement->expr) || empty($statement->from)) {
             return [];
         }
 
@@ -42,28 +42,28 @@ 
         $expressions = $statement->from;
 
         // Adding expressions from JOIN.
-        if (! empty($statement->join)) {
+        if (!empty($statement->join)) {
             foreach ($statement->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,
@@ -71,7 +71,7 @@ 
                 ];
             }
 
-            if (! isset($tables[$thisDb])) {
+            if (!isset($tables[$thisDb])) {
                 $tables[$thisDb] = [];
             }
 
@@ -79,7 +79,7 @@ 
         }
 
         foreach ($statement->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/Token.php

Spacing +3 added lines, -3 removed lines

@@ -222,7 +222,7 @@ 
         switch ($this->type) {
             case self::TYPE_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;
@@ -247,7 +247,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;
                 }
 
@@ -282,7 +282,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'
                     );