adumitru68 / QueryBuilder

src/Traits/DefaultPriority.php

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
      */
     public function defaultPriority()
     {
-        $this->queryStructure->setElement(QueryStructure::PRIORITY, '');
+        $this->queryStructure->setElement( QueryStructure::PRIORITY, '' );
 
         return $this;
     }

src/Dependencies/QueryHelper.php

Spacing +44 added lines, -44 removed lines

@@ -15,10 +15,10 @@ 
      * @param string $string
      * @return mixed|string
      */
-    public static function clearMultipleSpaces($string = '')
+    public static function clearMultipleSpaces( $string = '' )
     {
-        $string = preg_replace('/\s+/', ' ', $string);
-        $string = trim($string);
+        $string = preg_replace( '/\s+/', ' ', $string );
+        $string = trim( $string );
 
         return $string;
     }
@@ -27,11 +27,11 @@ 
      * @param $val
      * @return bool
      */
-    public static function isInteger($val)
+    public static function isInteger( $val )
     {
-        $val = trim($val);
+        $val = trim( $val );
 
-        return is_numeric($val) && floor($val) == $val;
+        return is_numeric( $val ) && floor( $val ) == $val;
     }
 
     /**
@@ -39,34 +39,34 @@ 
      * @return bool
      * @i
      */
-    public static function isDecimal($val)
+    public static function isDecimal( $val )
     {
-        $val = trim($val);
+        $val = trim( $val );
 
-        return is_numeric($val) && floor($val) != $val;
+        return is_numeric( $val ) && floor( $val ) != $val;
     }
 
