rkrx / php-mysql-query-builder

src/Databases/MySQL/MySQLExceptionInterpreter.php

Spacing +1 added lines, -1 removed lines

@@ -19,7 +19,7 @@
 		/** @link http://php.net/manual/en/class.exception.php#Hcom115813 (cHao's comment) */
 		$code = is_array($errorInfo) && isset($errorInfo[1]) ? ((int) $errorInfo[1]) : ((int) $exception->getCode());
 		$message = $exception->getMessage();
-		switch($code) {
+		switch ($code) {
 			case 2006: throw new DatabaseHasGoneAwayException($message, $code, $exception);
 			case 1213: throw new SqlDeadLockException($message, $code, $exception);
 			case 1205: throw new LockWaitTimeoutExceededException($message, $code, $exception);

src/Tools/VirtualTables.php

Spacing +3 added lines, -3 removed lines

@@ -31,10 +31,10 @@
 	 * @return Select|null
 	 */
 	public function get($tableName): ?Select {
-		if($this->has($tableName)) {
+		if ($this->has($tableName)) {
 			$table = $this->virtualTables[(string) $tableName];
-			if($table instanceof Closure) {
-				if($tableName instanceof VirtualTable) {
+			if ($table instanceof Closure) {
+				if ($tableName instanceof VirtualTable) {
 					$params = $tableName->getParams();
 					return $table($params);
 				}

src/Builder/Traits/JoinBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -49,15 +49,15 @@
 	 */
 	protected function buildJoins(string $query): string {
 		$arr = [];
-		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 .= implode("\n", $arr)."\n";
 		}
 		return $query;

src/Builder/Traits/UnionBuilder.php

Spacing +6 added lines, -6 removed lines

@@ -14,7 +14,7 @@ 
 	 * @return $this
 	 */
 	public function union(...$queries) {
-		foreach($queries as $query) {
+		foreach ($queries as $query) {
 			$this->unions[] = ['', $query];
 		}
 		return $this;
@@ -25,7 +25,7 @@ 
 	 * @return $this
 	 */
 	public function unionAll(...$queries) {
-		foreach($queries as $query) {
+		foreach ($queries as $query) {
 			$this->unions[] = ['ALL', $query];
 		}
 		return $this;
@@ -36,21 +36,21 @@ 
 	 * @return string
 	 */
 	protected function buildUnions(string $query): string {
-		$wrap = static function ($query) {
+		$wrap = static function($query) {
 			$query = trim($query);
 			$query = implode("\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 implode(' ', $queries);
 		}
 		return $query;

src/Builder/Traits/TableNameBuilder.php

Spacing +10 added lines, -10 removed lines

@@ -14,34 +14,34 @@
 	 * @return string
 	 */
 	protected function buildTableName(?string $alias, $name): string {
-		if(is_object($name) && !($name instanceof VirtualTable) && method_exists($name, '__toString')) {
+		if (is_object($name) && !($name instanceof VirtualTable) && method_exists($name, '__toString')) {
 			$name = (string) $name;
 			$lines = explode("\n", $name);
-			$lines = array_map(static function (string $line) { return "\t{$line}"; }, $lines);
+			$lines = array_map(static function(string $line) { return "\t{$line}"; }, $lines);
 			$name = implode("\n", $lines);
-			$name = '(' . trim(rtrim(trim($name), ';')) . ')';
+			$name = '('.trim(rtrim(trim($name), ';')).')';
 		}
-		if(is_array($name)) {
+		if (is_array($name)) {
 			$parts = [];
-			foreach($name as $index => $bucket) {
-				if(is_scalar($bucket) && ctype_digit((string) $index)) {
+			foreach ($name as $index => $bucket) {
+				if (is_scalar($bucket) && ctype_digit((string) $index)) {
 					$parts[] = "SELECT {$this->db()->quote($bucket)} AS {$this->db()->quoteField('value')}";
 				} else {
 					$values = [];
-					foreach($bucket as $field => $value) {
+					foreach ($bucket as $field => $value) {
 						$values[] = sprintf('%s AS %s', $this->db()->quote($value), $this->db()->quoteField($field));
 					}
 					$parts[] = sprintf("SELECT %s", implode(', ', $values));
 				}
 			}
-			$name = '(' . implode("\n\tUNION\n\t", $parts) . ')';
+			$name = '('.implode("\n\tUNION\n\t", $parts).')';
 		}
-		if((is_string($name) || $name instanceof VirtualTable) && $this->db()->getVirtualTables()->has($name)) {
+		if ((is_string($name) || $name instanceof VirtualTable) && $this->db()->getVirtualTables()->has($name)) {
 			$select = (string) $this->db()->getVirtualTables()->get($name);
 			$name = sprintf('(%s)', implode("\n\t", explode("\n", trim($select))));
 		}
 		$name = $this->aliasReplacer()->replace((string) $name);
-		if($alias !== null) {
+		if ($alias !== null) {
 			return sprintf("%s %s", $name, $alias);
 		}
 		return $name;

src/Builder/Traits/GroupByBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -14,9 +14,9 @@ 
 	 * @return $this
 	 */
 	public function groupBy(...$args) {
-		foreach($args as $expression) {
-			if(is_array($expression)) {
-				if(!count($expression)) {
+		foreach ($args as $expression) {
+			if (is_array($expression)) {
+				if (!count($expression)) {
 					continue;
 				}
 				$expression = $this->quoteExpr($expression[0], array_slice($expression, 1));
@@ -31,12 +31,12 @@ 
 	 * @return string
 	 */
 	protected function buildGroups(string $query): string {
-		if(!count($this->groupBy)) {
+		if (!count($this->groupBy)) {
 			return $query;
 		}
 		$query .= "GROUP BY\n";
 		$arr = [];
-		foreach($this->groupBy as $expression) {
+		foreach ($this->groupBy as $expression) {
 			$arr[] = "\t{$expression}";
 		}
 		return $query.implode(",\n", $arr)."\n";

src/Builder/Traits/TableBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -26,10 +26,10 @@
 	 */
 	protected function buildTables(string $query): string {
 		$arr = [];
-		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 .= implode(",\n", $arr)."\n";
 		}
 		return $query;

src/Builder/InsertUpdateStatement.php

Spacing +3 added lines, -3 removed lines

@@ -31,13 +31,13 @@
 	 */
 	protected function buildFieldList(array $fields, array $query = []): array {
 		foreach ($fields as $fieldName => $fieldValue) {
-			if($fieldValue instanceof DefaultValue) {
+			if ($fieldValue instanceof DefaultValue) {
 				$fieldValue = 'DEFAULT';
 			}
-			if(is_array($this->mask) && !in_array($fieldName, $this->mask, true)) {
+			if (is_array($this->mask) && !in_array($fieldName, $this->mask, true)) {
 				continue;
 			}
-			if(is_int($fieldName)) {
+			if (is_int($fieldName)) {
 				if (is_array($fieldValue)) {
 					$fieldValue = $this->db()->quoteExpression($fieldValue[0], array_slice($fieldValue, 1));
 				}

src/Builder/Delete.php

Spacing +3 added lines, -3 removed lines

@@ -29,10 +29,10 @@ 
 	 * @return $this
 	 */
 	public function from(string $alias, $table = null) {
-		if($table !== null) {
+		if ($table !== null) {
 			$this->aliases[] = $alias;
 		}
-		if($table === null) {
+		if ($table === null) {
 			[$alias, $table] = [$table, $alias];
 		}
 		$this->addTable($alias, $table);
@@ -51,7 +51,7 @@ 
 	public function __toString(): string {
 		$query = "DELETE ";
 		$query .= implode(', ', $this->aliases);
-		$query = trim($query) . " FROM\n";
+		$query = trim($query)." FROM\n";
 		$query = $this->buildTables($query);
 		$query = $this->buildJoins($query);
 		$query = $this->buildWhereConditions($query);