chillerlan / php-database

src/Dialects/MySQL.php

Spacing +6 added lines, -6 removed lines

@@ -72,13 +72,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[] = '(';
@@ -87,7 +87,7 @@ 
 			if(!empty($primaryKey)){
 				$sql[] = ', PRIMARY KEY (';
 				$sql[] = $this->quote($primaryKey);
-				$sql[] =  ')';
+				$sql[] = ')';
 			}
 
 			$sql[] = ')';
@@ -122,7 +122,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){
@@ -164,7 +164,7 @@ 
 					$field[] = 'DEFAULT NULL';
 					break;
 				default:
-					$field[] = 'DEFAULT '.(is_int($defaultValue) || is_float($defaultValue) ? $defaultValue : '\''.$defaultValue.'\'') ;
+					$field[] = 'DEFAULT '.(is_int($defaultValue) || is_float($defaultValue) ? $defaultValue : '\''.$defaultValue.'\'');
 			}
 
 		}

src/Dialects/MSSQL.php

Spacing +1 added lines, -1 removed lines

@@ -56,7 +56,7 @@
 
 	/** @inheritdoc */
 	public function createDatabase(string $dbname, bool $ifNotExists = null, string $collate = null):array{
-		$sql = [ 'CREATE DATABASE'];
+		$sql = ['CREATE DATABASE'];
 		$sql[] = $this->quote($dbname);
 
 		if($collate){

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/Query/MultiQueryTrait.php

Spacing +1 added lines, -1 removed lines

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

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;