phpmyadmin / sql-parser

src/Statements/DeleteStatement.php

Braces +1 added lines, -1 removed lines

@@ -302,7 +302,7 @@
                     ++$list->idx; // Skip 'ORDER  BY'
                     $this->order = OrderKeyword::parse($parser, $list);
                     $state = 5;
-                }  elseif ($token->type === Token::TYPE_KEYWORD
+                } elseif ($token->type === Token::TYPE_KEYWORD
                     && $token->value === 'LIMIT'
                 ) {
                     ++$list->idx; // Skip 'LIMIT'

Spacing +8 added lines, -8 removed lines

@@ -71,15 +71,15 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'DELETE'                        => array('DELETE',      2),
+        'DELETE'                        => array('DELETE', 2),
         // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',    1),
-        'FROM'                          => array('FROM',        3),
-        'PARTITION'                     => array('PARTITION',   3),
-        'USING'                         => array('USING',       3),
-        'WHERE'                         => array('WHERE',       3),
-        'ORDER BY'                      => array('ORDER BY',    3),
-        'LIMIT'                         => array('LIMIT',       3),
+        '_OPTIONS'                      => array('_OPTIONS', 1),
+        'FROM'                          => array('FROM', 3),
+        'PARTITION'                     => array('PARTITION', 3),
+        'USING'                         => array('USING', 3),
+        'WHERE'                         => array('WHERE', 3),
+        'ORDER BY'                      => array('ORDER BY', 3),
+        'LIMIT'                         => array('LIMIT', 3),
     );
 
     /**

src/Components/CaseExpression.php

Doc Comments +1 added lines, -1 removed lines

@@ -77,7 +77,7 @@
      * @param Parser     $parser  The parser that serves as context.
      * @param TokensList $list    The list of tokens that are being parsed.
      *
-     * @return Expression
+     * @return CaseExpression
      */
     public static function parse(Parser $parser, TokensList $list)
     {

src/Statements/SelectStatement.php

Spacing +27 added lines, -27 removed lines

@@ -87,36 +87,36 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'SELECT'                        => array('SELECT',                  2),
+        'SELECT'                        => array('SELECT', 2),
         // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',                1),
+        '_OPTIONS'                      => array('_OPTIONS', 1),
         // Used for selected expressions.
-        '_SELECT'                       => array('SELECT',                  1),
-        'INTO'                          => array('INTO',                    3),
-        'FROM'                          => array('FROM',                    3),
-        'PARTITION'                     => array('PARTITION',               3),
-
-        'JOIN'                          => array('JOIN',                    1),
-        'FULL JOIN'                     => array('FULL JOIN',               1),
-        'INNER JOIN'                    => array('INNER JOIN',              1),
-        'LEFT JOIN'                     => array('LEFT JOIN',               1),
-        'LEFT OUTER JOIN'               => array('LEFT OUTER JOIN',         1),
-        'RIGHT JOIN'                    => array('RIGHT JOIN',              1),
-        'RIGHT OUTER JOIN'              => array('RIGHT OUTER JOIN',        1),
-        'NATURAL JOIN'                  => array('NATURAL JOIN',            1),
-        'NATURAL LEFT JOIN'             => array('NATURAL LEFT JOIN',       1),
-        'NATURAL RIGHT JOIN'            => array('NATURAL RIGHT JOIN',      1),
+        '_SELECT'                       => array('SELECT', 1),
+        'INTO'                          => array('INTO', 3),
+        'FROM'                          => array('FROM', 3),
+        'PARTITION'                     => array('PARTITION', 3),
+
+        'JOIN'                          => array('JOIN', 1),
+        'FULL JOIN'                     => array('FULL JOIN', 1),
+        'INNER JOIN'                    => array('INNER JOIN', 1),
+        'LEFT JOIN'                     => array('LEFT JOIN', 1),
+        'LEFT OUTER JOIN'               => array('LEFT OUTER JOIN', 1),
+        'RIGHT JOIN'                    => array('RIGHT JOIN', 1),
+        'RIGHT OUTER JOIN'              => array('RIGHT OUTER JOIN', 1),
+        'NATURAL JOIN'                  => array('NATURAL JOIN', 1),
+        'NATURAL LEFT JOIN'             => array('NATURAL LEFT JOIN', 1),
+        'NATURAL RIGHT JOIN'            => array('NATURAL RIGHT JOIN', 1),
         'NATURAL LEFT OUTER JOIN'       => array('NATURAL LEFT OUTER JOIN', 1),
-        'NATURAL RIGHT OUTER JOIN'      => array('NATURAL RIGHT JOIN',      1),
-
-        'WHERE'                         => array('WHERE',                   3),
-        'GROUP BY'                      => array('GROUP BY',                3),
-        'HAVING'                        => array('HAVING',                  3),
-        'ORDER BY'                      => array('ORDER BY',                3),
-        'LIMIT'                         => array('LIMIT',                   3),
-        'PROCEDURE'                     => array('PROCEDURE',               3),
-        'UNION'                         => array('UNION',                   1),
-        '_END_OPTIONS'                  => array('_END_OPTIONS',            1)
+        'NATURAL RIGHT OUTER JOIN'      => array('NATURAL RIGHT JOIN', 1),
+
+        'WHERE'                         => array('WHERE', 3),
+        'GROUP BY'                      => array('GROUP BY', 3),
+        'HAVING'                        => array('HAVING', 3),
+        'ORDER BY'                      => array('ORDER BY', 3),
+        'LIMIT'                         => array('LIMIT', 3),
+        'PROCEDURE'                     => array('PROCEDURE', 3),
+        'UNION'                         => array('UNION', 1),
+        '_END_OPTIONS'                  => array('_END_OPTIONS', 1)
         // These are available only when `UNION` is present.
         // 'ORDER BY'                      => array('ORDER BY',    3),
         // 'LIMIT'                         => array('LIMIT',       3),

tools/ContextGenerator.php

Spacing +42 added lines, -42 removed lines

@@ -52,46 +52,46 @@ 
      * @var string
      */
     const TEMPLATE =
-        '<?php'                                                                             . "\n" .
-        ''                                                                                  . "\n" .
-        '/**'                                                                               . "\n" .
-        ' * Context for %1$s.'                                                              . "\n" .
-        ' *'                                                                                . "\n" .
-        ' * This file was auto-generated.'                                                  . "\n" .
-        ' *'                                                                                . "\n" .
-        ' * @package    SqlParser'                                                          . "\n" .
-        ' * @subpackage Contexts'                                                           . "\n" .
-        ' * @link       %3$s'                                                               . "\n" .
-        ' */'                                                                               . "\n" .
-        'namespace SqlParser\\Contexts;'                                                    . "\n" .
-        ''                                                                                  . "\n" .
-        'use SqlParser\\Context;'                                                           . "\n" .
-        ''                                                                                  . "\n" .
-        '/**'                                                                               . "\n" .
-        ' * Context for %1$s.'                                                              . "\n" .
-        ' *'                                                                                . "\n" .
-        ' * @category   Contexts'                                                           . "\n" .
-        ' * @package    SqlParser'                                                          . "\n" .
-        ' * @subpackage Contexts'                                                           . "\n" .
-        ' * @license    https://www.gnu.org/licenses/gpl-2.0.txt GPL-2.0+'                  . "\n" .
-        ' */'                                                                               . "\n" .
-        'class %2$s extends Context'                                                        . "\n" .
-        '{'                                                                                 . "\n" .
-        ''                                                                                  . "\n" .
-        '    /**'                                                                           . "\n" .
-        '     * List of keywords.'                                                          . "\n" .
-        '     *'                                                                            . "\n" .
-        '     * The value associated to each keyword represents its flags.'                 . "\n" .
-        '     *'                                                                            . "\n" .
-        '     * @see Token::FLAG_KEYWORD_*'                                                 . "\n" .
-        '     *'                                                                            . "\n" .
-        '     * @var array'                                                                 . "\n" .
-        '     */'                                                                           . "\n" .
-        '    public static $KEYWORDS = array('                                              . "\n" .
-        ''                                                                                  . "\n" .
-        '%4$s'                                                                              .
-        '    );'                                                                            . "\n" .
-        '}'                                                                                 . "\n";
+        '<?php' . "\n" .
+        '' . "\n" .
+        '/**' . "\n" .
+        ' * Context for %1$s.' . "\n" .
+        ' *' . "\n" .
+        ' * This file was auto-generated.' . "\n" .
+        ' *' . "\n" .
+        ' * @package    SqlParser' . "\n" .
+        ' * @subpackage Contexts' . "\n" .
+        ' * @link       %3$s' . "\n" .
+        ' */' . "\n" .
+        'namespace SqlParser\\Contexts;' . "\n" .
+        '' . "\n" .
+        'use SqlParser\\Context;' . "\n" .
+        '' . "\n" .
+        '/**' . "\n" .
+        ' * Context for %1$s.' . "\n" .
+        ' *' . "\n" .
+        ' * @category   Contexts' . "\n" .
+        ' * @package    SqlParser' . "\n" .
+        ' * @subpackage Contexts' . "\n" .
+        ' * @license    https://www.gnu.org/licenses/gpl-2.0.txt GPL-2.0+' . "\n" .
+        ' */' . "\n" .
+        'class %2$s extends Context' . "\n" .
+        '{' . "\n" .
+        '' . "\n" .
+        '    /**' . "\n" .
+        '     * List of keywords.' . "\n" .
+        '     *' . "\n" .
+        '     * The value associated to each keyword represents its flags.' . "\n" .
+        '     *' . "\n" .
+        '     * @see Token::FLAG_KEYWORD_*' . "\n" .
+        '     *' . "\n" .
+        '     * @var array' . "\n" .
+        '     */' . "\n" .
+        '    public static $KEYWORDS = array(' . "\n" .
+        '' . "\n" .
+        '%4$s' .
+        '    );' . "\n" .
+        '}' . "\n";
 
     /**
      * Sorts an array of words.
@@ -286,8 +286,8 @@ 
          * @var string
          */
         $formattedName = str_replace(
-            array('Context', 'MySql',  '00', '0'),
-            array('',        'MySQL ', '',   '.'),
+            array('Context', 'MySql', '00', '0'),
+            array('', 'MySQL ', '', '.'),
             $class
         );
 

src/Token.php

Spacing +32 added lines, -32 removed lines

@@ -29,14 +29,14 @@ 
      *
      * @var int
      */
-    const TYPE_NONE                     =  0;
+    const TYPE_NONE = 0;
 
     /**
      * SQL specific keywords: SELECT, UPDATE, INSERT, etc.
      *
      * @var int
      */
-    const TYPE_KEYWORD                  =  1;
+    const TYPE_KEYWORD = 1;
 
     /**
      * Any type of legal operator.
@@ -50,14 +50,14 @@ 
      *
      * @var int
      */
-    const TYPE_OPERATOR                 =  2;
+    const TYPE_OPERATOR = 2;
 
     /**
      * Spaces, tabs, new lines, etc.
      *
      * @var int
      */
-    const TYPE_WHITESPACE               =  3;
+    const TYPE_WHITESPACE = 3;
 
     /**
      * Any type of legal comment.
@@ -79,21 +79,21 @@ 
      *
      * @var int
      */
-    const TYPE_COMMENT                  =  4;
+    const TYPE_COMMENT = 4;
 
     /**
      * Boolean values: true or false.
      *
      * @var int
      */
-    const TYPE_BOOL                     =  5;
+    const TYPE_BOOL = 5;
 
     /**
      * Numbers: 4, 0x8, 15.16, 23e42, etc.
      *
      * @var int
      */
-    const TYPE_NUMBER                   =  6;
+    const TYPE_NUMBER = 6;
 
     /**
      * Literal strings: 'string', "test".
@@ -101,7 +101,7 @@ 
      *
      * @var int
      */
-    const TYPE_STRING                   =  7;
+    const TYPE_STRING = 7;
 
     /**
      * Database, table names, variables, etc.
@@ -109,7 +109,7 @@ 
      *
      * @var int
      */
-    const TYPE_SYMBOL                   =  8;
+    const TYPE_SYMBOL = 8;
 
     /**
      * Delimits an unknown string.
@@ -117,7 +117,7 @@ 
      *
      * @var int
      */
-    const TYPE_DELIMITER                =  9;
+    const TYPE_DELIMITER = 9;
 
     /**
      * Labels in LOOP statement, ITERATE statement etc.
@@ -129,46 +129,46 @@ 
      *
      * @var int
      */
-    const TYPE_LABEL                =  10;
+    const TYPE_LABEL = 10;
 
     // Flags that describe the tokens in more detail.
     // All keywords must have flag 1 so `Context::isKeyword` method doesn't
     // require strict comparison.
-    const FLAG_KEYWORD_RESERVED         =  2;
-    const FLAG_KEYWORD_COMPOSED         =  4;
-    const FLAG_KEYWORD_DATA_TYPE        =  8;
+    const FLAG_KEYWORD_RESERVED         = 2;
+    const FLAG_KEYWORD_COMPOSED         = 4;
+    const FLAG_KEYWORD_DATA_TYPE        = 8;
     const FLAG_KEYWORD_KEY              = 16;
     const FLAG_KEYWORD_FUNCTION         = 32;
 
     // Numbers related flags.
-    const FLAG_NUMBER_HEX               =  1;
-    const FLAG_NUMBER_FLOAT             =  2;
-    const FLAG_NUMBER_APPROXIMATE       =  4;
-    const FLAG_NUMBER_NEGATIVE          =  8;
+    const FLAG_NUMBER_HEX               = 1;
+    const FLAG_NUMBER_FLOAT             = 2;
+    const FLAG_NUMBER_APPROXIMATE       = 4;
+    const FLAG_NUMBER_NEGATIVE          = 8;
     const FLAG_NUMBER_BINARY            = 16;
 
     // Strings related flags.
-    const FLAG_STRING_SINGLE_QUOTES     =  1;
-    const FLAG_STRING_DOUBLE_QUOTES     =  2;
+    const FLAG_STRING_SINGLE_QUOTES     = 1;
+    const FLAG_STRING_DOUBLE_QUOTES     = 2;
 
     // Comments related flags.
-    const FLAG_COMMENT_BASH             =  1;
-    const FLAG_COMMENT_C                =  2;
-    const FLAG_COMMENT_SQL              =  4;
-    const FLAG_COMMENT_MYSQL_CMD        =  8;
+    const FLAG_COMMENT_BASH             = 1;
+    const FLAG_COMMENT_C                = 2;
+    const FLAG_COMMENT_SQL              = 4;
+    const FLAG_COMMENT_MYSQL_CMD        = 8;
 
     // Operators related flags.
-    const FLAG_OPERATOR_ARITHMETIC      =  1;
-    const FLAG_OPERATOR_LOGICAL         =  2;
-    const FLAG_OPERATOR_BITWISE         =  4;
-    const FLAG_OPERATOR_ASSIGNMENT      =  8;
+    const FLAG_OPERATOR_ARITHMETIC      = 1;
+    const FLAG_OPERATOR_LOGICAL         = 2;
+    const FLAG_OPERATOR_BITWISE         = 4;
+    const FLAG_OPERATOR_ASSIGNMENT      = 8;
     const FLAG_OPERATOR_SQL             = 16;
 
     // Symbols related flags.
-    const FLAG_SYMBOL_VARIABLE          =  1;
-    const FLAG_SYMBOL_BACKTICK          =  2;
-    const FLAG_SYMBOL_USER              =  4;
-    const FLAG_SYMBOL_SYSTEM            =  8;
+    const FLAG_SYMBOL_VARIABLE          = 1;
+    const FLAG_SYMBOL_BACKTICK          = 2;
+    const FLAG_SYMBOL_USER              = 4;
+    const FLAG_SYMBOL_SYSTEM            = 8;
 
     /**
      * The token it its raw string representation.

src/Components/Expression.php

Spacing +2 added lines, -2 removed lines

@@ -227,7 +227,7 @@ 
                     $ret->subquery = $token->value;
                 } elseif (($token->flags & Token::FLAG_KEYWORD_FUNCTION)
                     && (empty($options['parseField'])
-                    && ! $alias)
+                    && !$alias)
                 ) {
                     $isExpr = true;
                 } elseif (($token->flags & Token::FLAG_KEYWORD_RESERVED)
@@ -261,7 +261,7 @@ 
                         continue;
                     }
                     $isExpr = true;
-                } elseif ($brackets === 0 && strlen($ret->expr) > 0 && ! $alias) {
+                } elseif ($brackets === 0 && strlen($ret->expr) > 0 && !$alias) {
                     /* End of expression */
                     break;
                 }