-    public static function isValidOrderBy($order_by_parameter)
+    public static function isValidOrderBy( $order_by_parameter )
     {
 
-        $columns = array('first_name', 'last_name', 'zip', 'created_at');
+        $columns = array( 'first_name', 'last_name', 'zip', 'created_at' );
 
-        $parts = preg_split("/[\s,]+/", $order_by_parameter);
+        $parts = preg_split( "/[\s,]+/", $order_by_parameter );
 
-        foreach ($parts as $part) {
-            $subparts = preg_split("/\s+/", $part);
+        foreach ( $parts as $part ) {
+            $subparts = preg_split( "/\s+/", $part );
 
-            if (count($subparts) < 0 || count($subparts) > 2) {
+            if ( count( $subparts ) < 0 || count( $subparts ) > 2 ) {
                 // Too many or too few parts.
                 return false;
             }
 
-            if (!in_array($subparts[0], $columns)) {
+            if ( !in_array( $subparts[ 0 ], $columns ) ) {
                 // Column name is invalid.
                 return false;
             }
 
-            if (count($subparts) == 2 && !in_array(strtoupper($subparts[1]), array('ASC', 'DESC'))) {
+            if ( count( $subparts ) == 2 && !in_array( strtoupper( $subparts[ 1 ] ), array( 'ASC', 'DESC' ) ) ) {
                 // ASC or DESC is invalid
                 return false;
             }
@@ -81,24 +81,24 @@ 
      * @param string $delimiter
      * @return array
      */
-    public static function explode($string, $delimiter = ',')
+    public static function explode( $string, $delimiter = ',' )
     {
-        $brutArray = explode($delimiter, $string);
+        $brutArray = explode( $delimiter, $string );
         $newArray = array();
-        foreach ($brutArray as $value) {
-            $value = trim($value);
-            if ('' !== $value)
-                $newArray[] = $value;
+        foreach ( $brutArray as $value ) {
+            $value = trim( $value );
+            if ( '' !== $value )
+                $newArray[ ] = $value;
         }
 
         return $newArray;
     }
 
-    public static function alphaNum($string)
+    public static function alphaNum( $string )
     {
-        $string = preg_replace("/[^a-zA-Z0-9 _,]+/", "", $string);
+        $string = preg_replace( "/[^a-zA-Z0-9 _,]+/", "", $string );
 
-        return self::clearMultipleSpaces($string);
+        return self::clearMultipleSpaces( $string );
     }
 
     /**
@@ -106,12 +106,12 @@ 
      * @param string $delimiter
      * @return string
      */
-    public static function implode(array $array, $delimiter = ',')
+    public static function implode( array $array, $delimiter = ',' )
     {
-        $string = implode($delimiter, $array);
-        $string = trim($string);
-        $string = trim($string, trim($delimiter));
-        $string = trim($string);
+        $string = implode( $delimiter, $array );
+        $string = trim( $string );
+        $string = trim( $string, trim( $delimiter ) );
+        $string = trim( $string );
 
         return $string;
     }
@@ -120,36 +120,36 @@ 
      * @param $string
      * @return mixed|string
      */
-    public static function clearQuotes($string)
+    public static function clearQuotes( $string )
     {
-        $search = array('"', "'");
+        $search = array( '"', "'" );
         $replace = '';
-        $string = str_replace($search, $replace, $string);
+        $string = str_replace( $search, $replace, $string );
 
-        return self::clearMultipleSpaces($string);
+        return self::clearMultipleSpaces( $string );
     }
 
     /**
      * @param int $length
      * @return string
      */
-    public static function random($length = 5)
+    public static function random( $length = 5 )
     {
         $characters = 'abcdefghijklmnopqrstuvwxyz';
-        $charactersLength = strlen($characters);
+        $charactersLength = strlen( $characters );
         $randomString = '';
-        for ($i = 0; $i < $length; $i++)
-            $randomString .= $characters[ rand(0, $charactersLength - 1) ];
+        for ( $i = 0; $i < $length; $i++ )
+            $randomString .= $characters[ rand( 0, $charactersLength - 1 ) ];
 
-        return str_shuffle($randomString);
+        return str_shuffle( $randomString );
     }
 
-    public static function limitString($rowCount, $offset = null)
+    public static function limitString( $rowCount, $offset = null )
     {
-        $rowCount = intval($rowCount);
-        if (is_null($offset))
+        $rowCount = intval( $rowCount );
+        if ( is_null( $offset ) )
             return $rowCount;
-        $offset = intval($offset);
+        $offset = intval( $offset );
 
         return "$offset, $rowCount";
     }

src/Dependencies/QueryTimer.php

Spacing +2 added lines, -2 removed lines

@@ -27,7 +27,7 @@ 
      */
     public function __construct()
     {
-        $this->queryStart = microtime(true);
+        $this->queryStart = microtime( true );
     }
 
     /**
@@ -35,7 +35,7 @@ 
      */
     public function getDuration()
     {
-        $this->queryEnd = microtime(true);
+        $this->queryEnd = microtime( true );
 
         return $this->queryEnd - $this->queryStart;
     }

src/Dependencies/QueryStructure.php

Spacing +34 added lines, -34 removed lines

@@ -60,7 +60,7 @@ 
     /**
      * @var array
      */
-    private static $usedInstanceIds = [];
+    private static $usedInstanceIds = [ ];
 
     /**
      * @var array
@@ -85,24 +85,24 @@ 
     {
         $this->syntaxEL = $this->init();
 
-        foreach ($this->syntaxEL as $name => $value)
-            $this->typeEL[ $name ] = gettype($value);
+        foreach ( $this->syntaxEL as $name => $value )
+            $this->typeEL[ $name ] = gettype( $value );
 
     }
 
     private function init()
     {
-        return [self::TABLE => '', self::EXPLAIN => 0, self::STATEMENT => '', self::PRIORITY => '', self::FIELDS => '*', self::SET_FIELDS => array(), self::WHERE => array(), self::HAVING => array(), self::WHERE_INVERT => 0, self::HAVING_INVERT => 0, self::LIMIT => 0, self::ORDER_BY => array(), self::GROUP_BY => array(), self::COUNT => 0, self::COLUMN => '', self::FIRST => 0, self::DISTINCT => 0, self::JOIN => array(), self::IGNORE => 0, self::MULTIPLE_ROWS => 0, self::QUERY => '', self::BIND_PARAMS => array(), self::REPLACEMENT => 0, self::QUERY_TYPE => 0, self::QUERY_STRING => '', self::QUERY_COMMENT => '', self::QUERY_IDENTIFIER => 'DEFAULT', self::WHERE_TRIGGER => 1, self::INSTANCE => $this->makeStatementInstance()];
+        return [ self::TABLE => '', self::EXPLAIN => 0, self::STATEMENT => '', self::PRIORITY => '', self::FIELDS => '*', self::SET_FIELDS => array(), self::WHERE => array(), self::HAVING => array(), self::WHERE_INVERT => 0, self::HAVING_INVERT => 0, self::LIMIT => 0, self::ORDER_BY => array(), self::GROUP_BY => array(), self::COUNT => 0, self::COLUMN => '', self::FIRST => 0, self::DISTINCT => 0, self::JOIN => array(), self::IGNORE => 0, self::MULTIPLE_ROWS => 0, self::QUERY => '', self::BIND_PARAMS => array(), self::REPLACEMENT => 0, self::QUERY_TYPE => 0, self::QUERY_STRING => '', self::QUERY_COMMENT => '', self::QUERY_IDENTIFIER => 'DEFAULT', self::WHERE_TRIGGER => 1, self::INSTANCE => $this->makeStatementInstance() ];
     }
 
 
     private function makeStatementInstance()
     {
-        $instance = QueryHelper::random(5);
-        while (in_array($instance, self::$usedInstanceIds)) {
-            $instance = QueryHelper::random(7);
+        $instance = QueryHelper::random( 5 );
+        while ( in_array( $instance, self::$usedInstanceIds ) ) {
+            $instance = QueryHelper::random( 7 );
         }
-        self::$usedInstanceIds[] = $instance;
+        self::$usedInstanceIds[ ] = $instance;
 
         return $instance;
     }
@@ -128,7 +128,7 @@ 
     /**
      * @param $elements
      */
-    public function setAllElements($elements)
+    public function setAllElements( $elements )
     {
         $this->syntaxEL = $elements;
     }
@@ -140,16 +140,16 @@ 
      * @return bool
      * @throws QueryException
      */
-    public function setElement($name, $value)
+    public function setElement( $name, $value )
     {
-        if (!array_key_exists($name, $this->syntaxEL))
-            throw new QueryException('Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND);
+        if ( !array_key_exists( $name, $this->syntaxEL ) )
+            throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
 
-        if ($name == self::TABLE && is_a($value, QueryStatement::class))
+        if ( $name == self::TABLE && is_a( $value, QueryStatement::class ) )
             return true;
 
-        if ($this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY)
-            $this->syntaxEL[ $name ][] = $value; else
+        if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
+            $this->syntaxEL[ $name ][ ] = $value; else
             $this->syntaxEL[ $name ] = $value;
 
         return true;
@@ -161,10 +161,10 @@ 
      * @param $elementValue
      * @throws QueryException
      */
-    public function replaceElement($elementName, $elementValue)
+    public function replaceElement( $elementName, $elementValue )
     {
-        if (!array_key_exists($elementName, $this->syntaxEL))
-            throw new QueryException('Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND);
+        if ( !array_key_exists( $elementName, $this->syntaxEL ) )
+            throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
 
         $this->syntaxEL[ $elementName ] = $elementValue;
     }
@@ -174,7 +174,7 @@ 
      * @param string $name
      * @return mixed
      */
-    public function getElement($name)
+    public function getElement( $name )
     {
         return $this->syntaxEL[ $name ];
     }
@@ -184,7 +184,7 @@ 
      * @param $name
      * @param $value
      */
-    public function setParams($name, $value)
+    public function setParams( $name, $value )
     {
         $this->syntaxEL[ QueryStructure::BIND_PARAMS ][ $name ] = $value;
     }
@@ -195,9 +195,9 @@ 
      * @param $value
      * @return string
      */
-    public function bindParam($name, $value)
+    public function bindParam( $name, $value )
     {
-        $pdoName = $this->index($name);
+        $pdoName = $this->index( $name );
         $this->syntaxEL[ QueryStructure::BIND_PARAMS ][ $pdoName ] = $value;
 
         return ':' . $pdoName;
@@ -210,27 +210,27 @@ 
      * @param string $search
      * @return string
      */
-    public function bindParamsExpression($expression, array $params = [], $search = '?')
+    public function bindParamsExpression( $expression, array $params = [ ], $search = '?' )
     {
-        if (!count($params))
+        if ( !count( $params ) )
             return $expression;
 
-        if (strpos($expression, $search) === false)
+        if ( strpos( $expression, $search ) === false )
             return $expression;
 
-        $params = array_slice($params, 0, substr_count($expression, $search));
+        $params = array_slice( $params, 0, substr_count( $expression, $search ) );
 
         $i = 0;
-        $arrayReturn = [];
-        $expressionToArray = explode($search, $expression);
+        $arrayReturn = [ ];
+        $expressionToArray = explode( $search, $expression );
 
-        foreach ($expressionToArray as $sub) {
-            $arrayReturn[] = $sub;
-            $arrayReturn[] = array_key_exists($i, $params) ? $this->bindParam('exp', $params[ $i ]) : '';
+        foreach ( $expressionToArray as $sub ) {
+            $arrayReturn[ ] = $sub;
+            $arrayReturn[ ] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
             $i++;
         }
 
-        return implode('', $arrayReturn);
+        return implode( '', $arrayReturn );
     }
 
 
@@ -238,9 +238,9 @@ 
      * @param string $fieldName
      * @return string
      */
-    public function index($fieldName = '')
+    public function index( $fieldName = '' )
     {
-        return trim($fieldName) . '_' . $this->syntaxEL[ self::INSTANCE ] . '_' . ++$this->counter . 'i';
+        return trim( $fieldName ) . '_' . $this->syntaxEL[ self::INSTANCE ] . '_' . ++$this->counter . 'i';
     }
 
 }
\ No newline at end of file

src/QueryBuild.php

Spacing +11 added lines, -11 removed lines

@@ -26,7 +26,7 @@ 
      * QueryBuild constructor.
      * @param $queryType
      */
-    protected function __construct($queryType)
+    protected function __construct( $queryType )
     {
         $this->queryType = $queryType;
     }
@@ -35,45 +35,45 @@ 
      * @param $table
      * @return QuerySelect
      */
-    public static function select($table)
+    public static function select( $table )
     {
-        return new QuerySelect(new QueryBuild(0), $table);
+        return new QuerySelect( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryUpdate
      */
-    public static function update($table)
+    public static function update( $table )
     {
-        return new QueryUpdate(new QueryBuild(0), $table);
+        return new QueryUpdate( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryInsert
      */
-    public static function insert($table)
+    public static function insert( $table )
     {
-        return new QueryInsert(new QueryBuild(0), $table);
+        return new QueryInsert( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryDelete
      */
-    public static function delete($table)
+    public static function delete( $table )
     {
-        return new QueryDelete(new QueryBuild(0), $table);
+        return new QueryDelete( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $query
      * @return QueryCustom
      */
-    public static function query($query)
+    public static function query( $query )
     {
-        return new QueryCustom(new QueryBuild(1), $query);
+        return new QueryCustom( new QueryBuild( 1 ), $query );
     }
 
     /**

src/Statements/QuerySelect.php

Spacing +42 added lines, -42 removed lines

@@ -42,21 +42,21 @@ 
      * @param QueryBuild $queryBuild
      * @param string|QueryStatement $table
      */
-    public function __construct(QueryBuild $queryBuild, $table)
+    public function __construct( QueryBuild $queryBuild, $table )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
 
-        if (is_a($table, QuerySelect::class)) {
+        if ( is_a( $table, QuerySelect::class ) ) {
 
             /**
              * @var QuerySelect $table
              */
             $tableName = '( ' . $table->getSyntax() . ' )';
-            $this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
+            $this->queryStructure->setElement( QueryStructure::TABLE, $tableName );
 
             $tableSelectParams = $table->getBindParams();
-            foreach ($tableSelectParams as $key => $value)
-                $this->queryStructure->setParams($key, $value);
+            foreach ( $tableSelectParams as $key => $value )
+                $this->queryStructure->setParams( $key, $value );
 
         }
     }
@@ -66,7 +66,7 @@ 
      */
     public function first()
     {
-        $this->queryStructure->setElement(QueryStructure::FIRST, 1);
+        $this->queryStructure->setElement( QueryStructure::FIRST, 1 );
 
         return $this;
     }
@@ -76,7 +76,7 @@ 
      */
     public function count()
     {
-        $this->queryStructure->setElement(QueryStructure::COUNT, 1);
+        $this->queryStructure->setElement( QueryStructure::COUNT, 1 );
 
         return $this;
     }
@@ -85,10 +85,10 @@ 
      * @param $column
      * @return $this
      */
-    public function column($column)
+    public function column( $column )
     {
-        $column = QueryHelper::clearMultipleSpaces($column);
-        $this->queryStructure->setElement(QueryStructure::COLUMN, $column);
+        $column = QueryHelper::clearMultipleSpaces( $column );
+        $this->queryStructure->setElement( QueryStructure::COLUMN, $column );
 
         return $this;
     }
@@ -98,83 +98,83 @@ 
      * @param bool|int $replacement
      * @return mixed|string
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
 
-        if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
-            $this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-            $this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
+        if ( $this->queryStructure->getElement( QueryStructure::COUNT ) ) {
+            $this->queryStructure->setElement( QueryStructure::FIELDS, 'COUNT(*)' );
+            $this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
+            $this->queryStructure->setElement( QueryStructure::DISTINCT, 0 ); //???
         }
 
-        if ($this->queryStructure->getElement(QueryStructure::FIRST))
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+        if ( $this->queryStructure->getElement( QueryStructure::FIRST ) )
+            $this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
 
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * SELECT statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * DISTINCT clause
          */
-        $syntax[] = $this->getDistinctSyntax();
+        $syntax[ ] = $this->getDistinctSyntax();
 
         /**
          * FIELDS
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::FIELDS );
 
         /**
          * FROM table or queryStructure
          */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * JOIN CLAUSES
          */
-        $syntax[] = $this->getJoinSyntax();
+        $syntax[ ] = $this->getJoinSyntax();
 
         /**
          * WHERE clause
          */
-        $syntax[] = $this->getWhereSyntax();
+        $syntax[ ] = $this->getWhereSyntax();
 
         /**
          * GROUP BY clause
          */
-        $syntax[] = $this->getGroupBySyntax();
+        $syntax[ ] = $this->getGroupBySyntax();
 
         /**
          * HAVING clause
          */
-        $syntax[] = $this->getHavingSyntax();
+        $syntax[ ] = $this->getHavingSyntax();
 
         /**
          * ORDER BY clause
          */
-        $syntax[] = $this->getOrderBySyntax();
+        $syntax[ ] = $this->getOrderBySyntax();
 
         /**
          * LIMIT clause
          */
-        $syntax[] = $this->getLimitSyntax();
+        $syntax[ ] = $this->getLimitSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
@@ -185,21 +185,21 @@ 
     public function execute()
     {
 
-        switch (true) {
-            case $this->queryStructure->getElement(QueryStructure::COUNT):
-                return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        switch ( true ) {
+            case $this->queryStructure->getElement( QueryStructure::COUNT ):
+                return DbService::getInstance()->single( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
-            case $this->queryStructure->getElement(QueryStructure::FIRST):
-                if ($this->queryStructure->getElement(QueryStructure::COLUMN))
-                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+            case $this->queryStructure->getElement( QueryStructure::FIRST ):
+                if ( $this->queryStructure->getElement( QueryStructure::COLUMN ) )
+                    return DbService::getInstance()->single( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
 
-                return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                return DbService::getInstance()->row( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
-            case $this->queryStructure->getElement(QueryStructure::COLUMN):
-                return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+            case $this->queryStructure->getElement( QueryStructure::COLUMN ):
+                return DbService::getInstance()->column( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
             default:
-                return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
         }
     }

src/Statements/QueryCustom.php

Spacing +11 added lines, -11 removed lines

@@ -35,7 +35,7 @@ 
     /**
      * @var array
      */
-    protected $usedInstanceIds = [];
+    protected $usedInstanceIds = [ ];
 
     /**
      * @var string
@@ -48,22 +48,22 @@ 
      * @param QueryBuild $queryBuild
      * @param string $query
      */
-    public function __construct(QueryBuild $queryBuild, $query = '')
+    public function __construct( QueryBuild $queryBuild, $query = '' )
     {
         $this->queryBuild = $queryBuild;
         $this->queryStructure = new QueryStructure();
-        $this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
-        $this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
-        $this->queryStructure->setElement(QueryStructure::QUERY_STRING, $query);
+        $this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
+        $this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
+        $this->queryStructure->setElement( QueryStructure::QUERY_STRING, $query );
     }
 
     /**
      * @param array $params
      * @return $this
      */
-    public function withBindParams(array $params = [])
+    public function withBindParams( array $params = [ ] )
     {
-        $this->queryStructure->replaceElement(QueryStructure::BIND_PARAMS, $params);
+        $this->queryStructure->replaceElement( QueryStructure::BIND_PARAMS, $params );
 
         return $this;
     }
@@ -72,9 +72,9 @@ 
      * @param bool|int $replacement
      * @return mixed
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
-        return $this->queryStructure->getElement(QueryStructure::QUERY_STRING);
+        return $this->queryStructure->getElement( QueryStructure::QUERY_STRING );
     }
 
     /**
@@ -82,7 +82,7 @@ 
      */
     public function getBindParams()
     {
-        return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+        return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
     }
 
     /**
@@ -90,7 +90,7 @@ 
      */
     public function execute()
     {
-        return DbService::getInstance()->query($this->queryStructure->getElement(QueryStructure::QUERY_STRING), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->queryStructure->getElement( QueryStructure::QUERY_STRING ), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 
 

src/Statements/QueryUpdate.php

Spacing +17 added lines, -17 removed lines

@@ -39,12 +39,12 @@ 
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
     }
 
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
 
         $syntax = array();
@@ -52,51 +52,51 @@ 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * IGNORE clause
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
         /**
          * TABLE update
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * FIELDS update
          */
-        $syntax[] = $this->getSettingFieldsSyntax();
+        $syntax[ ] = $this->getSettingFieldsSyntax();
 
         /**
          * WHERE clause
          */
-        $syntax[] = $this->getWhereSyntax();
+        $syntax[ ] = $this->getWhereSyntax();
 
         /**
          * ORDER BY clause
          */
-        $syntax[] = $this->getOrderBySyntax();
+        $syntax[ ] = $this->getOrderBySyntax();
 
         /**
          * LIMIT clause
          */
-        $syntax[] = $this->getLimitSyntax();
+        $syntax[ ] = $this->getLimitSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
@@ -106,9 +106,9 @@ 
      */
     public function execute()
     {
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
+            throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 }
\ No newline at end of file

src/Statements/QueryInsert.php

Spacing +13 added lines, -13 removed lines

@@ -36,9 +36,9 @@ 
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
     }
 
     /**
@@ -46,57 +46,57 @@ 
      */
     public function multiple()
     {
-        return new QueryInsertMultiple($this->queryBuild, $this->queryStructure->getElement(QueryStructure::TABLE));
+        return new QueryInsertMultiple( $this->queryBuild, $this->queryStructure->getElement( QueryStructure::TABLE ) );
     }
 
     /**
      * @param bool|int $replacement
      * @return mixed|string
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * IGNORE clause
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
         /**
          * INTO table
          */
-        $syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * FIELDS update
          */
-        $syntax[] = $this->getSettingFieldsSyntax();
+        $syntax[ ] = $this->getSettingFieldsSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
 
     public function execute()
     {
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }