thecodingmachine / magic-query

src/SQLParser/LexerSplitter.php

Spacing +1 added lines, -1 removed lines

@@ -37,7 +37,7 @@
 class LexerSplitter
 {
     private static $splitters = array("\r\n", '!=', '>=', '<=', '<>', ':=', '\\', '&&', '>', '<', '|', '=', '^', '(',
-                                      ')', "\t", "\n", "'", '"', '`', ',', '@', ' ', '+', '-', '*', '/', ';', );
+                                      ')', "\t", "\n", "'", '"', '`', ',', '@', ' ', '+', '-', '*', '/', ';',);
     private $tokenSize;
     private $hashSet;
 

src/SQLParser/Node/NodeFactory.php

Spacing +4 added lines, -4 removed lines

@@ -335,7 +335,7 @@ 
             if (!empty($subTree) && !isset($subTree[0])) {
                 $subTree = StatementFactory::toObject($subTree);
             } else {
-                $subTree = array_map(function ($item) {
+                $subTree = array_map(function($item) {
                     if (is_array($item)) {
                         return self::toObject($item);
                     } else {
@@ -365,7 +365,7 @@ 
             array('NOT'),
             array('&&', 'AND'),
             array('XOR'),
-            array('||', 'OR'), );
+            array('||', 'OR'),);
 
     private static $OPERATOR_TO_CLASS = array(
             '=' => 'SQLParser\Node\Equal',
@@ -626,7 +626,7 @@ 
     {
         $instanceDescriptor = $moufManager->createInstance(get_called_class());
 
-        return self::array_map_deep($node, function ($item) use ($moufManager) {
+        return self::array_map_deep($node, function($item) use ($moufManager) {
             if ($item instanceof NodeInterface) {
                 return $item->toInstanceDescriptor($moufManager);
             } else {
@@ -670,7 +670,7 @@ 
     {
         if (is_array($nodes)) {
             $elems = array();
-            array_walk_recursive($nodes, function ($item) use (&$elems, $dbConnection, $indent, $delimiter, $parameters, $conditionsMode) {
+            array_walk_recursive($nodes, function($item) use (&$elems, $dbConnection, $indent, $delimiter, $parameters, $conditionsMode) {
                 if ($item instanceof SqlRenderInterface) {
                     $itemSql = $item->toSql($parameters, $dbConnection, $indent, $conditionsMode);
                     if ($itemSql !== null) {

src/SQLParser/Node/Parameter.php

Spacing +8 added lines, -8 removed lines

@@ -68,8 +68,8 @@ 
      */
     public function setName($name)
     {
-        if (strrpos($name, '!') === strlen($name)-1) {
-            $this->name = substr($name, 0, strlen($name)-1);
+        if (strrpos($name, '!') === strlen($name) - 1) {
+            $this->name = substr($name, 0, strlen($name) - 1);
             $this->discardedOnNull = false;
         } else {
             $this->name = $name;
@@ -164,22 +164,22 @@ 
     {
         if (isset($parameters[$this->name])) {
             if ($dbConnection) {
-                if(is_array($parameters[$this->name])){
-                    return '('.implode(',',array_map(function($item) use ($dbConnection) {
+                if (is_array($parameters[$this->name])) {
+                    return '('.implode(',', array_map(function($item) use ($dbConnection) {
                             return $dbConnection->quote($this->autoPrepend.$item.$this->autoAppend);
                         }, $parameters[$this->name])).')';
-                } else{
+                } else {
                     return $dbConnection->quote($this->autoPrepend.$parameters[$this->name].$this->autoAppend);
                 }
             } else {
                 if ($parameters[$this->name] === null) {
                     return "null";
                 } else {
-                    if(is_array($parameters[$this->name])){
-                        return '('.implode(',',array_map(function($item) {
+                    if (is_array($parameters[$this->name])) {
+                        return '('.implode(',', array_map(function($item) {
                             return "'".addslashes($this->autoPrepend.$item.$this->autoAppend)."'";
                         }, $parameters[$this->name])).')';
-                    } else{
+                    } else {
                        return "'".addslashes($this->autoPrepend.$parameters[$this->name].$this->autoAppend)."'"; 
                     }
                     

src/SQLParser/PHPSQLParserConstants.php

Spacing +4 added lines, -4 removed lines

@@ -98,7 +98,7 @@ 
                                        'TRAILING', 'TRUE', 'UNDO', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED', 'UPDATE',
                                        'USAGE', 'USE', 'USER_RESOURCES', 'USING', 'UTC_DATE', 'UTC_TIME',
                                        'UTC_TIMESTAMP', 'VALUES', 'VARBINARY', 'VARCHAR', 'VARCHARACTER', 'VARYING',
-                                       'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', );
+                                       'WHEN', 'WHERE', 'WHILE', 'WITH', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL',);
 
     protected static $parameterizedFunctions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT',
                                                      'AGAINST', 'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN',
@@ -131,7 +131,7 @@ 
                                                      'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE',
                                                      'UNCOMPRESS', 'UNCOMPRESSED_LENGTH', 'UNHEX', 'UPPER', 'VAR_POP',
                                                      'VAR_SAMP', 'VARIANCE', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR',
-                                                     'YEARWEEK', );
+                                                     'YEARWEEK',);
 
     protected static $functions = array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_ENCRYPT', 'AES_DECRYPT', 'AGAINST',
                                         'ASCII', 'ASIN', 'ATAN', 'AVG', 'BENCHMARK', 'BIN', 'BIT_AND', 'BIT_OR',
@@ -162,9 +162,9 @@ 
                                         'TIME_TO_SEC', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS',
                                         'UNCOMPRESSED_LENGTH', 'UNHEX', 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE',
                                         'UTC_TIME', 'UTC_TIMESTAMP', 'UUID', 'VAR_POP', 'VAR_SAMP', 'VARIANCE',
-                                        'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK', );
+                                        'VERSION', 'WEEK', 'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEEK',);
 
     protected static $aggregateFunctions = array('AVG', 'SUM', 'COUNT', 'MIN', 'MAX', 'STDDEV', 'STDDEV_SAMP',
                                                  'STDDEV_POP', 'VARIANCE', 'VAR_SAMP', 'VAR_POP', 'GROUP_CONCAT',
-                                                 'BIT_AND', 'BIT_OR', 'BIT_XOR', );
+                                                 'BIT_AND', 'BIT_OR', 'BIT_XOR',);
 }

src/SQLParser/PositionCalculator.php

Spacing +1 added lines, -1 removed lines

@@ -44,7 +44,7 @@
 {
     private static $allowedOnOperator = array("\t", "\n", "\r", ' ', ',', '(', ')', '_', "'", '"');
     private static $allowedOnOther = array("\t", "\n", "\r", ' ', ',', '(', ')', '<', '>', '*', '+', '-', '/', '|',
-                                           '&', '=', '!', ';', );
+                                           '&', '=', '!', ';',);
 
     private function printPos($text, $sql, $charPos, $key, $parsed, $backtracking)
     {

src/SQLParser/Node/LimitNode.php

Spacing +2 added lines, -2 removed lines

@@ -91,11 +91,11 @@
      */
     public function toSql(array $parameters = array(), Connection $dbConnection = null, $indent = 0, $conditionsMode = self::CONDITION_APPLY)
     {
-        if($this->value === null) {
+        if ($this->value === null) {
             throw new \Exception('A limit parameter must be an integer');
         }
 
-        if(is_numeric($this->value)) {
+        if (is_numeric($this->value)) {
            return (int) $this->value;
         } else if ($dbConnection != null) {
             return $dbConnection->quote($this->value);

src/SQLParser/SQLParser.php

Spacing +8 added lines, -8 removed lines

@@ -571,7 +571,7 @@ 
         $assignment = $this->process_expr_list($this->splitSQLIntoTokens($base_expr));
 
         return array('expr_type' => ExpressionType::EXPRESSION, 'base_expr' => trim($base_expr),
-                     'sub_tree' => $assignment, );
+                     'sub_tree' => $assignment,);
     }
 
     private function getVariableType($expression)
@@ -692,8 +692,8 @@ 
         }
 
         return [
-            ['expr_type' => 'limit_const', 'base_expr' => trim($offset), 'sub_tree' => false ],
-            ['expr_type' => 'limit_const', 'base_expr' => trim($rowcount), 'sub_tree' => false ]
+            ['expr_type' => 'limit_const', 'base_expr' => trim($offset), 'sub_tree' => false],
+            ['expr_type' => 'limit_const', 'base_expr' => trim($rowcount), 'sub_tree' => false]
         ];
     }
 
@@ -846,7 +846,7 @@ 
                     || $this->isFunction($prev) || $this->isExpression($prev) || $this->isSubQuery($prev)
                     || $this->isColumnReference($prev) || $this->isBracketExpression($prev)) {
                 $alias = array('as' => false, 'name' => trim($last['base_expr']),
-                               'base_expr' => trim($last['base_expr']), );
+                               'base_expr' => trim($last['base_expr']),);
                 #remove the last token
                 array_pop($tokens);
                 $base_expr = implode('', $tokens);
@@ -876,7 +876,7 @@ 
         }
 
         return array('expr_type' => $type, 'alias' => $alias, 'base_expr' => trim($base_expr),
-                     'sub_tree' => $processed, );
+                     'sub_tree' => $processed,);
     }
 
     /**
@@ -1018,7 +1018,7 @@ 
         return array('expression' => '', 'token_count' => 0, 'table' => '', 'alias' => false, 'join_type' => '',
                      'next_join_type' => '', 'saved_join_type' => $parseInfo['saved_join_type'],
                      'ref_type' => false, 'ref_expr' => false, 'base_expr' => false, 'sub_tree' => false,
-                     'subquery' => '', );
+                     'subquery' => '',);
     }
 
     private function processFromExpression(&$parseInfo)
@@ -1102,7 +1102,7 @@ 
         }
 
         return array('expr_type' => $parseInfo['type'], 'base_expr' => $parseInfo['expr'],
-                     'direction' => $parseInfo['dir'], );
+                     'direction' => $parseInfo['dir'],);
     }
 
     private function initParseInfoForOrder()
@@ -1562,7 +1562,7 @@ 
                 unset($values[$k]);
             } else {
                 $values[$k] = array('expr_type' => ExpressionType::RECORD, 'base_expr' => $v,
-                                    'data' => $this->process_record($v), );
+                                    'data' => $this->process_record($v),);
             }
         }
 

src/SQLParser/Query/StatementFactory.php

Spacing +2 added lines, -2 removed lines

@@ -48,7 +48,7 @@ 
         if (isset($desc['SELECT'])) {
             $select = new Select();
 
-            $columns = array_map(function ($item) {
+            $columns = array_map(function($item) {
                 return NodeFactory::toObject($item);
             }, $desc['SELECT']);
             $columns = NodeFactory::simplify($columns);
@@ -118,7 +118,7 @@ 
      * @throws \Exception
      */
     private static function checkLimitDesc(array $descLimit) {
-        if(count($descLimit) > 2) {
+        if (count($descLimit) > 2) {
             throw new \Exception('The limit returned by the SQLParser contains more than 2 items, something might went wrong.');
         }
         return ['offset' => $descLimit[0], 'limit' => $descLimit[1]];

src/SQLParser/Query/Select.php

Spacing +2 added lines, -2 removed lines

@@ -388,7 +388,7 @@ 
                 throw new \Exception('There is no offset if no limit is provided. An error may have occurred during SQLParsing.');
             }
 
-            if($limit !== null) {
+            if ($limit !== null) {
                 $sql .= "\nLIMIT ";
                 if ($offset !== null) {
                     $sql .= $offset.', ';
@@ -426,7 +426,7 @@ 
         if ($children) {
             if (is_array($children)) {
                 foreach ($children as $key => $operand) {
-                    if($operand) {
+                    if ($operand) {
                         $result2 = $operand->walk($visitor);
                         if ($result2 === NodeTraverser::REMOVE_NODE) {
                             unset($children[$key]);