src/Components/AlterOperation.php

Spacing +1 added lines, -1 removed lines

@@ -223,7 +223,7 @@
                     // We have reached the end of ALTER operation and suddenly found
                     // a start to new statement, but have not find a delimiter between them
 
-                    if (! ($token->value == 'SET' && $list->tokens[$list->idx - 1]->value == 'CHARACTER')) {
+                    if (!($token->value == 'SET' && $list->tokens[$list->idx - 1]->value == 'CHARACTER')) {
                         $parser->error(
                             'A new statement was found, but no delimiter between it and the previous one.',
                             $token

src/Statement.php

Spacing +1 added lines, -1 removed lines

@@ -481,7 +481,7 @@
             if ($clauseStartIdx != -1) {
                 if ($joinStart == 0 && stripos($clauseType, 'JOIN')) {
                     $joinStart = 1;
-                } elseif ($joinStart == 1 && ! stripos($clauseType, 'JOIN')) {
+                } elseif ($joinStart == 1 && !stripos($clauseType, 'JOIN')) {
                     $joinStart = 2;
                 } elseif ($joinStart == 2 && stripos($clauseType, 'JOIN')) {
                     $error = 1;

src/Utils/Formatter.php

Spacing +4 added lines, -4 removed lines

@@ -349,7 +349,7 @@ 
                     // pieces only if the clause is not inlined or this fragment
                     // is between brackets that are on new line.
                     if (((empty(self::$INLINE_CLAUSES[$lastClause]))
-                        && ! $shortGroup
+                        && !$shortGroup
                         && ($this->options['parts_newline']))
                         || (end($blocksLineEndings) === true)
                     ) {
@@ -435,9 +435,9 @@ 
             array(
                 "\x00", "\x01", "\x02", "\x03", "\x04",
                 "\x05", "\x06", "\x07", "\x08", "\x09", "\x0A",
-                "\x0B","\x0C","\x0D", "\x0E", "\x0F", "\x10", "\x11",
-                "\x12","\x13","\x14","\x15", "\x16", "\x17", "\x18",
-                "\x19","\x1A","\x1B","\x1C","\x1D", "\x1E", "\x1F"
+                "\x0B", "\x0C", "\x0D", "\x0E", "\x0F", "\x10", "\x11",
+                "\x12", "\x13", "\x14", "\x15", "\x16", "\x17", "\x18",
+                "\x19", "\x1A", "\x1B", "\x1C", "\x1D", "\x1E", "\x1F"
             ),
             array(
                 '\x00', '\x01', '\x02', '\x03', '\x04',