chillerlan / php-database

src/Query/SelectAbstract.php

Spacing +1 added lines, -1 removed lines

@@ -90,7 +90,7 @@
 		$from = $table;
 
 		if($ref){
-			$from = sprintf('%s AS %s', $table, $ref);// @todo: index hint
+			$from = sprintf('%s AS %s', $table, $ref); // @todo: index hint
 		}
 
 		$this->from[$ref ?? $table] = $from;

src/Query/Traits/WhereTrait.php

Spacing +1 added lines, -1 removed lines

@@ -141,7 +141,7 @@
 		$where = [];
 
 		foreach($this->where as $k => $v){
-			$last = $this->where[$k-1] ?? false;
+			$last = $this->where[$k - 1] ?? false;
 #			print_r([$last, $v]);
 
 			if(in_array($v, ['AND', 'OR', 'XOR', '(', ')'], true)){

src/Query/Dialects/MySQL/Select.php

Spacing +2 added lines, -2 removed lines

@@ -29,8 +29,8 @@
 
 		$sql  = 'SELECT ';
 		$sql .= $this->distinct ? 'DISTINCT ' : '';
-		$sql .= implode($glue , $this->cols).PHP_EOL;
-		$sql .= !empty($this->from) ? 'FROM '.implode($glue , $this->from) : '';
+		$sql .= implode($glue, $this->cols).PHP_EOL;
+		$sql .= !empty($this->from) ? 'FROM '.implode($glue, $this->from) : '';
 		$sql .= $this->_getWhere();
 		$sql .= !empty($this->groupby) ? PHP_EOL.'GROUP BY '.implode($glue, $this->groupby) : '';
 		$sql .= !empty($this->orderby) ? PHP_EOL.'ORDER BY '.implode($glue, $this->orderby) : '';

tests/Query/QueryTest.php

Spacing +1 added lines, -1 removed lines

@@ -54,7 +54,7 @@
 			->where('t2.what', 3)
 			->openBracket('and')
 			->where('t1.what', 't2.what', '>', false)
-			->where('t2.what', [1,2,3], 'in')
+			->where('t2.what', [1, 2, 3], 'in')
 			->closeBracket()
 			->where('t3.what', $this->statement->select->cols(['foo'])->from(['nope'])->where('bar', 42), 'in', true, 'or')
 			->groupby(['foo', 'bar'])