chillerlan / php-database

src/Drivers/MSSqlSrvPDO.php

Spacing +3 added lines, -3 removed lines

@@ -40,7 +40,7 @@ 
 		// @todo
 		$this->pdo_options[PDO::SQLSRV_ATTR_QUERY_TIMEOUT] = $options->mssql_timeout; // doesn't seem to have an effect
 		$this->pdo_options[PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE] = true;
-		$this->pdo_options[PDO::SQLSRV_ATTR_ENCODING ] = PDO::SQLSRV_ENCODING_UTF8;
+		$this->pdo_options[PDO::SQLSRV_ATTR_ENCODING] = PDO::SQLSRV_ENCODING_UTF8;
 
 		parent::__construct($options, $cache);
 	}
@@ -52,7 +52,7 @@ 
 		$dsn .= ':Server='.$this->options->host;
 
 		if(is_numeric($this->options->port)){
-			$dsn .=  ','.$this->options->port;
+			$dsn .= ','.$this->options->port;
 		}
 
 		$dsn .= ';Database='.$this->options->database;
@@ -72,7 +72,7 @@ 
 	}
 
 	/** @inheritdoc */
-	public function getServerInfo():?string{
+	public function getServerInfo(): ?string{
 		$info = $this->db->getAttribute(PDO::ATTR_SERVER_INFO);
 
 		if(is_array($info) && !empty($info)){

Unused Use Statements +1 added lines, -1 removed lines

@@ -12,9 +12,9 @@
 
 namespace chillerlan\Database\Drivers;
 
+use PDO;
 use chillerlan\Database\Dialects\MSSQL;
 use chillerlan\Traits\ContainerInterface;
-use PDO;
 use Psr\{
 	Log\LoggerInterface, SimpleCache\CacheInterface
 };

src/Drivers/DriverInterface.php

Spacing +1 added lines, -1 removed lines

@@ -69,7 +69,7 @@
 	 *
 	 * @return string serverinfo string
 	 */
-	public function getServerInfo():?string;
+	public function getServerInfo(): ?string;
 
 	/**
 	 * Sanitizer.

Doc Comments +1 added lines

@@ -28,6 +28,7 @@
 	 * @param \chillerlan\Traits\ContainerInterface $options
 	 * @param \Psr\SimpleCache\CacheInterface|null  $cache
 	 * @param \Psr\Log\LoggerInterface|null         $logger
+	 * @return void
 	 */
 	public function __construct(ContainerInterface $options, CacheInterface $cache = null, LoggerInterface $logger = null);
 

src/Drivers/FirebirdPDO.php

Spacing +1 added lines, -1 removed lines

@@ -83,7 +83,7 @@
 	}
 
 	/** @inheritdoc */
-	public function getServerInfo():?string{
+	public function getServerInfo(): ?string{
 		return $this->db->getAttribute(PDO::ATTR_SERVER_INFO).', connected to: '.$this->options->database;
 	}
 

src/Drivers/SQLitePDO.php

Spacing +1 added lines, -1 removed lines

@@ -34,7 +34,7 @@
 	}
 
 	/** @inheritdoc */
-	public function getServerInfo():?string {
+	public function getServerInfo(): ?string {
 		return $this->drivername.', connected to: '.$this->options->database.' (PDO::ATTR_SERVER_INFO not available)';
 	}
 

src/Dialects/DialectAbstract.php

Spacing +3 added lines, -3 removed lines

@@ -205,7 +205,7 @@ 
 	/** @inheritdoc */
 	public function cols(array $expressions):array {
 
-		$_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));
@@ -247,12 +247,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/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 +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;