phpmyadmin / sql-parser

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'
                     );

src/Lexer.php

Spacing +13 added lines, -13 removed lines

@@ -21,7 +21,7 @@ 
 use function strlen;
 use function substr;
 
-if (! defined('USE_UTF_STRINGS')) {
+if (!defined('USE_UTF_STRINGS')) {
     // NOTE: In previous versions of PHP (5.5 and older) the default
     // internal encoding is "ISO-8859-1".
     // All `mb_` functions must specify the correct encoding, which is
@@ -176,7 +176,7 @@ 
 
         // For multi-byte strings, a new instance of `UtfString` is
         // initialized (only if `UtfString` usage is forced.
-        if (! $str instanceof UtfString && USE_UTF_STRINGS && $len !== mb_strlen($str, 'UTF-8')) {
+        if (!$str instanceof UtfString && USE_UTF_STRINGS && $len !== mb_strlen($str, 'UTF-8')) {
             $str = new UtfString($str);
         }
 
@@ -186,7 +186,7 @@ 
         $this->strict = $strict;
 
         // Setting the delimiter.
-        $this->setDelimiter(! empty($delimiter) ? $delimiter : static::$DEFAULT_DELIMITER);
+        $this->setDelimiter(!empty($delimiter) ? $delimiter : static::$DEFAULT_DELIMITER);
 
         $this->lex();
     }
@@ -310,7 +310,7 @@ 
                 $delimiterLen = 0;
                 while (
                     ++$this->last < $this->len
-                    && ! Context::isWhitespace($this->str[$this->last])
+                    && !Context::isWhitespace($this->str[$this->last])
                     && $delimiterLen < 15
                 ) {
                     $this->delimiter .= $this->str[$this->last];
@@ -370,8 +370,8 @@ 
             }
 
             if (
-                ($next->type !== Token::TYPE_KEYWORD || ! in_array($next->value, ['FROM', 'USING'], true))
-                && ($next->type !== Token::TYPE_OPERATOR || ! in_array($next->value, [',', ')'], true))
+                ($next->type !== Token::TYPE_KEYWORD || !in_array($next->value, ['FROM', 'USING'], true))
+                && ($next->type !== Token::TYPE_OPERATOR || !in_array($next->value, [',', ')'], true))
             ) {
                 continue;
             }
@@ -450,7 +450,7 @@ 
             $token .= $this->str[$this->last];
             $flags = Context::isKeyword($token);
 
-            if (($this->last + 1 !== $this->len && ! Context::isSeparator($this->str[$this->last + 1])) || ! $flags) {
+            if (($this->last + 1 !== $this->len && !Context::isSeparator($this->str[$this->last + 1])) || !$flags) {
                 continue;
             }
 
@@ -542,7 +542,7 @@ 
             $token .= $this->str[$this->last];
             $flags = Context::isOperator($token);
 
-            if (! $flags) {
+            if (!$flags) {
                 continue;
             }
 
@@ -564,7 +564,7 @@ 
     {
         $token = $this->str[$this->last];
 
-        if (! Context::isWhitespace($token)) {
+        if (!Context::isWhitespace($token)) {
             return null;
         }
 
@@ -804,7 +804,7 @@ 
             } elseif ($state === 2) {
                 $flags |= Token::FLAG_NUMBER_HEX;
                 if (
-                    ! (
+                    !(
                         ($this->str[$this->last] >= '0' && $this->str[$this->last] <= '9')
                         || ($this->str[$this->last] >= 'A' && $this->str[$this->last] <= 'F')
                         || ($this->str[$this->last] >= 'a' && $this->str[$this->last] <= 'f')
@@ -907,7 +907,7 @@ 
         $token = $this->str[$this->last];
         $flags = Context::isString($token);
 
-        if (! $flags && $token !== $quote) {
+        if (!$flags && $token !== $quote) {
             return null;
         }
 
@@ -959,7 +959,7 @@ 
         $token = $this->str[$this->last];
         $flags = Context::isSymbol($token);
 
-        if (! $flags) {
+        if (!$flags) {
             return null;
         }
 
@@ -1010,7 +1010,7 @@ 
             return null;
         }
 
-        while (++$this->last < $this->len && ! Context::isSeparator($this->str[$this->last])) {
+        while (++$this->last < $this->len && !Context::isSeparator($this->str[$this->last])) {
             $token .= $this->str[$this->last];
 
             // Test if end of token equals the current delimiter. If so, remove it from the token.

src/Components/OrderKeyword.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/AlterOperation.php

Spacing +3 added lines, -3 removed lines

@@ -284,8 +284,8 @@ 
                     } elseif (($token->value === ',') && ($brackets === 0)) {
                         break;
                     }
-                } elseif (! self::checkIfTokenQuotedSymbol($token)) {
-                    if (! empty(Parser::$STATEMENT_PARSERS[$token->value])) {
+                } elseif (!self::checkIfTokenQuotedSymbol($token)) {
+                    if (!empty(Parser::$STATEMENT_PARSERS[$token->value])) {
                         // We want to get the next non-comment and non-space token after $token
                         // therefore, the first getNext call will start with the current $idx which's $token,
                         // will return it and increase $idx by 1, which's not guaranteed to be non-comment
@@ -318,7 +318,7 @@ 
                     } elseif (
                         (array_key_exists($arrayKey, self::$DB_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

src/Utils/Table.php

Spacing +6 added lines, -6 removed lines

@@ -26,7 +26,7 @@ 
      */
     public static function getForeignKeys($statement)
     {
-        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 [];
         }
 
@@ -39,7 +39,7 @@ 
 
             $columns = [];
             foreach ($field->key->columns as $column) {
-                if (! isset($column['name'])) {
+                if (!isset($column['name'])) {
                     continue;
                 }
 
@@ -51,7 +51,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;
@@ -84,7 +84,7 @@ 
      */
     public static function getFields($statement)
     {
-        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 [];
         }
 
@@ -101,7 +101,7 @@ 
                 'timestamp_not_null' => false,
             ];
 
-            if (! $field->options) {
+            if (!$field->options) {
                 continue;
             }
 
@@ -128,7 +128,7 @@ 
 
             $option = $field->options->has('AS');
 
-            if (! $option) {
+            if (!$option) {
                 continue;
             }
 

src/Components/Key.php

Spacing +5 added lines, -5 removed lines

@@ -163,9 +163,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
@@ -182,7 +182,7 @@ 
                         $state = 3;
                     } elseif (($token->value === ',') || ($token->value === ')')) {
                         $state = $token->value === ',' ? 2 : 4;
-                        if (! empty($lastColumn)) {
+                        if (!empty($lastColumn)) {
                             $ret->columns[] = $lastColumn;
                             $lastColumn = [];
                         }
@@ -214,7 +214,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;
                     }
 
@@ -256,7 +256,7 @@ 
     public static function build($component, array $options = [])
     {
         $ret = $component->type . ' ';
-        if (! empty($component->name)) {
+        if (!empty($component->name)) {
             $ret .= Context::escape($component->name) . ' ';
         }
 

src/UtfString.php

Spacing +2 added lines, -2 removed lines

@@ -190,7 +190,7 @@ 
         $this->byteIdx = 0;
         $this->charIdx = 0;
         $this->byteLen = mb_strlen($str, '8bit');
-        if (! mb_check_encoding($str, 'UTF-8')) {
+        if (!mb_check_encoding($str, 'UTF-8')) {
             $this->charLen = 0;
         } else {
             $this->charLen = mb_strlen($str, 'UTF-8');
@@ -298,7 +298,7 @@ 
         // Use the default ASCII map as queries are mostly ASCII chars
         // ord($byte) has a performance cost
 
-        if (! isset(static::$asciiMap[$byte])) {
+        if (!isset(static::$asciiMap[$byte])) {
             // Complete the cache with missing items
             static::$asciiMap[$byte] = ord($byte);
         }

src/Statements/CreateStatement.php

Spacing +10 added lines, -10 removed lines

@@ -417,7 +417,7 @@ 
     public function build()
     {
         $fields = '';
-        if (! empty($this->fields)) {
+        if (!empty($this->fields)) {
             if (is_array($this->fields)) {
                 $fields = CreateDefinition::build($this->fields) . ' ';
             } elseif ($this->fields instanceof ArrayObj) {
@@ -449,23 +449,23 @@ 
 
             $partition = '';
 
-            if (! empty($this->partitionBy)) {
+            if (!empty($this->partitionBy)) {
                 $partition .= "\nPARTITION BY " . $this->partitionBy;
             }
 
-            if (! empty($this->partitionsNum)) {
+            if (!empty($this->partitionsNum)) {
                 $partition .= "\nPARTITIONS " . $this->partitionsNum;
             }
 
-            if (! empty($this->subpartitionBy)) {
+            if (!empty($this->subpartitionBy)) {
                 $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy;
             }
 
-            if (! empty($this->subpartitionsNum)) {
+            if (!empty($this->subpartitionsNum)) {
                 $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum;
             }
 
-            if (! empty($this->partitions)) {
+            if (!empty($this->partitions)) {
                 $partition .= "\n" . PartitionDefinition::build($this->partitions);
             }
 
@@ -487,7 +487,7 @@ 
                 . OptionsArray::build($this->options) . ' '
                 . Expression::build($this->name) . ' '
                 . $fields . ' AS ' . $builtStatement
-                . (! empty($this->body) ? TokensList::build($this->body) : '') . ' '
+                . (!empty($this->body) ? TokensList::build($this->body) : '') . ' '
                 . OptionsArray::build($this->entityOptions);
         } elseif ($this->options->has('TRIGGER')) {
             return 'CREATE '
@@ -541,7 +541,7 @@ 
             ]
         );
 
-        if (! isset($this->name) || ($this->name === '')) {
+        if (!isset($this->name) || ($this->name === '')) {
             $parser->error('The name of the entity was expected.', $list->tokens[$list->idx]);
         } else {
             ++$list->idx; // Skipping field.
@@ -657,7 +657,7 @@ 
                         $token = $list->getNextOfType(Token::TYPE_NUMBER);
                         --$list->idx; // `getNextOfType` also advances one position.
                         $this->subpartitionsNum = $token->value;
-                    } elseif (! empty($field)) {
+                    } elseif (!empty($field)) {
                         /*
                          * Handling the content of `PARTITION BY` and `SUBPARTITION BY`.
                          */
@@ -686,7 +686,7 @@ 
                             $field = null;
                         }
                     } elseif (($token->type === Token::TYPE_OPERATOR) && ($token->value === '(')) {
-                        if (! empty($this->partitionBy)) {
+                        if (!empty($this->partitionBy)) {
                             $this->partitions = ArrayObj::parse(
                                 $parser,
                                 $list,

src/Statements/WithStatement.php

Spacing +3 added lines, -3 removed lines

@@ -127,7 +127,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;
                 }
@@ -143,7 +143,7 @@ 
                 $list->getNext();
                 $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;
@@ -283,7 +283,7 @@ 
             }
 
             ++$list->idx;
-            if (! isset($list->tokens[$list->idx])) {
+            if (!isset($list->tokens[$list->idx])) {
                 break;
             }
 

Indentation +3 added lines, -4 removed lines

@@ -22,7 +22,6 @@ 
 
 /**
  * `WITH` statement.
-
  *  WITH [RECURSIVE] query_name [ (column_name [,...]) ] AS (SELECT ...) [, ...]
  */
 final class WithStatement extends Statement
@@ -263,9 +262,9 @@ 
 
         // 5 is the only valid end state
         if ($state !== 5) {
-             /**
-             * Token parsed at this moment.
-             */
+                /**
+                 * Token parsed at this moment.
+                 */
             $token = $list->tokens[$list->idx];
 
             $parser->error('Unexpected end of the WITH CTE.', $token);