chillerlan / php-database

src/Query/Dialects/Postgres/CreateTable.php

Spacing +3 added lines, -3 removed lines

@@ -33,13 +33,13 @@ 
 
 		$n = explode('.', $this->name);
 
-		$sql .= $this->quote($n[count($n)-1]);
+		$sql .= $this->quote($n[count($n) - 1]);
 
 		if(!empty($this->cols)){
 			$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols);
 
 			if($this->primaryKey){
-				$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')';
+				$sql .= ','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')';
 			}
 
 			$sql .= PHP_EOL.')';
@@ -83,7 +83,7 @@ 
 
 		if((is_int($length) || is_string($length) && count(explode(',', $length)) === 2)
 		   && in_array($type, ['BIT', 'VARBIT', 'CHAR', 'VARCHAR', 'DECIMAL', 'NUMERIC', 'TIME', 'TIMESTAMP', 'INTERVAL'])){
-			$field[] = $type_translation.'('. $length . ')';
+			$field[] = $type_translation.'('.$length.')';
 		}
 		else{
 			$field[] = $type_translation;

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 .= !empty($this->from) ? 'FROM '.implode($glue , $this->from) : '';
+		$sql .= !empty($this->cols) ? 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) : '';

src/Query/Dialects/Firebird/CreateTable.php

Spacing +3 added lines, -3 removed lines

@@ -32,7 +32,7 @@ 
 
 		$n = explode('.', $this->name);
 
-		$sql .= $this->quote($n[count($n)-1]);
+		$sql .= $this->quote($n[count($n) - 1]);
 
 		$cols = [];
 
@@ -98,14 +98,14 @@ 
 			$field[] = $type_translation;
 		}
 		else if(in_array($type, ['CHAR', 'VARCHAR', 'DECIMAL', 'NUMERIC'])){
-			$field[] = $type.'('. $length . ')';
+			$field[] = $type.'('.$length.')';
 		}
 		else{
 			$field[] = $type;
 		}
 
 
-		if($isNull ===  false && !in_array($type, ['DATE', 'TIME', 'TIMESTAMP'])){
+		if($isNull === false && !in_array($type, ['DATE', 'TIME', 'TIMESTAMP'])){
 			$field[] = 'NOT NULL';
 		}
 

src/Query/Dialects/SQLite/Select.php

Spacing +2 added lines, -2 removed lines

@@ -37,8 +37,8 @@
 
 		$sql  = 'SELECT ';
 		$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/Dialects/SQLite/CreateTable.php

Spacing +4 added lines, -4 removed lines

@@ -44,13 +44,13 @@ 
 
 		$n = explode('.', $this->name);
 
-		$sql .= $this->quote($n[count($n)-1]);
+		$sql .= $this->quote($n[count($n) - 1]);
 
 		if(!empty($this->cols)){
 			$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols);
 
 			if($this->primaryKey){
-				$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey)
+				$sql .= ','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey)
 				       .(in_array($this->dir, ['ASC', 'DESC']) ? $this->dir : '').')';
 			}
 
@@ -86,9 +86,9 @@ 
 
 
 
-		if(is_int($length)&& in_array($type, ['CHAR', 'NCHAR','VARCHAR', 'NVARCHAR', 'CHARACTER'])
+		if(is_int($length) && in_array($type, ['CHAR', 'NCHAR', 'VARCHAR', 'NVARCHAR', 'CHARACTER'])
 		    || is_string($length) && count(explode(',', $length)) === 2 && $type === 'DECIMAL'){
-			$field[] = $type_translation.'('. $length . ')';
+			$field[] = $type_translation.'('.$length.')';
 		}
 		else{
 			$field[] = $type_translation;

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],
 			])
 		;
 
@@ -178,7 +178,7 @@ 
 		$select = $this->statement->select;
 		$select
 			->from([self::TEST_TABLENAME])
-			->where('id', [1,2,3], 'in')
+			->where('id', [1, 2, 3], 'in')
 			->orderby(['id' => 'desc'])
 		;
 		$result = $select->execute();