phpmyadmin / sql-parser

src/Statements/SetStatement.php

Spacing +1 added lines, -1 removed lines

@@ -31,7 +31,7 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'SET'                           => array('SET',         3),
+        'SET'                           => array('SET', 3),
     );
 
     /**

src/Statements/TransactionStatement.php

Spacing +2 added lines, -2 removed lines

@@ -30,14 +30,14 @@
      *
      * @var int
      */
-    const TYPE_BEGIN                    = 1;
+    const TYPE_BEGIN = 1;
 
     /**
      * COMMIT and ROLLBACK
      *
      * @var int
      */
-    const TYPE_END                      = 2;
+    const TYPE_END = 2;
 
     /**
      * The type of this query.

src/Statements/UpdateStatement.php

Spacing +7 added lines, -7 removed lines

@@ -57,15 +57,15 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'UPDATE'                        => array('UPDATE',      2),
+        'UPDATE'                        => array('UPDATE', 2),
         // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',    1),
+        '_OPTIONS'                      => array('_OPTIONS', 1),
         // Used for updated tables.
-        '_UPDATE'                       => array('UPDATE',      1),
-        'SET'                           => array('SET',         3),
-        'WHERE'                         => array('WHERE',       3),
-        'ORDER BY'                      => array('ORDER BY',    3),
-        'LIMIT'                         => array('LIMIT',       3),
+        '_UPDATE'                       => array('UPDATE', 1),
+        'SET'                           => array('SET', 3),
+        'WHERE'                         => array('WHERE', 3),
+        'ORDER BY'                      => array('ORDER BY', 3),
+        'LIMIT'                         => array('LIMIT', 3),
     );
 
     /**

src/Utils/BufferedQuery.php

Spacing +1 added lines, -1 removed lines

@@ -295,7 +295,7 @@
              * statement. This is the reason for the last condition.
              */
             if (($i + 9 < $len)
-                && (($this->query[$i    ] === 'D') || ($this->query[$i    ] === 'd'))
+                && (($this->query[$i] === 'D') || ($this->query[$i] === 'd'))
                 && (($this->query[$i + 1] === 'E') || ($this->query[$i + 1] === 'e'))
                 && (($this->query[$i + 2] === 'L') || ($this->query[$i + 2] === 'l'))
                 && (($this->query[$i + 3] === 'I') || ($this->query[$i + 3] === 'i'))

src/Context.php

Spacing +30 added lines, -30 removed lines

@@ -107,7 +107,7 @@ 
         ':='  =>  8,
 
         // @see Token::FLAG_OPERATOR_SQL
-        '('   => 16, ')'    => 16, '.'   => 16,  ','  => 16, ';' => 16,
+        '('   => 16, ')'    => 16, '.'   => 16, ','  => 16, ';' => 16,
     );
 
     /**
@@ -125,67 +125,67 @@ 
 
     // Compatibility mode for Microsoft's SQL server.
     // This is the equivalent of ANSI_QUOTES.
-    const COMPAT_MYSQL                  =       2;
+    const COMPAT_MYSQL                  = 2;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_allow_invalid_dates
-    const ALLOW_INVALID_DATES           =       1;
+    const ALLOW_INVALID_DATES           = 1;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_ansi_quotes
-    const ANSI_QUOTES                   =       2;
+    const ANSI_QUOTES                   = 2;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_error_for_division_by_zero
-    const ERROR_FOR_DIVISION_BY_ZERO    =       4;
+    const ERROR_FOR_DIVISION_BY_ZERO    = 4;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_high_not_precedence
-    const HIGH_NOT_PRECEDENCE           =       8;
+    const HIGH_NOT_PRECEDENCE           = 8;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_ignore_space
-    const IGNORE_SPACE                  =      16;
+    const IGNORE_SPACE                  = 16;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_auto_create_user
-    const NO_AUTO_CREATE_USER           =      32;
+    const NO_AUTO_CREATE_USER           = 32;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_auto_value_on_zero
-    const NO_AUTO_VALUE_ON_ZERO         =      64;
+    const NO_AUTO_VALUE_ON_ZERO         = 64;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_backslash_escapes
-    const NO_BACKSLASH_ESCAPES          =     128;
+    const NO_BACKSLASH_ESCAPES          = 128;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_dir_in_create
-    const NO_DIR_IN_CREATE              =     256;
+    const NO_DIR_IN_CREATE              = 256;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_dir_in_create
-    const NO_ENGINE_SUBSTITUTION        =     512;
+    const NO_ENGINE_SUBSTITUTION        = 512;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_field_options
-    const NO_FIELD_OPTIONS              =    1024;
+    const NO_FIELD_OPTIONS              = 1024;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_key_options
-    const NO_KEY_OPTIONS                =    2048;
+    const NO_KEY_OPTIONS                = 2048;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_table_options
-    const NO_TABLE_OPTIONS              =    4096;
+    const NO_TABLE_OPTIONS              = 4096;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_unsigned_subtraction
-    const NO_UNSIGNED_SUBTRACTION       =    8192;
+    const NO_UNSIGNED_SUBTRACTION       = 8192;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_zero_date
-    const NO_ZERO_DATE                  =   16384;
+    const NO_ZERO_DATE                  = 16384;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_no_zero_in_date
-    const NO_ZERO_IN_DATE               =   32768;
+    const NO_ZERO_IN_DATE               = 32768;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_only_full_group_by
-    const ONLY_FULL_GROUP_BY            =   65536;
+    const ONLY_FULL_GROUP_BY            = 65536;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_pipes_as_concat
-    const PIPES_AS_CONCAT               =  131072;
+    const PIPES_AS_CONCAT               = 131072;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_real_as_float
-    const REAL_AS_FLOAT                 =  262144;
+    const REAL_AS_FLOAT                 = 262144;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_strict_all_tables
-    const STRICT_ALL_TABLES             =  524288;
+    const STRICT_ALL_TABLES             = 524288;
 
     // https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_strict_trans_tables
     const STRICT_TRANS_TABLES           = 1048576;
@@ -195,7 +195,7 @@ 
     // The table and column names and any other field that must be escaped will
     // not be.
     // Reserved keywords are being escaped regardless this mode is used or not.
-    const NO_ENCLOSING_QUOTES           = 1073741824;
+    const NO_ENCLOSING_QUOTES = 1073741824;
 
     /*
      * Combination SQL Modes
@@ -203,31 +203,31 @@ 
      */
 
     // REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE
