chillerlan / php-database

src/Dialects/MySQL.php

Indentation +1 added lines, -1 removed lines

@@ -119,7 +119,7 @@
 
 		// @todo: whitelist types?
 		$nolengthtypes = ['DATE', 'TINYBLOB', 'TINYTEXT', 'BLOB', 'TEXT', 'MEDIUMBLOB',
-		                  'MEDIUMTEXT', 'LONGBLOB', 'LONGTEXT', 'SERIAL', 'BOOLEAN', 'UUID'];
+						  'MEDIUMTEXT', 'LONGBLOB', 'LONGTEXT', 'SERIAL', 'BOOLEAN', 'UUID'];
 
 		$field[] = (is_int($length) || (is_string($length) && count(explode(',', $length)) === 2)) && !in_array($type, $nolengthtypes, true)
 			? $type.'('. $length . ')'

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/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/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/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);
 			}
 

Braces +1 added lines, -1 removed lines

@@ -345,7 +345,7 @@
 
 		for( ; $this->offset < $pos; ){
 
-			if(!\next($this->array)) {
+			if(!\next($this->array)){
 				throw new \OutOfBoundsException('invalid seek position: '.$pos);
 			}