chillerlan / php-database

src/Dialects/Firebird.php

Spacing +1 added lines, -1 removed lines

@@ -187,7 +187,7 @@
 
 	/** @inheritdoc */
 	public function truncate(string $table):array{
-		$sql = ['DELETE FROM'];// RECREATE TABLE [table spec] ...stupid firebird 2.5
+		$sql = ['DELETE FROM']; // RECREATE TABLE [table spec] ...stupid firebird 2.5
 		$sql[] = $this->quote($table);
 
 		return $sql;

src/Dialects/SQLite.php

Spacing +1 added lines, -1 removed lines

@@ -108,7 +108,7 @@
 
 	/** @inheritdoc */
 	public function truncate(string $table):array{
-		$sql = ['DELETE FROM'];// ??? sqlite
+		$sql = ['DELETE FROM']; // ??? sqlite
 		$sql[] = $this->quote($table);
 
 		return $sql;

src/Dialects/Postgres.php

Spacing +1 added lines, -1 removed lines

@@ -69,7 +69,7 @@
 				throw new QueryException('postgres insert on conflict: no conflict target given');
 			}
 
-			$sql[] =  'ON CONFLICT ('.$this->quote($conflictTarget).') DO';
+			$sql[] = 'ON CONFLICT ('.$this->quote($conflictTarget).') DO';
 
 			switch($onConflict){
 				case 'IGNORE':

src/DatabaseAbstract.php

Spacing +1 added lines, -1 removed lines

@@ -65,7 +65,7 @@
 			throw new DatabaseException('invalid driver interface');
 		}
 
-		$this->query   = new QueryBuilder($this->driver, $this->logger);
+		$this->query = new QueryBuilder($this->driver, $this->logger);
 	}
 
 	/**

src/Query/WhereTrait.php

Spacing +4 added lines, -4 removed lines

@@ -62,7 +62,7 @@ 
 					: $this->dialect->quote($val1)
 			];
 
-			if(in_array($operator, ['IN', 'NOT IN', 'ANY', 'SOME',], true)){
+			if(in_array($operator, ['IN', 'NOT IN', 'ANY', 'SOME', ], true)){
 
 				if(is_array($val2)){
 
@@ -100,7 +100,7 @@ 
 				elseif(in_array(strtolower($val2), ['null', 'false', 'true', 'unknown'], true)){
 					$where[] = strtoupper($val2);
 				}
-				else {
+				else{
 
 					if($bind){
 						$where[] = '?';
@@ -159,9 +159,9 @@ 
 		$where = [];
 
 		foreach($this->where as $k => $v){
-			$last = $this->where[$k-1] ?? false;
+			$last = $this->where[$k - 1] ?? false;
 
-			if(in_array($v,  $this->joinArgs + ['(', ')'], true)){
+			if(in_array($v, $this->joinArgs + ['(', ')'], true)){
 				$where[] = $v;
 
 				continue;

src/Dialects/MySQL.php

Spacing +5 added lines, -5 removed lines

@@ -77,13 +77,13 @@ 
 			$sql[] = 'TEMPORARY';
 		}
 
-		$sql[] = 'TABLE' ;
+		$sql[] = 'TABLE';
 
 		if($ifNotExists){
-			$sql[] =  'IF NOT EXISTS' ;
+			$sql[] = 'IF NOT EXISTS';
 		}
 
-		$sql[] =  $this->quote($table);
+		$sql[] = $this->quote($table);
 
 		if(!empty($cols)){
 			$sql[] = '(';
@@ -92,7 +92,7 @@ 
 			if(!empty($primaryKey)){
 				$sql[] = ', PRIMARY KEY (';
 				$sql[] = $this->quote($primaryKey);
-				$sql[] =  ')';
+				$sql[] = ')';
 			}
 
 			$sql[] = ')';
@@ -127,7 +127,7 @@ 
 		                  'MEDIUMTEXT', 'LONGBLOB', 'LONGTEXT', 'SERIAL', 'BOOLEAN', 'UUID'];
 
 		$field[] = (is_int($length) || (is_string($length) && count(explode(',', $length)) === 2)) && !in_array($type, $nolengthtypes, true)
-			? $type.'('. $length . ')'
+			? $type.'('.$length.')'
 			: $type;
 
 		if($attribute){

src/Query/MultiQueryTrait.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
 
 	/** @inheritdoc */
 	public function callback(iterable $values, callable $callback):bool{
-		$sql    = $this->sql(true);
+		$sql = $this->sql(true);
 
 		$this->logger->debug('MultiQueryTrait::callback()', ['method' => __METHOD__, 'sql' => $sql, 'val' => $values]);
 

src/Dialects/DialectAbstract.php

Spacing +3 added lines, -3 removed lines

@@ -192,7 +192,7 @@ 
 
 		// @todo: fixme, cleanup
 		// errors on [alias => col, alias, alias => col...]
-		$_col = function ($expr1, $expr2 = null, $func = null):string {
+		$_col = function($expr1, $expr2 = null, $func = null):string {
 			switch(true){
 				case  $expr2 && $func:
 					$col = sprintf('%s(%s) AS %s', strtoupper($func), $expr1, $this->quote($expr2));
@@ -234,12 +234,12 @@ 
 	/** @inheritdoc */
 	public function from(array $expressions):array {
 
-		$_from = function (string $table, string $ref = null):string {
+		$_from = function(string $table, string $ref = null):string {
 			// @todo: quotes
 			$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
 			}
 
 			return $from;

src/Result.php

Spacing +2 added lines, -2 removed lines

@@ -343,9 +343,9 @@
 	public function seek($pos):void{
 		$this->rewind();
 
-		for( ; $this->offset < $pos; ){
+		for(; $this->offset < $pos;){
 
-			if(!\next($this->array)) {
+			if(!\next($this->array)){
 				throw new \OutOfBoundsException('invalid seek position: '.$pos);
 			}