-    const SQL_MODE_ANSI                 = 393234;
+    const SQL_MODE_ANSI = 393234;
 
     // PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS,
     // NO_TABLE_OPTIONS, NO_FIELD_OPTIONS,
-    const SQL_MODE_DB2                  = 138258;
+    const SQL_MODE_DB2 = 138258;
 
     // PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS,
     // NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, NO_AUTO_CREATE_USER
-    const SQL_MODE_MAXDB                = 138290;
+    const SQL_MODE_MAXDB = 138290;
 
     // PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS,
     // NO_TABLE_OPTIONS, NO_FIELD_OPTIONS
-    const SQL_MODE_MSSQL                = 138258;
+    const SQL_MODE_MSSQL = 138258;
 
     // PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS,
     // NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, NO_AUTO_CREATE_USER
-    const SQL_MODE_ORACLE               = 138290;
+    const SQL_MODE_ORACLE = 138290;
 
     // PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS,
     // NO_TABLE_OPTIONS, NO_FIELD_OPTIONS
-    const SQL_MODE_POSTGRESQL           = 138258;
+    const SQL_MODE_POSTGRESQL = 138258;
 
     // STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,
     // ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER
-    const SQL_MODE_TRADITIONAL          = 1622052;
+    const SQL_MODE_TRADITIONAL = 1622052;
 
     // -------------------------------------------------------------------------
     // Keyword.

src/Statements/DropStatement.php

Spacing +4 added lines, -4 removed lines

@@ -54,12 +54,12 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'DROP'                          => array('DROP',        2),
+        'DROP'                          => array('DROP', 2),
         // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',    1),
+        '_OPTIONS'                      => array('_OPTIONS', 1),
         // Used for select expressions.
-        'DROP_'                         => array('DROP',        1),
-        'ON'                            => array('ON',          3),
+        'DROP_'                         => array('DROP', 1),
+        'ON'                            => array('ON', 3),
     );
 
     /**

src/Utils/CLI.php

Spacing +2 added lines, -2 removed lines

@@ -36,10 +36,10 @@
                 $params[$value[0]] = $params[$value];
             }
         }
-        if (! isset($params['f'])) {
+        if (!isset($params['f'])) {
             $params['f'] = 'cli';
         }
-        if (! in_array($params['f'], array('html', 'cli', 'text'))) {
+        if (!in_array($params['f'], array('html', 'cli', 'text'))) {
             return false;
         }
         return $params;

src/Components/OptionsArray.php

Spacing +1 added lines, -1 removed lines

@@ -183,7 +183,7 @@
                         'value' => '',
                     );
                     $state = 1;
-                } elseif ($lastOption[1] === 'expr'  || $lastOption[1] === 'expr=') {
+                } elseif ($lastOption[1] === 'expr' || $lastOption[1] === 'expr=') {
                     // This is a keyword that is followed by an expression.
                     // The expression is used by the specialized parser.
 

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