rkrx / php-mysql-query-builder

src/Databases/MySQL/MySQLSelect.php

Spacing +1 added lines, -1 removed lines

@@ -125,7 +125,7 @@
 	 * @return $this
 	 */
 	public function from(?string $alias, $table = null) {
-		if($table === null) {
+		if ($table === null) {
 			[$alias, $table] = [$table, $alias];
 			$this->addTable($alias, (string) $table);
 		} else {

src/Builder/Traits/OrderByBuilder.php

Spacing +7 added lines, -7 removed lines

@@ -15,8 +15,8 @@ 
 	 * @return $this
 	 */
 	public function orderBy($expression, string $direction = 'ASC') {
-		if($expression instanceof OrderBySpecification) {
-			foreach($expression->getFields() as $field) {
+		if ($expression instanceof OrderBySpecification) {
+			foreach ($expression->getFields() as $field) {
 				$this->addOrder($field[0], $field[1]);
 			}
 			return $this;
@@ -32,7 +32,7 @@ 
 	 */
 	public function orderByValues(string $fieldName, array $values) {
 		$expr = [];
-		foreach(array_values($values) as $idx => $value) {
+		foreach (array_values($values) as $idx => $value) {
 			$expr[] = $this->db()->quoteExpression("WHEN ? THEN ?", [$value, $idx]);
 		}
 		$this->orderBy[] = [sprintf("CASE %s\n\t\t%s\n\tEND", $this->db()->quoteField($fieldName), implode("\n\t\t", $expr)), 'ASC'];
@@ -44,12 +44,12 @@ 
 	 * @return string
 	 */
 	protected function buildOrder(string $query): string {
-		if(!count($this->orderBy)) {
+		if (!count($this->orderBy)) {
 			return $query;
 		}
 		$query .= "ORDER BY\n";
 		$arr = [];
-		foreach($this->orderBy as [$expression, $direction]) {
+		foreach ($this->orderBy as [$expression, $direction]) {
 			$arr[] = sprintf("\t%s %s", $expression, strtoupper($direction));
 		}
 		return $query.implode(",\n", $arr)."\n";
@@ -61,8 +61,8 @@ 
 	 */
 	private function addOrder($expression, string $direction): void {
 		$direction = $this->fixDirection($direction);
-		if(is_array($expression)) {
-			if(count($expression) < 1) {
+		if (is_array($expression)) {
+			if (count($expression) < 1) {
 				return;
 			}
 			$expr = (string) $expression[0];

src/Databases/MySQL/MySQLFieldQuoter.php

Spacing +2 added lines, -2 removed lines

@@ -9,10 +9,10 @@
 	 * @return string
 	 */
 	public static function quoteField(string $field): string {
-		if(is_numeric($field) || !is_string($field)) {
+		if (is_numeric($field) || !is_string($field)) {
 			throw new UnexpectedValueException('Field name is invalid');
 		}
-		if(strpos($field, '`') !== false) {
+		if (strpos($field, '`') !== false) {
 			return $field;
 		}
 		$parts = explode('.', $field);

src/Builder/Expr/DBExprOrderBySpec.php

Spacing +8 added lines, -8 removed lines

@@ -14,17 +14,17 @@ 
 	 */
 	public function __construct(array $spec, array $sortFieldsSpec) {
 		$expressions = [];
-		foreach($spec as $specReference => $dbExpr) {
-			if(is_int($specReference)) {
+		foreach ($spec as $specReference => $dbExpr) {
+			if (is_int($specReference)) {
 				$specReference = $dbExpr;
 			}
 			$expressions[$specReference] = $dbExpr;
 		}
-		foreach($sortFieldsSpec as $sortFieldSpec) {
-			if(array_key_exists(0, $sortFieldSpec)) {
-				if(array_key_exists($sortFieldSpec[0], $expressions)) {
+		foreach ($sortFieldsSpec as $sortFieldSpec) {
+			if (array_key_exists(0, $sortFieldSpec)) {
+				if (array_key_exists($sortFieldSpec[0], $expressions)) {
 					$direction = 'ASC';
-					if(array_key_exists(1, $sortFieldSpec) && strtoupper($sortFieldSpec[1]) !== 'ASC') {
+					if (array_key_exists(1, $sortFieldSpec) && strtoupper($sortFieldSpec[1]) !== 'ASC') {
 						$direction = 'DESC';
 					}
 					$this->fields[] = [
@@ -33,9 +33,9 @@ 
 					];
 				}
 			} else { // @phpstan-ignore-line
-				foreach($sortFieldSpec as $alias => $direction) {
+				foreach ($sortFieldSpec as $alias => $direction) {
 					$direction = strtoupper($direction) === 'DESC' ? 'DESC' : 'ASC';
-					if(array_key_exists($alias, $expressions)) {
+					if (array_key_exists($alias, $expressions)) {
 						$this->fields[] = [$expressions[$alias], $direction];
 					}
 				}

src/Builder/Expr/RequiredDBFilterMap.php

Spacing +1 added lines, -1 removed lines

@@ -36,7 +36,7 @@
 	 * @return DBExprFilter
 	 */
 	public function __invoke(string $expression, $keyPath, $validator = null) {
-		if(!RecursiveStructureAccess::recursiveHas($this->map, $keyPath)) {
+		if (!RecursiveStructureAccess::recursiveHas($this->map, $keyPath)) {
 			throw new RequiredValueNotFoundException(sprintf("Required value %s not found", json_encode($keyPath, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE)));
 		}
 		return new DBExprFilter($expression, $this->map, $keyPath, $validator);

src/Builder/Expr/DBOrderSpec.php

Spacing +3 added lines, -3 removed lines

@@ -41,13 +41,13 @@
 	public function getFields(): array {
 		$fields = [];
 		$max = $this->options['max_sort_instructions'] ?? 16;
-		foreach($this->sortingInstruction as $alias => $direction) {
+		foreach ($this->sortingInstruction as $alias => $direction) {
 			$direction = strtolower($direction) === 'desc' ? 'DESC' : 'ASC';
-			if(!array_key_exists($alias, $this->sortSpecification)) {
+			if (!array_key_exists($alias, $this->sortSpecification)) {
 				throw new DBSortAliasNotFoundException('Sorting: Alias for DB-Expression not found');
 			}
 			$fields[] = [$this->sortSpecification[$alias], $direction];
-			if($max < 1) {
+			if ($max < 1) {
 				throw new DBSortTooManyInstructionsException();
 			}
 			$max--;

src/Builder/Helpers/RecursiveStructureAccess.php

Spacing +10 added lines, -10 removed lines

@@ -28,9 +28,9 @@ 
 		if (!$count) {
 			return $default;
 		}
-		foreach($arrayPath as $idxValue) {
+		foreach ($arrayPath as $idxValue) {
 			$part = $idxValue;
-			if(!array_key_exists($part, $data)) {
+			if (!array_key_exists($part, $data)) {
 				return $default;
 			}
 			$data = $data[$part];
@@ -45,14 +45,14 @@ 
 	 */
 	private static function _recursiveHas($structure, array $path): bool {
 		$data = self::ensureArrayIsArray($structure);
-		if($data === null) {
+		if ($data === null) {
 			return false;
 		}
-		if(!count($path)) {
+		if (!count($path)) {
 			return false;
 		}
 		$key = array_shift($path);
-		if(count($path)) {
+		if (count($path)) {
 			return self::_recursiveHas($data[$key] ?? null, $path);
 		}
 		return array_key_exists($key, $data);
@@ -63,11 +63,11 @@ 
 	 * @return array<int, string>
 	 */
 	private static function getArrayPath($path): array {
-		if(is_array($path)) {
+		if (is_array($path)) {
 			return $path;
 		}
 		$parts = preg_split('{(?<!\\x5C)(?:\\x5C\\x5C)*\\.}', $path);
-		if($parts === false) {
+		if ($parts === false) {
 			return [$path];
 		}
 		return $parts;
@@ -78,13 +78,13 @@ 
 	 * @return array<mixed, mixed>
 	 */
 	private static function ensureArrayIsArray($array): ?array {
-		if($array instanceof ArrayObject) {
+		if ($array instanceof ArrayObject) {
 			return $array->getArrayCopy();
 		}
-		if(is_object($array)) {
+		if (is_object($array)) {
 			return (array) $array;
 		}
-		if(is_array($array)) {
+		if (is_array($array)) {
 			return $array;
 		}
 		return null;

src/Builder/Value/DBOptionalValue.php

Spacing +2 added lines, -2 removed lines

@@ -27,10 +27,10 @@
 	 * @return bool
 	 */
 	public function isValid(): bool {
-		if(!RecursiveStructureAccess::recursiveHas($this->data, $this->path)) {
+		if (!RecursiveStructureAccess::recursiveHas($this->data, $this->path)) {
 			return false;
 		}
-		if($this->validator !== null) {
+		if ($this->validator !== null) {
 			$value = $this->getValue();
 			return call_user_func($this->validator, $value);
 		}

src/Builder/Traits/OffsetBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -12,7 +12,7 @@ 
 	 * @return null|int
 	 */
 	protected function getOffset(): ?int {
-		if($this->offset instanceof OptionalValue) {
+		if ($this->offset instanceof OptionalValue) {
 			return $this->offset->getValue();
 		}
 		return $this->offset;
@@ -33,15 +33,15 @@ 
 	 */
 	protected function buildOffset(string $query): string {
 		$offset = $this->getOffset();
-		if($this->offset instanceof OptionalValue) {
-			if($this->offset->isValid()) {
+		if ($this->offset instanceof OptionalValue) {
+			if ($this->offset->isValid()) {
 				$value = $this->offset->getValue();
-				if(!preg_match('{\\d+}', $value)) {
+				if (!preg_match('{\\d+}', $value)) {
 					throw new InvalidValueException('Value for OFFSET has to be a number');
 				}
 				$query .= "OFFSET\n\t{$this->offset->getValue()}\n";
 			}
-		} elseif($offset !== null) {
+		} elseif ($offset !== null) {
 			$query .= "OFFSET\n\t{$this->offset}\n";
 		}
 		return $query;