phpmyadmin / sql-parser

src/Utils/Query.php

Doc Comments +1 added lines, -1 removed lines

@@ -505,7 +505,7 @@
      * @param Statement  $statement The parsed query that has to be modified.
      * @param TokensList $list      The list of tokens.
      * @param string     $clause    The clause to be returned.
-     * @param int|string $type      The type of the search.
+     * @param integer $type      The type of the search.
      *                              If int,
      *                                -1 for everything that was before
      *                                 0 only for the clause

Spacing +7 added lines, -7 removed lines

@@ -651,13 +651,13 @@ 
         }
 
         if ($onlyType) {
-            return static::getClause($statement, $list, $old, -1, false).' '.
-                $new.' '.static::getClause($statement, $list, $old, 0).' '.
+            return static::getClause($statement, $list, $old, -1, false) . ' ' .
+                $new . ' ' . static::getClause($statement, $list, $old, 0) . ' ' .
                 static::getClause($statement, $list, $old, 1, false);
         }
 
-        return static::getClause($statement, $list, $old, -1, false).' '.
-            $new.' '.static::getClause($statement, $list, $old, 1, false);
+        return static::getClause($statement, $list, $old, -1, false) . ' ' .
+            $new . ' ' . static::getClause($statement, $list, $old, 1, false);
     }
 
     /**
@@ -699,15 +699,15 @@ 
         }
 
         // Adding everything before first replacement.
-        $ret .= static::getClause($statement, $list, $ops[0][0], -1).' ';
+        $ret .= static::getClause($statement, $list, $ops[0][0], -1) . ' ';
 
         // Doing replacements.
         for ($i = 0; $i < $count; ++$i) {
-            $ret .= $ops[$i][1].' ';
+            $ret .= $ops[$i][1] . ' ';
 
             // Adding everything between this and next replacement.
             if ($i + 1 !== $count) {
-                $ret .= static::getClause($statement, $list, $ops[$i][0], $ops[$i + 1][0]).' ';
+                $ret .= static::getClause($statement, $list, $ops[$i][0], $ops[$i + 1][0]) . ' ';
             }
         }
 

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

Spacing +6 added lines, -6 removed lines

@@ -212,14 +212,14 @@ 
         $ret = 'CASE ';
         if (isset($component->value)) {
             // Syntax type 0
-            $ret .= $component->value.' ';
+            $ret .= $component->value . ' ';
             for (
                 $i = 0;
                 $i < count($component->compare_values) && $i < count($component->results);
                 ++$i
             ) {
-                $ret .= 'WHEN '.$component->compare_values[$i].' ';
-                $ret .= 'THEN '.$component->results[$i].' ';
+                $ret .= 'WHEN ' . $component->compare_values[$i] . ' ';
+                $ret .= 'THEN ' . $component->results[$i] . ' ';
             }
         } else {
             // Syntax type 1
@@ -228,12 +228,12 @@ 
                 $i < count($component->conditions) && $i < count($component->results);
                 ++$i
             ) {
-                $ret .= 'WHEN '.Condition::build($component->conditions[$i]).' ';
-                $ret .= 'THEN '.$component->results[$i].' ';
+                $ret .= 'WHEN ' . Condition::build($component->conditions[$i]) . ' ';
+                $ret .= 'THEN ' . $component->results[$i] . ' ';
             }
         }
         if (isset($component->else_result)) {
-            $ret .= 'ELSE '.$component->else_result.' ';
+            $ret .= 'ELSE ' . $component->else_result . ' ';
         }
         $ret .= 'END';
 

src/Components/PartitionDefinition.php

Doc Comments +1 added lines, -1 removed lines

@@ -194,7 +194,7 @@
     }
 
     /**
-     * @param PartitionDefinition|PartitionDefinition[] $component the component to be built
+     * @param PartitionDefinition[] $component the component to be built
      * @param array                                     $options   parameters for building
      *
      * @return string

Spacing +6 added lines, -6 removed lines

@@ -202,18 +202,18 @@
     public static function build($component, array $options = array())
     {
         if (is_array($component)) {
-            return "(\n".implode(",\n", $component)."\n)";
+            return "(\n" . implode(",\n", $component) . "\n)";
         } else {
             if ($component->isSubpartition) {
-                return trim('SUBPARTITION '.$component->name.' '.$component->options);
+                return trim('SUBPARTITION ' . $component->name . ' ' . $component->options);
             } else {
                 $subpartitions = empty($component->subpartitions)
-                    ? '' : ' '.self::build($component->subpartitions);
+                    ? '' : ' ' . self::build($component->subpartitions);
 
                 return trim(
-                    'PARTITION '.$component->name
-                    .(empty($component->type) ? '' : ' VALUES '.$component->type.' '.$component->expr.' ')
-                    .$component->options.$subpartitions
+                    'PARTITION ' . $component->name
+                    .(empty($component->type) ? '' : ' VALUES ' . $component->type . ' ' . $component->expr . ' ')
+                    .$component->options . $subpartitions
                 );
             }
         }

src/Statements/UpdateStatement.php

Spacing +7 added lines, -7 removed lines

@@ -52,15 +52,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/Statements/AlterStatement.php

Spacing +3 added lines, -3 removed lines

@@ -143,8 +143,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/ReplaceStatement.php

Spacing +5 added lines, -5 removed lines

@@ -87,15 +87,15 @@
      */
     public function build()
     {
-        $ret = 'REPLACE '.$this->options
-            .' INTO '.$this->into;
+        $ret = 'REPLACE ' . $this->options
+            .' INTO ' . $this->into;
 
         if ($this->values != null && count($this->values) > 0) {
-            $ret .= ' VALUES '.Array2d::build($this->values);
+            $ret .= ' VALUES ' . Array2d::build($this->values);
         } elseif ($this->set != null && count($this->set) > 0) {
-            $ret .= ' SET '.SetOperation::build($this->set);
+            $ret .= ' SET ' . SetOperation::build($this->set);
         } elseif ($this->select != null && strlen($this->select) > 0) {
-            $ret .= ' '.$this->select->build();
+            $ret .= ' ' . $this->select->build();
         }
 
         return $ret;

src/Statements/NotImplementedStatement.php

Spacing +1 added lines, -1 removed lines

@@ -35,7 +35,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/DeleteStatement.php

Spacing +15 added lines, -15 removed lines

@@ -67,15 +67,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),
     );
 
     /**
@@ -132,25 +132,25 @@ 
      */
     public function build()
     {
-        $ret = 'DELETE '.OptionsArray::build($this->options);
+        $ret = 'DELETE ' . OptionsArray::build($this->options);
 
         if ($this->columns != null && count($this->columns) > 0) {
-            $ret .= ' '.ExpressionArray::build($this->columns);
+            $ret .= ' ' . ExpressionArray::build($this->columns);
         }
         if ($this->from != null && count($this->from) > 0) {
-            $ret .= ' FROM '.ExpressionArray::build($this->from);
+            $ret .= ' FROM ' . ExpressionArray::build($this->from);
         }
         if ($this->using != null && count($this->using) > 0) {
-            $ret .= ' USING '.ExpressionArray::build($this->using);
+            $ret .= ' USING ' . ExpressionArray::build($this->using);
         }
         if ($this->where != null && count($this->where) > 0) {
-            $ret .= ' WHERE '.Condition::build($this->where);
+            $ret .= ' WHERE ' . Condition::build($this->where);
         }
         if ($this->order != null && count($this->order) > 0) {
-            $ret .= ' ORDER BY '.ExpressionArray::build($this->order);
+            $ret .= ' ORDER BY ' . ExpressionArray::build($this->order);
         }
         if ($this->limit != null && strlen($this->limit) > 0) {
-            $ret .= ' LIMIT '.Limit::build($this->limit);
+            $ret .= ' LIMIT ' . Limit::build($this->limit);
         }
 
         return $ret;

src/Statements/DropStatement.php

Spacing +4 added lines, -4 removed lines

@@ -49,12 +49,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),
     );
 
     /**