chillerlan / php-database

src/Query/UpdateInterface.php

Doc Comments +7 added lines

@@ -14,7 +14,14 @@
 
 interface UpdateInterface extends StatementInterface{
 
+	/**
+	 * @return void
+	 */
 	public function table();
+
+	/**
+	 * @return void
+	 */
 	public function set();
 	public function where($val1, $val2, $operator = '=', $bind = true, $join = 'AND'):UpdateInterface;
 	public function openBracket($join = null):UpdateInterface;

tests/Query/QueryTestAbstract.php

Spacing +3 added lines, -3 removed lines

@@ -125,9 +125,9 @@ 
 		$insert
 			->into(self::TEST_TABLENAME)
 			->values([
-				['id' => 1, 'hash' => md5(1), 'data' => 'foo', 'value' => 123.456,    'active' => 0],
+				['id' => 1, 'hash' => md5(1), 'data' => 'foo', 'value' => 123.456, 'active' => 0],
 				['id' => 2, 'hash' => md5(2), 'data' => 'foo', 'value' => 123.456789, 'active' => 1],
-				['id' => 3, 'hash' => md5(3), 'data' => 'foo', 'value' => 123.456,    'active' => 0],
+				['id' => 3, 'hash' => md5(3), 'data' => 'foo', 'value' => 123.456, 'active' => 0],
 			])
 		;
 
@@ -175,7 +175,7 @@ 
 		$select = $this->statement->select;
 		$select
 			->from([self::TEST_TABLENAME])
-			->where('id', [1,2,3], 'in')
+			->where('id', [1, 2, 3], 'in')
 			->orderby(['hash' => ['desc', 'lower']]);
 #		print_r(PHP_EOL.$select->sql().PHP_EOL);
 		$result = $select->execute();

src/Query/Dialects/Firebird/Select.php

Spacing +2 added lines, -2 removed lines

@@ -43,8 +43,8 @@
 		$sql  = 'SELECT ';
 		$sql .= $this->limit ? 'FIRST ? SKIP ? ' : '';
 		$sql .= $this->distinct ? 'DISTINCT ' : '';
-		$sql .= !empty($this->cols) ? implode($glue , $this->cols).PHP_EOL : '* ';
-		$sql .= 'FROM '.implode($glue , $this->from);
+		$sql .= !empty($this->cols) ? implode($glue, $this->cols).PHP_EOL : '* ';
+		$sql .= '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) : '';

src/Query/SelectAbstract.php

Spacing +4 added lines, -4 removed lines

@@ -83,7 +83,7 @@ 
 			if(is_string($k)){
 				is_array($ref)
 					? $this->addColumn($ref[0], $k, $ref[1] ?? null)
-					: $this->addColumn($ref ,$k);
+					: $this->addColumn($ref, $k);
 			}
 			else{
 				is_array($ref)
@@ -105,7 +105,7 @@ 
 		$from = $this->quote($table);
 
 		if($ref){
-			$from = sprintf('%s AS %s', $this->quote($ref), $this->quote($table));// @todo: index hint
+			$from = sprintf('%s AS %s', $this->quote($ref), $this->quote($table)); // @todo: index hint
 		}
 
 		$this->from[$ref ?? $table] = $from;
@@ -176,7 +176,7 @@ 
 					$dir = strtoupper($expression[0]);
 
 					if(in_array($dir, ['ASC', 'DESC'])){
-						$this->orderby[] =  isset($expression[1]) ? strtoupper($expression[1]).'('.$this->quote($alias).') '.$dir : $dir;
+						$this->orderby[] = isset($expression[1]) ? strtoupper($expression[1]).'('.$this->quote($alias).') '.$dir : $dir;
 					}
 
 				}
@@ -184,7 +184,7 @@ 
 					$dir = strtoupper($expression);
 
 					if(in_array($dir, ['ASC', 'DESC'])){
-						$this->orderby[] =  $this->quote($alias).' '.$dir;
+						$this->orderby[] = $this->quote($alias).' '.$dir;
 					}
 
 				}