phpmyadmin / sql-parser

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

src/Statements/SelectStatement.php

Spacing +27 added lines, -27 removed lines

@@ -83,36 +83,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),

src/Statements/InsertStatement.php

Spacing +6 added lines, -6 removed lines

@@ -109,19 +109,19 @@
      */
     public function build()
     {
-        $ret = 'INSERT '.$this->options
-            .' INTO '.$this->into;
+        $ret = 'INSERT ' . $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();
         }
 
         if ($this->onDuplicateSet != null && count($this->onDuplicateSet) > 0) {
-            $ret .= ' ON DUPLICATE KEY UPDATE '.SetOperation::build($this->onDuplicateSet);
+            $ret .= ' ON DUPLICATE KEY UPDATE ' . SetOperation::build($this->onDuplicateSet);
         }
 
         return $ret;