phpmyadmin / sql-parser

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/TestGenerator.php

Spacing +5 added lines, -5 removed lines

@@ -152,9 +152,9 @@ 
             }
 
             // Appending the filename to directories.
-            $inputFile = $input . '/' . $file;
-            $outputFile = $output . '/' . $file;
-            $debugFile = ($debug !== null) ? $debug . '/' . $file : null;
+            $inputFile = $input.'/'.$file;
+            $outputFile = $output.'/'.$file;
+            $debugFile = ($debug !== null) ? $debug.'/'.$file : null;
 
             if (is_dir($inputFile)) {
                 // Creating required directories to maintain the structure.
@@ -171,9 +171,9 @@ 
             } elseif (substr($inputFile, -3) === '.in') {
                 // Generating file names by replacing `.in` with `.out` and
                 // `.debug`.
-                $outputFile = substr($outputFile, 0, -3) . '.out';
+                $outputFile = substr($outputFile, 0, -3).'.out';
                 if ($debug !== null) {
-                    $debugFile = substr($debugFile, 0, -3) . '.debug';
+                    $debugFile = substr($debugFile, 0, -3).'.debug';
                 }
 
                 // Building the test.

src/Components/Expression.php

Spacing +3 added lines, -3 removed lines

@@ -228,7 +228,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)
@@ -255,7 +255,7 @@ 
                         continue;
                     }
                     $isExpr = true;
-                } elseif ($brackets === 0 && count($ret->expr) > 0 && ! $alias) {
+                } elseif ($brackets === 0 && count($ret->expr) > 0 && !$alias) {
                     /* End of expression */
                     break;
                 }
@@ -433,7 +433,7 @@ 
             }
 
             if (!empty($component->alias)) {
-                $ret .= ' AS ' . Context::escape($component->alias);
+                $ret .= ' AS '.Context::escape($component->alias);
             }
 
             return $ret;

src/Statements/CreateStatement.php

Spacing +29 added lines, -29 removed lines

@@ -277,80 +277,80 @@
         $fields = '';
         if (!empty($this->fields)) {
             if (is_array($this->fields)) {
-                $fields = CreateDefinition::build($this->fields) . ' ';
+                $fields = CreateDefinition::build($this->fields).' ';
             } elseif ($this->fields instanceof ArrayObj) {
                 $fields = ArrayObj::build($this->fields);
             }
         }
         if ($this->options->has('DATABASE')) {
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
                 . OptionsArray::build($this->entityOptions);
         } elseif ($this->options->has('TABLE') && !is_null($this->select)) {
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
                 . $this->select->build();
         } elseif ($this->options->has('TABLE') && !is_null($this->like)) {
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' LIKE '
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' LIKE '
                 . Expression::build($this->like);
         } elseif ($this->options->has('TABLE')) {
             $partition = '';
 
             if (!empty($this->partitionBy)) {
-                $partition .= "\nPARTITION BY " . $this->partitionBy;
+                $partition .= "\nPARTITION BY ".$this->partitionBy;
             }
             if (!empty($this->partitionsNum)) {
-                $partition .= "\nPARTITIONS " . $this->partitionsNum;
+                $partition .= "\nPARTITIONS ".$this->partitionsNum;
             }
             if (!empty($this->subpartitionBy)) {
-                $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy;
+                $partition .= "\nSUBPARTITION BY ".$this->subpartitionBy;
             }
             if (!empty($this->subpartitionsNum)) {
-                $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum;
+                $partition .= "\nSUBPARTITIONS ".$this->subpartitionsNum;
             }
             if (!empty($this->partitions)) {
-                $partition .= "\n" . PartitionDefinition::build($this->partitions);
+                $partition .= "\n".PartitionDefinition::build($this->partitions);
             }
 
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
                 . $fields
                 . OptionsArray::build($this->entityOptions)
                 . $partition;
         } elseif ($this->options->has('VIEW')) {
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
-                . $fields . ' AS ' . TokensList::build($this->body) . ' '
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
+                . $fields.' AS '.TokensList::build($this->body).' '
                 . OptionsArray::build($this->entityOptions);
         } elseif ($this->options->has('TRIGGER')) {
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
-                . OptionsArray::build($this->entityOptions) . ' '
-                . 'ON ' . Expression::build($this->table) . ' '
-                . 'FOR EACH ROW ' . TokensList::build($this->body);
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
+                . OptionsArray::build($this->entityOptions).' '
+                . 'ON '.Expression::build($this->table).' '
+                . 'FOR EACH ROW '.TokensList::build($this->body);
         } elseif (($this->options->has('PROCEDURE'))
             || ($this->options->has('FUNCTION'))
         ) {
             $tmp = '';
             if ($this->options->has('FUNCTION')) {
-                $tmp = 'RETURNS ' . DataType::build($this->return);
+                $tmp = 'RETURNS '.DataType::build($this->return);
             }
             return 'CREATE '
-                . OptionsArray::build($this->options) . ' '
-                . Expression::build($this->name) . ' '
-                . ParameterDefinition::build($this->parameters) . ' '
-                . $tmp . ' ' . TokensList::build($this->body);
+                . OptionsArray::build($this->options).' '
+                . Expression::build($this->name).' '
+                . ParameterDefinition::build($this->parameters).' '
+                . $tmp.' '.TokensList::build($this->body);
         }
         return 'CREATE '
-            . OptionsArray::build($this->options) . ' '
-            . Expression::build($this->name) . ' '
+            . OptionsArray::build($this->options).' '
+            . Expression::build($this->name).' '
             . TokensList::build($this->body);
     }