phpmyadmin / sql-parser

src/Components/ArrayObj.php

Spacing +1 added lines, -1 removed lines

@@ -108,7 +108,7 @@
                 || ($token->type === Token::TYPE_COMMENT)
             ) {
                 $lastRaw .= $token->token;
-                $lastValue = trim($lastValue) .' ';
+                $lastValue = trim($lastValue) . ' ';
                 continue;
             }
 

src/Context.php

Spacing +29 added lines, -29 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;
@@ -196,31 +196,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/DeleteStatement.php

Spacing +7 added lines, -7 removed lines

@@ -52,14 +52,14 @@
      * @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),
-        '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),
+        'WHERE'                         => array('WHERE', 3),
+        'ORDER BY'                      => array('ORDER BY', 3),
+        'LIMIT'                         => array('LIMIT', 3),
     );
 
     /**

src/Statements/DropStatement.php

Spacing +3 added lines, -3 removed lines

@@ -54,11 +54,11 @@
      * @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),
+        'DROP_'                         => array('DROP', 1),
     );
 
     /**

src/Statements/ReplaceStatement.php

Spacing +5 added lines, -5 removed lines

@@ -53,12 +53,12 @@
      * @var array
      */
     public static $CLAUSES = array(
-        'REPLACE'                       => array('REPLACE',     2),
+        'REPLACE'                       => array('REPLACE', 2),
         // Used for options.
-        '_OPTIONS'                      => array('_OPTIONS',    1),
-        'INTO'                          => array('FROM',        3),
-        'VALUES'                        => array('VALUES',      1),
-        'SET'                           => array('PARTITION',   3),
+        '_OPTIONS'                      => array('_OPTIONS', 1),
+        'INTO'                          => array('FROM', 3),
+        'VALUES'                        => array('VALUES', 1),
+        'SET'                           => array('PARTITION', 3),
     );
 
     /**

src/Statements/SelectStatement.php

Spacing +22 added lines, -22 removed lines

@@ -83,30 +83,30 @@
      * @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),
-        '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),
-
-        '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),
-        'INTO'                          => array('INTO',                3),
-        'UNION'                         => array('UNION',               1),
+        '_SELECT'                       => array('SELECT', 1),
+        '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),
+
+        '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),
+        'INTO'                          => array('INTO', 3),
+        'UNION'                         => array('UNION', 1),
         // These are available only when `UNION` is present.
         // 'ORDER BY'                      => array('ORDER BY',    3),
         // 'LIMIT'                         => array('LIMIT',       3),

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),
     );
 
     /**