rkrx / php-mysql-query-builder

src/Builder/RunnableSelect.php

Spacing +16 added lines, -16 removed lines

@@ -58,13 +58,13 @@ 
 	public function fetchRows(\Closure $callback = null) {
 		$statement = $this->createStatement();
 		$data = $statement->fetchAll(\PDO::FETCH_ASSOC);
-		if($this->preserveTypes) {
+		if ($this->preserveTypes) {
 			$columnDefinitions = FieldTypeProvider::getFieldTypes($statement);
-			foreach($data as &$row) {
+			foreach ($data as &$row) {
 				$row = FieldValueConverter::convertValues($row, $columnDefinitions);
 			}
 		}
-		if($callback !== null) {
+		if ($callback !== null) {
 			$data = array_map($callback, $data);
 		}
 		$statement->closeCursor();
@@ -76,7 +76,7 @@ 
 	 * @return array[]|\Generator
 	 */
 	public function fetchRowsLazy(\Closure $callback = null) {
-		if(version_compare(PHP_VERSION, '5.5', '<=')) {
+		if (version_compare(PHP_VERSION, '5.5', '<=')) {
 			return $this->fetchRows($callback);
 		}
 		$statement = $this->createStatement();
@@ -90,11 +90,11 @@ 
 	public function fetchRow() {
 		$statement = $this->createStatement();
 		$row = $statement->fetch(\PDO::FETCH_ASSOC);
-		if(!is_array($row)) {
+		if (!is_array($row)) {
 			$statement->closeCursor();
 			return array();
 		}
-		if($this->preserveTypes) {
+		if ($this->preserveTypes) {
 			$columnDefinitions = FieldTypeProvider::getFieldTypes($statement);
 			$row = FieldValueConverter::convertValues($row, $columnDefinitions);
 		}
@@ -109,13 +109,13 @@ 
 	public function fetchKeyValue($treatValueAsArray = false) {
 		$rows = $this->fetchRows();
 		$result = array();
-		if(!$treatValueAsArray) {
-			foreach($rows as $row) {
+		if (!$treatValueAsArray) {
+			foreach ($rows as $row) {
 				list($key, $value) = array_values($row);
 				$result[$key] = $value;
 			}
 		} else {
-			foreach($rows as $row) {
+			foreach ($rows as $row) {
 				list($key) = array_values($row);
 				$result[$key] = $row;
 			}
@@ -130,11 +130,11 @@ 
 	public function fetchGroups(array $fields) {
 		$rows = $this->fetchRows();
 		$result = array();
-		foreach($rows as $row) {
+		foreach ($rows as $row) {
 			$tmp = &$result;
-			foreach($fields as $field) {
+			foreach ($fields as $field) {
 				$value = $row[$field];
-				if(!array_key_exists($value, $tmp)) {
+				if (!array_key_exists($value, $tmp)) {
 					$tmp[$value] = [];
 				}
 				$tmp = &$tmp[$value];
@@ -148,7 +148,7 @@ 
 	 * @return string[]
 	 */
 	public function fetchArray() {
-		return $this->fetchRows(function ($row) {
+		return $this->fetchRows(function($row) {
 			reset($row);
 			return current($row);
 		});
@@ -162,10 +162,10 @@ 
 		$statement = $this->createStatement();
 		$row = $statement->fetch(\PDO::FETCH_ASSOC);
 		$statement->closeCursor();
-		if(!is_array($row)) {
+		if (!is_array($row)) {
 			return $default;
 		}
-		if(!count($row)) {
+		if (!count($row)) {
 			return null;
 		}
 		return array_shift($row);
@@ -186,7 +186,7 @@ 
 		$query = $this->__toString();
 		$statement = $db->prepare($query);
 		$statement->execute($this->values);
-		if($this->getCalcFoundRows()) {
+		if ($this->getCalcFoundRows()) {
 			$this->foundRows = (int) $db->query('SELECT FOUND_ROWS()')->fetchColumn();
 		}
 		return $statement;

src/Builder/Traits/LimitBuilder.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
 	 * @return string
 	 */
 	protected function buildLimit($query) {
-		if($this->limit !== null) {
+		if ($this->limit !== null) {
 			$query .= "LIMIT\n\t{$this->limit}\n";
 		}
 		return $query;

src/Builder/Traits/OffsetBuilder.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
 	 * @return string
 	 */
 	protected function buildOffset($query) {
-		if($this->offset !== null) {
+		if ($this->offset !== null) {
 			$query .= "OFFSET\n\t{$this->offset}\n";
 		}
 		return $query;

src/Builder/Traits/OrderByBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -15,11 +15,11 @@ 
 	 * @return $this
 	 */
 	public function orderBy($expression, $direction = 'asc') {
-		if(strtolower($direction) != 'desc') {
+		if (strtolower($direction) != 'desc') {
 			$direction = 'ASC';
 		}
-		if(is_array($expression)) {
-			if(!count($expression)) {
+		if (is_array($expression)) {
+			if (!count($expression)) {
 				return $this;
 			}
 			$arguments = array(
@@ -37,12 +37,12 @@ 
 	 * @return string
 	 */
 	protected function buildOrder($query) {
-		if(!count($this->orderBy)) {
+		if (!count($this->orderBy)) {
 			return $query;
 		}
 		$query .= "ORDER BY\n";
 		$arr = array();
-		foreach($this->orderBy as $order) {
+		foreach ($this->orderBy as $order) {
 			list($expression, $direction) = $order;
 			$arr[] = sprintf("\t%s %s", $expression, strtoupper($direction));
 		}

src/Builder/Traits/GroupByBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -13,9 +13,9 @@ 
 	 * @return $this
 	 */
 	public function groupBy() {
-		foreach(func_get_args() as $expression) {
-			if(is_array($expression)) {
-				if(!count($expression)) {
+		foreach (func_get_args() as $expression) {
+			if (is_array($expression)) {
+				if (!count($expression)) {
 					continue;
 				}
 				$arguments = array(
@@ -34,12 +34,12 @@ 
 	 * @return string
 	 */
 	protected function buildGroups($query) {
-		if(!count($this->groupBy)) {
+		if (!count($this->groupBy)) {
 			return $query;
 		}
 		$query .= "GROUP BY\n";
 		$arr = array();
-		foreach($this->groupBy as $expression) {
+		foreach ($this->groupBy as $expression) {
 			$arr[] = "\t{$expression}";
 		}
 		return $query.join(",\n", $arr)."\n";

src/Builder/Traits/TableNameBuilder.php

Spacing +4 added lines, -4 removed lines

@@ -10,17 +10,17 @@
 	 * @return string
 	 */
 	protected function buildTableName($alias, $name) {
-		if(is_object($name)) {
+		if (is_object($name)) {
 			$name = (string) $name;
 			$lines = explode("\n", $name);
-			foreach($lines as &$line) {
+			foreach ($lines as &$line) {
 				$line = "\t{$line}";
 			}
 			$name = join("\n", $lines);
-			$name = '(' . trim(rtrim(trim($name), ';')) . ')';
+			$name = '('.trim(rtrim(trim($name), ';')).')';
 		}
 		$name = $this->aliasReplacer()->replace($name);
-		if($alias !== null) {
+		if ($alias !== null) {
 			return sprintf("%s %s", $name, $alias);
 		}
 		return $name;

src/Builder/Traits/UnionBuilder.php

Spacing +4 added lines, -4 removed lines

@@ -30,21 +30,21 @@
 	 * @return string
 	 */
 	protected function buildUnions($query) {
-		$wrap = function ($query) {
+		$wrap = function($query) {
 			$query = trim($query);
 			$query = join("\n\t", explode("\n", $query));
 			return sprintf("(\n\t%s\n)", $query);
 		};
 		$queries = [$wrap($query)];
-		foreach($this->unions as $unionQuery) {
-			if($unionQuery[0] === 'ALL') {
+		foreach ($this->unions as $unionQuery) {
+			if ($unionQuery[0] === 'ALL') {
 				$queries[] = 'UNION ALL';
 			} else {
 				$queries[] = 'UNION';
 			}
 			$queries[] = $wrap($unionQuery[1]);
 		}
-		if(count($queries) > 1) {
+		if (count($queries) > 1) {
 			return join(" ", $queries);
 		}
 		return $query;

src/Builder/Traits/TableBuilder.php

Spacing +3 added lines, -3 removed lines

@@ -15,7 +15,7 @@ 
 	 * @return $this
 	 */
 	protected function addTable($alias, $table = null) {
-		if($table === null) {
+		if ($table === null) {
 			list($alias, $table) = [$table, $alias];
 		}
 		$this->tables[] = array('alias' => $alias, 'name' => $table);
@@ -28,10 +28,10 @@ 
 	 */
 	protected function buildTables($query) {
 		$arr = array();
-		foreach($this->tables as $table) {
+		foreach ($this->tables as $table) {
 			$arr[] = "\t".$this->buildTableName($table['alias'], $table['name']);
 		}
-		if(count($arr)) {
+		if (count($arr)) {
 			$query .= join(",\n", $arr)."\n";
 		}
 		return $query;

src/Builder/Traits/JoinBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -49,15 +49,15 @@
 	 */
 	protected function buildJoins($query) {
 		$arr = array();
-		foreach($this->joinTables as $table) {
+		foreach ($this->joinTables as $table) {
 			$join = $table['type']." JOIN\n";
-			$join .= "\t" . $this->buildTableName($table['alias'], $table['name']);
-			if($table['expression']) {
-				$join .= " ON " . $this->db()->quoteExpression($table['expression'], $table['arguments']);
+			$join .= "\t".$this->buildTableName($table['alias'], $table['name']);
+			if ($table['expression']) {
+				$join .= " ON ".$this->db()->quoteExpression($table['expression'], $table['arguments']);
 			}
 			$arr[] = $join;
 		}
-		if(count($arr)) {
+		if (count($arr)) {
 			$query .= join("\n", $arr)."\n";
 		}
 		return $query;