adumitru68 / QueryBuilder

src/Statements/QueryStatementInterface.php

Spacing +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
 	 * @param bool $replacement
 	 * @return string
 	 */
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE );
+	public function getSyntax($replacement = self::REPLACEMENT_NONE);
 
 	public function execute();
 

src/Statements/QueryStatement.php

Spacing +6 added lines, -6 removed lines

@@ -63,16 +63,16 @@ 
 	 * @param string $table
 	 * @throws QueryException
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = '' )
+	public function __construct(QueryBuild $queryBuild, $table = '')
 	{
 
-		$table = $this->validateTable( $table );
+		$table = $this->validateTable($table);
 
 		$this->queryBuild = $queryBuild;
 		$this->queryStructure = new QueryStructure();
-		$this->queryStructure->setElement( QueryStructure::TABLE, $table );
-		$this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
-		$this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
+		$this->queryStructure->setElement(QueryStructure::TABLE, $table);
+		$this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
+		$this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
 
 	}
 
@@ -81,7 +81,7 @@ 
 	 */
 	public function getBindParams()
 	{
-		return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
+		return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
 	}
 
 

src/Statements/QueryInsertMultiple.php

Spacing +10 added lines, -10 removed lines

@@ -36,13 +36,13 @@ 
 	 * @param QueryBuild $queryBuild
 	 * @param null $table
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = null )
+	public function __construct(QueryBuild $queryBuild, $table = null)
 	{
-		parent::__construct( $queryBuild, $table );
-		$this->queryStructure->setElement( QueryStructure::FIELDS, array() );
+		parent::__construct($queryBuild, $table);
+		$this->queryStructure->setElement(QueryStructure::FIELDS, array());
 	}
 
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE )
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
 	{
 		$syntax = array();
 
@@ -59,26 +59,26 @@ 
 		/**
 		 * 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->getInsertMultipleRowsSyntax();
 
-		$syntax = implode( ' ', $syntax );
+		$syntax = implode(' ', $syntax);
 
-		return $this->getSyntaxReplace( $syntax, $replacement );
+		return $this->getSyntaxReplace($syntax, $replacement);
 
 	}
 
@@ -86,7 +86,7 @@ 
 	{
 		return DbService::getInstance()->query(
 			$this->getSyntax(),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 	}
 }
\ No newline at end of file

src/Statements/QueryInsert.php

Spacing +10 added lines, -10 removed lines

@@ -36,9 +36,9 @@ 
 	 * @param QueryBuild $queryBuild
 	 * @param null $table
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = null )
+	public function __construct(QueryBuild $queryBuild, $table = null)
 	{
-		parent::__construct( $queryBuild, $table );
+		parent::__construct($queryBuild, $table);
 	}
 
 	/**
@@ -46,14 +46,14 @@ 
 	 */
 	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();
 
@@ -70,26 +70,26 @@ 
 		/**
 		 * 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 = implode( ' ', $syntax );
+		$syntax = implode(' ', $syntax);
 
-		return $this->getSyntaxReplace( $syntax, $replacement );
+		return $this->getSyntaxReplace($syntax, $replacement);
 
 	}
 
@@ -98,7 +98,7 @@ 
 	{
 		return DbService::getInstance()->query(
 			$this->getSyntax(),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 	}
 

src/Statements/QuerySelect.php

Spacing +33 added lines, -33 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,17 +98,17 @@ 
 	 * @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();
 
@@ -125,7 +125,7 @@ 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
 
 		/**
 		 * DISTINCT clause
@@ -135,12 +135,12 @@ 
 		/**
 		 * 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
@@ -172,9 +172,9 @@ 
 		 */
 		$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;
 		}
 	}

Braces +9 added lines, -6 removed lines

@@ -55,8 +55,9 @@ 
 			$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 );
+			}
 
 		}
 	}
@@ -107,8 +108,9 @@ 
 			$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();
 
@@ -190,8 +192,9 @@ 
 				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 ) );
+				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 ) );
 				break;

src/Statements/QueryDelete.php

Spacing +11 added lines, -11 removed lines

@@ -40,12 +40,12 @@ 
 	 * @param QueryBuild $queryBuild
 	 * @param null $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();
 
@@ -62,12 +62,12 @@ 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
 
 		/**
 		 * WHERE clause
@@ -84,9 +84,9 @@ 
 		 */
 		$syntax[] = $this->getLimitSyntax();
 
-		$syntax = implode( ' ', $syntax );
+		$syntax = implode(' ', $syntax);
 
-		return $this->getSyntaxReplace( $syntax, $replacement );
+		return $this->getSyntaxReplace($syntax, $replacement);
 	}
 
 	/**
@@ -97,14 +97,14 @@ 
 	{
 
 		if (
-			$this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) &&
-			!count( $this->queryStructure->getElement( QueryStructure::WHERE ) )
+			$this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) &&
+			!count($this->queryStructure->getElement(QueryStructure::WHERE))
 		)
-			throw new QueryException( 'Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+			throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
 
 		return DbService::getInstance()->query(
 			$this->getSyntax(),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 
 	}

Braces +3 added lines, -2 removed lines

@@ -99,8 +99,9 @@
 		if (
 			$this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) &&
 			!count( $this->queryStructure->getElement( QueryStructure::WHERE ) )
-		)
-			throw new QueryException( 'Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		) {
+					throw new QueryException( 'Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+		}
 
 		return DbService::getInstance()->query(
 			$this->getSyntax(),

config/qpdb_db_config.php

Spacing +1 added lines, -1 removed lines

@@ -9,7 +9,7 @@
 
 	'replicationEnable' => false,
 
-	'slave_statements' => [ 'SELECT' ],
+	'slave_statements' => ['SELECT'],
 
 	/**
 	 * if not Replication support use only first entry in master_data_connect

sample/select.php

Spacing +7 added lines, -7 removed lines

@@ -11,13 +11,13 @@
 include_once $_SERVER['DOCUMENT_ROOT'] . '/vendor/autoload.php';
 
 
-$query = QueryBuild::select( 'employees' )
+$query = QueryBuild::select('employees')
 	->fields('lastName, jobTitle, officeCode')
-	->whereEqual( 'jobTitle', "Sales Rep" )
-	->whereIn( 'officeCode', [ 2, 3, 4 ] );
+	->whereEqual('jobTitle', "Sales Rep")
+	->whereIn('officeCode', [2, 3, 4]);
 
 
-echo "<pre>" . print_r( $query->getSyntax(), 1 ) . "</pre>";
-echo "<pre>" . print_r( $query->getBindParams(), 1 ) . "</pre>";
-echo "<pre>" . print_r( $query->getSyntax( 1 ), 1 ) . "</pre>";
-echo "<pre>" . print_r( $query->execute(), 1 ) . "</pre>";
\ No newline at end of file
+echo "<pre>" . print_r($query->getSyntax(), 1) . "</pre>";
+echo "<pre>" . print_r($query->getBindParams(), 1) . "</pre>";
+echo "<pre>" . print_r($query->getSyntax(1), 1) . "</pre>";
+echo "<pre>" . print_r($query->execute(), 1) . "</pre>";
\ No newline at end of file