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

Unused Use Statements -1 removed lines

@@ -33,7 +33,6 @@
 namespace SQLParser\Node;
 
 use Mouf\Database\MagicQueryException;
-use Mouf\Database\MagicQueryParserException;
 use SQLParser\SqlRenderInterface;
 use Doctrine\DBAL\Connection;
 use Mouf\MoufManager;

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/Query/StatementFactory.php

Spacing +1 added lines, -1 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);

src/SQLParser/SQLParser.php

Spacing +6 added lines, -6 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)
@@ -843,7 +843,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);
@@ -873,7 +873,7 @@ 
         }
 
         return array('expr_type' => $type, 'alias' => $alias, 'base_expr' => trim($base_expr),
-                     'sub_tree' => $processed, );
+                     'sub_tree' => $processed,);
     }
 
     /**
@@ -1015,7 +1015,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)
@@ -1099,7 +1099,7 @@ 
         }
 
         return array('expr_type' => $parseInfo['type'], 'base_expr' => $parseInfo['expr'],
-                     'direction' => $parseInfo['dir'], );
+                     'direction' => $parseInfo['dir'],);
     }
 
     private function initParseInfoForOrder()
@@ -1559,7 +1559,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/Node/Parameter.php

Spacing +2 added lines, -2 removed lines

@@ -164,7 +164,7 @@ 
         if (isset($parameters[$this->name])) {
             if ($dbConnection) {
                 if (is_array($parameters[$this->name])) {
-                    return '('.implode(',', array_map(function ($item) use ($dbConnection) {
+                    return '('.implode(',', array_map(function($item) use ($dbConnection) {
                             return $dbConnection->quote($this->autoPrepend.$item.$this->autoAppend);
                         }, $parameters[$this->name])).')';
                 } else {
@@ -175,7 +175,7 @@ 
                     return 'null';
                 } else {
                     if (is_array($parameters[$this->name])) {
-                        return '('.implode(',', array_map(function ($item) {
+                        return '('.implode(',', array_map(function($item) {
                             return "'".addslashes($this->autoPrepend.$item.$this->autoAppend)."'";
                         }, $parameters[$this->name])).')';
                     } else {

src/Mouf/Database/MagicQuery/Twig/SqlTwigEnvironmentFactory.php

Spacing +1 added lines, -1 removed lines

@@ -27,7 +27,7 @@
 
         // Default escaper will throw an exception. This is because we want to use SQL parameters instead of Twig.
         // This ahs a number of advantages, especially in terms of caching.
-        $twig->getExtension('core')->setEscaper('sql', function () {
+        $twig->getExtension('core')->setEscaper('sql', function() {
             throw new ForbiddenTwigParameterInSqlException('You cannot use Twig expressions (like "{{ id }}"). Instead, you should use SQL parameters (like ":id"). Twig integration is limited to Twig statements (like "{% for .... %}"');
         });
 

src/SQLParser/Node/In.php

Spacing +1 added lines, -1 removed lines

@@ -26,7 +26,7 @@
         $rightOperand = $this->getRightOperand();
         if ($rightOperand instanceof Parameter) {
             if (!isset($parameters[$rightOperand->getName()])) {
-                throw new MagicQueryException("Missing parameter '" . $rightOperand->getName() . "' for 'IN' operand.");
+                throw new MagicQueryException("Missing parameter '".$rightOperand->getName()."' for 'IN' operand.");
             }
             if ($parameters[$rightOperand->getName()] === []) {
                 return "FALSE";