phpmyadmin / sql-parser

src/Components/JoinKeyword.php

Spacing +3 added lines, -3 removed lines

@@ -180,10 +180,10 @@
     {
         $ret = array();
         foreach ($component as $c) {
-            $ret[] = array_search($c->type, static::$JOINS) . ' ' . $c->expr
+            $ret[] = array_search($c->type, static::$JOINS).' '.$c->expr
                 . (!empty($c->on)
-                    ? ' ON ' . Condition::build($c->on)
-                    : ' USING ' . ArrayObj::build($c->using));
+                    ? ' ON '.Condition::build($c->on)
+                    : ' USING '.ArrayObj::build($c->using));
         }
         return implode(' ', $ret);
     }

src/Components/DataType.php

Spacing +2 added lines, -2 removed lines

@@ -163,9 +163,9 @@
 
         $parameters = '';
         if (!empty($component->parameters)) {
-            $parameters = '(' . implode(',', $component->parameters) . ')';
+            $parameters = '('.implode(',', $component->parameters).')';
         }
 
-        return trim($name . $parameters . ' ' . $component->options);
+        return trim($name.$parameters.' '.$component->options);
     }
 }

src/Context.php

Spacing +34 added lines, -34 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.
@@ -431,11 +431,11 @@ 
         }
         if ($context[0] !== '\\') {
             // Short context name (must be formatted into class name).
-            $context = self::$contextPrefix . $context;
+            $context = self::$contextPrefix.$context;
         }
         if (!class_exists($context)) {
             throw new \Exception(
-                'Specified context ("' . $context . '") does not exist.'
+                'Specified context ("'.$context.'") does not exist.'
             );
         }
         self::$loadedContext = $context;
@@ -506,7 +506,7 @@ 
         }
         $mode = explode(',', $mode);
         foreach ($mode as $m) {
-            static::$MODE |= constant('static::' . $m);
+            static::$MODE |= constant('static::'.$m);
         }
     }
 
@@ -537,7 +537,7 @@ 
             $quote = '"';
         }
 
-        return $quote . str_replace($quote, $quote . $quote, $str) . $quote;
+        return $quote.str_replace($quote, $quote.$quote, $str).$quote;
     }
 }
 

src/Lexer.php

Spacing +4 added lines, -4 removed lines

@@ -279,7 +279,7 @@ 
                 $lastToken->token .= $token->token;
                 $lastToken->type = Token::TYPE_SYMBOL;
                 $lastToken->flags = Token::FLAG_SYMBOL_USER;
-                $lastToken->value .= '@' . $token->value;
+                $lastToken->value .= '@'.$token->value;
                 continue;
             } elseif (($lastToken !== null)
                 && ($token->type === Token::TYPE_KEYWORD)
@@ -595,8 +595,8 @@ 
         }
 
         $iBak = $this->last;
-        $token = $this->str[$this->last] . $this->str[++$this->last]
-        . $this->str[++$this->last] . $this->str[++$this->last]; // _TRUE_ or _FALS_e
+        $token = $this->str[$this->last].$this->str[++$this->last]
+        . $this->str[++$this->last].$this->str[++$this->last]; // _TRUE_ or _FALS_e
 
         if (Context::isBool($token)) {
             return new Token($token, Token::TYPE_BOOL);
@@ -769,7 +769,7 @@ 
                 && ((($this->str[$this->last] === $quote) && ($this->str[$this->last + 1] === $quote))
                 || (($this->str[$this->last] === '\\') && ($quote !== '`')))
             ) {
-                $token .= $this->str[$this->last] . $this->str[++$this->last];
+                $token .= $this->str[$this->last].$this->str[++$this->last];
             } else {
                 if ($this->str[$this->last] === $quote) {
                     break;

src/Statements/AlterStatement.php

Spacing +3 added lines, -3 removed lines

@@ -150,8 +150,8 @@
             $tmp[] = $altered::build($altered);
         }
 
-        return 'ALTER ' . OptionsArray::build($this->options)
-            . ' ' . Expression::build($this->table)
-            . ' ' . implode(', ', $tmp);
+        return 'ALTER '.OptionsArray::build($this->options)
+            . ' '.Expression::build($this->table)
+            . ' '.implode(', ', $tmp);
     }
 }

