adumitru68 / QueryBuilder

src/Statements/QueryDelete.php

Braces +3 added lines, -2 removed lines

@@ -96,8 +96,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 PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
 	}

src/Statements/QuerySelect.php

Braces +6 added lines, -4 removed lines

@@ -56,8 +56,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 );
+			}
 
 		}
 	}
@@ -112,8 +113,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();
 

src/Statements/QueryUpdate.php

Braces +3 added lines, -2 removed lines

@@ -107,8 +107,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 PdoWrapperService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS))->rowCount();
 	}

src/AbstractCruds/AbstractTableCrud.php

Braces +21 added lines, -14 removed lines

@@ -57,8 +57,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::select( $this->table )->fields( $fields );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->first()->execute();
 	}
@@ -73,8 +74,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::delete( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 
 		return $result->execute();
 	}
@@ -89,8 +91,9 @@ 
 	{
 		$conditions = $this->getPrimaryKeyConditions( $id );
 		$result = QueryBuild::update( $this->table );
-		foreach ( $conditions as $field => $value )
-			$result->whereEqual( $field, $value );
+		foreach ( $conditions as $field => $value ) {
+					$result->whereEqual( $field, $value );
+		}
 		$result->setFieldsByArray( $arrayUpdater );
 
 		return $result->execute();
@@ -115,8 +118,9 @@ 
 	 */
 	public function saveOrder( $updates_ord = array() )
 	{
-		if ( empty( $this->orderField ) )
-			throw new QueryException( 'Order field is not defined' );
+		if ( empty( $this->orderField ) ) {
+					throw new QueryException( 'Order field is not defined' );
+		}
 
 		$query = /** @lang text */
 			"UPDATE `{$this->table}` SET `{$this->orderField}` = CASE `{$this->primary[0]}` \r\n";
@@ -137,16 +141,19 @@ 
 	 */
 	protected function getPrimaryKeyConditions( $id )
 	{
-		if ( !is_array( $id ) )
-			$id = [ $id ];
+		if ( !is_array( $id ) ) {
+					$id = [ $id ];
+		}
 
-		if ( count( $this->primary ) !== count( $id ) )
-			throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		if ( count( $this->primary ) !== count( $id ) ) {
+					throw new QueryException( 'Invalid primary key', QueryException::QUERY_CRUD_INVALID_PRIMARY );
+		}
 
 		$conditions = [];
 
-		foreach ( $this->primary as $index => $key )
-			$conditions[ $key ] = $id[ $index ];
+		foreach ( $this->primary as $index => $key ) {
+					$conditions[ $key ] = $id[ $index ];
+		}
 
 		return $conditions;
 	}

src/Traits/TableValidation.php

Braces +9 added lines, -6 removed lines

@@ -49,8 +49,9 @@ 
 	{
 		$table = trim( $table );
 
-		if ( '' === $table )
-			throw new QueryException( 'Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( '' === $table ) {
+					throw new QueryException( 'Table name is empty string!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
 		return QueryHelper::addBacktick($table);
 	}
@@ -62,11 +63,13 @@ 
 	 */
 	private function validateTableSubQuery( $table )
 	{
-		if ( $this->statement !== QueryStatement::QUERY_STATEMENT_SELECT )
-			throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( $this->statement !== QueryStatement::QUERY_STATEMENT_SELECT ) {
+					throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
-		if ( !is_a( $table, QuerySelect::class ) )
-			throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		if ( !is_a( $table, QuerySelect::class ) ) {
+					throw new QueryException( 'Invalid subQuery statement!', QueryException::QUERY_ERROR_INVALID_TABLE_STATEMENT );
+		}
 
 		return $table;
 	}

src/Traits/Utilities.php

Braces +3 added lines, -2 removed lines

@@ -34,8 +34,9 @@
 	 */
 	protected function getExplainSyntax()
 	{
-		if ( $this->queryStructure->getElement( QueryStructure::EXPLAIN ) )
-			return 'EXPLAIN';
+		if ( $this->queryStructure->getElement( QueryStructure::EXPLAIN ) ) {
+					return 'EXPLAIN';
+		}
 
 		return '';
 	}

src/Traits/OrderBy.php

Braces +9 added lines, -6 removed lines

@@ -28,8 +28,9 @@ 
 	 */
 	public function orderBy( $column, array $allowedColumns = [] )
 	{
-		if ( !$this->validateColumn( $column, $allowedColumns ) )
-			throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		if ( !$this->validateColumn( $column, $allowedColumns ) ) {
+					throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		}
 
 		$column = $this->queryStructure->prepare($column);
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
@@ -46,8 +47,9 @@ 
 	 */
 	public function orderByDesc( $column, array $allowedColumns = [] )
 	{
-		if ( !$this->validateColumn( $column, $allowedColumns ) )
-			throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		if ( !$this->validateColumn( $column, $allowedColumns ) ) {
+					throw new QueryException( 'Invalid column name in ORDER BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		}
 
 		$column = $this->queryStructure->prepare($column);
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column . ' DESC' );
@@ -74,8 +76,9 @@ 
 	 */
 	private function getOrderBySyntax()
 	{
-		if ( count( $this->queryStructure->getElement( QueryStructure::ORDER_BY ) ) )
-			return 'ORDER BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::ORDER_BY ), ', ' );
+		if ( count( $this->queryStructure->getElement( QueryStructure::ORDER_BY ) ) ) {
+					return 'ORDER BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::ORDER_BY ), ', ' );
+		}
 
 		return '';
 	}

src/Traits/ColumnValidation.php

Braces +6 added lines, -4 removed lines

@@ -26,11 +26,13 @@
 	 */
 	protected function validateColumn( $columnName, array $allowed )
 	{
-		if ( is_integer( $columnName ) )
-			return true;
+		if ( is_integer( $columnName ) ) {
+					return true;
+		}
 
-		if ( !count( $allowed ) )
-			return true;
+		if ( !count( $allowed ) ) {
+					return true;
+		}
 
 		return false;
 	}

src/Traits/GroupBy.php

Braces +9 added lines, -6 removed lines

@@ -28,8 +28,9 @@ 
 	 */
 	public function groupBy( $column, array $allowedColumns = [] )
 	{
-		if ( !$this->validateColumn( $column, $allowedColumns ) )
-			throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		if ( !$this->validateColumn( $column, $allowedColumns ) ) {
+					throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		}
 
 		$column = $this->queryStructure->prepare($column);
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
@@ -48,8 +49,9 @@ 
 	 */
 	public function groupByDesc( $column, array $allowedColumns = [] )
 	{
-		if ( !$this->validateColumn( $column, $allowedColumns ) )
-			throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		if ( !$this->validateColumn( $column, $allowedColumns ) ) {
+					throw new QueryException( 'Invalid column name in GROUP BY clause', QueryException::QUERY_ERROR_INVALID_COLUMN_NAME );
+		}
 
 		$column = $this->queryStructure->prepare($column);
 		$this->queryStructure->setElement( QueryStructure::ORDER_BY, $column );
@@ -78,8 +80,9 @@ 
 	 */
 	private function getGroupBySyntax()
 	{
-		if ( count( $this->queryStructure->getElement( QueryStructure::GROUP_BY ) ) )
-			return 'GROUP BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::GROUP_BY ), ', ' );
+		if ( count( $this->queryStructure->getElement( QueryStructure::GROUP_BY ) ) ) {
+					return 'GROUP BY ' . QueryHelper::implode( $this->queryStructure->getElement( QueryStructure::GROUP_BY ), ', ' );
+		}
 
 		return '';
 	}