chillerlan / php-database

src/Query/SelectAbstract.php

Doc Comments +1 added lines, -1 removed lines

@@ -49,7 +49,7 @@
 
 	/**
 	 * @param      $expr1
-	 * @param null $expr2
+	 * @param string|null $expr2
 	 * @param null $func
 	 *
 	 * @return void

Spacing +2 added lines, -2 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;

src/Query/Traits/WhereTrait.php

Doc Comments +3 added lines

@@ -21,6 +21,9 @@
 	 */
 	protected $where = [];
 
+	/**
+	 * @param string $operator
+	 */
 	protected function _addWhere($val1, $val2 = null, $operator = null, $bind = true, $join = 'AND'){
 		$operator = strtoupper(trim($operator));
 		$join = strtoupper(trim($join));

src/Query/UpdateInterface.php

Doc Comments +11 added lines

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

src/Query/InsertAbstract.php

Spacing +1 added lines, -1 removed lines

@@ -31,7 +31,7 @@
 
 		$sql = 'INSERT ';
 		$sql .= 'INTO '.$this->quote($this->table);
-		$sql .=  ' ('.$this->quotes[0].implode($this->quotes[1].', '.$this->quotes[0], $fields).$this->quotes[1].')';
+		$sql .= ' ('.$this->quotes[0].implode($this->quotes[1].', '.$this->quotes[0], $fields).$this->quotes[1].')';
 		$sql .= ' VALUES ('.implode(',', array_fill(0, count($fields), '?')).')';
 
 		return $sql;

src/Query/Dialects/MySQL/Select.php

Spacing +2 added lines, -2 removed lines

@@ -36,8 +36,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/Postgres/Select.php

Spacing +2 added lines, -2 removed lines

@@ -36,8 +36,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/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';
 		}