src/Statements/NotImplementedStatement.php

Spacing +1 added lines, -1 removed lines

@@ -40,7 +40,7 @@
     public function build()
     {
         // Building the parsed part of the query (if any).
-        $query = parent::build() . ' ';
+        $query = parent::build().' ';
 
         // Rebuilding the unknown part from tokens.
         foreach ($this->unknown as $token) {

src/Statements/TransactionStatement.php

Spacing +4 added lines, -4 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.
@@ -111,9 +111,9 @@ 
                 /**
                  * @var SelectStatement $statement
                  */
-                $ret .= ';' . $statement->build();
+                $ret .= ';'.$statement->build();
             }
-            $ret .= ';' . $this->end->build();
+            $ret .= ';'.$this->end->build();
         }
         return $ret;
     }

src/Statement.php

Spacing +2 added lines, -2 removed lines

@@ -175,12 +175,12 @@
 
             // Checking if the name of the clause should be added.
             if ($type & 2) {
-                $query .= $name . ' ';
+                $query .= $name.' ';
             }
 
             // Checking if the result of the builder should be added.
             if ($type & 1) {
-                $query .= $class::build($this->$field) . ' ';
+                $query .= $class::build($this->$field).' ';
             }
         }
 

tools/ContextGenerator.php

Spacing +51 added lines, -51 removed lines

@@ -53,47 +53,47 @@ 
      * @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" .
-        ' * @author     Dan Ungureanu <udan1107@gmail.com>'                                 . "\n" .
-        ' * @license    http://opensource.org/licenses/GPL-2.0 GNU Public License'          . "\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".
+        ' * @author     Dan Ungureanu <udan1107@gmail.com>'."\n".
+        ' * @license    http://opensource.org/licenses/GPL-2.0 GNU Public License'."\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.
@@ -198,7 +198,7 @@ 
                     if ($i == 0) {
                         $ret .= str_repeat(' ', $spaces);
                     }
-                    $ret .= "'" . $word . "' => " . $type . ', ';
+                    $ret .= "'".$word."' => ".$type.', ';
                     if (++$i == $count) {
                         $ret .= "\n";
                         $i = 0;
@@ -259,7 +259,7 @@ 
          *
          * @var string
          */
-        $directory = dirname($input) . '/';
+        $directory = dirname($input).'/';
 
         /**
          * The name of the file that contains the context.
@@ -280,7 +280,7 @@ 
          *
          * @var string
          */
-        $class = 'Context' . $name;
+        $class = 'Context'.$name;
 
         /**
          * The formatted name of this context.
@@ -288,13 +288,13 @@ 
          * @var string
          */
         $formattedName = str_replace(
-            array('Context', 'MySql',  '00', '0'),
-            array('',        'MySQL ', '',   '.'),
+            array('Context', 'MySql', '00', '0'),
+            array('', 'MySQL ', '', '.'),
             $class
         );
 
         file_put_contents(
-            $output . '/' . $class . '.php',
+            $output.'/'.$class.'.php',
             static::generate(
                 array(
                     'name'      => $formattedName,
@@ -302,9 +302,9 @@ 
                     'link'      => static::$LINKS[$name],
                     'keywords'  => static::readWords(
                         array(
-                            $directory . '_common.txt',
-                            $directory . '_functions' . $file,
-                            $directory . $file
+                            $directory.'_common.txt',
+                            $directory.'_functions'.$file,
+                            $directory.$file
                         )
                     ),
                 )
@@ -332,7 +332,7 @@ 
 
             // Building the context.
             sprintf("Building context for %s...\n", $file);
-            static::build($input . '/' . $file, $output);
+            static::build($input.'/'.$file, $output);
         }
     }
 }