chillerlan / php-database

tests/DBInstanceTest.php

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

@@ -9,15 +9,14 @@
 
 namespace chillerlan\DatabaseTest;
 
+use Dotenv\Dotenv;
 use chillerlan\Database\DBOptions;
 use chillerlan\Database\Drivers\MySQLi\MySQLiDriver;
-use chillerlan\Database\Drivers\PDO\PDOFirebirdDriver;
 use chillerlan\Database\Drivers\PDO\PDOMySQLDriver;
 use chillerlan\Database\Drivers\PDO\PDOPostgresDriver;
 use chillerlan\Database\Drivers\PDO\PDOSQLiteDriver;
 use chillerlan\Database\Drivers\PostgreSQL\PostgreSQLDriver;
 use chillerlan\Database\Drivers\SQLite\SQLite3Driver;
-use Dotenv\Dotenv;
 
 class DBInstanceTest extends \PHPUnit_Framework_TestCase{
 

Spacing +5 added lines, -5 removed lines

@@ -39,15 +39,15 @@
 	public function driverDataProvider(){
 		return [
 			// native
-			['MYSQLI',       MySQLiDriver::class,       'mysqli'],
-			['POSTGRESQL',   PostgreSQLDriver::class, 'resource'],
-			['SQLITE3',      SQLite3Driver::class,     'SQLite3'],
+			['MYSQLI', MySQLiDriver::class, 'mysqli'],
+			['POSTGRESQL', PostgreSQLDriver::class, 'resource'],
+			['SQLITE3', SQLite3Driver::class, 'SQLite3'],
 
 			// PDO (obviously)
-			['PDO_MYSQL',    PDOMySQLDriver::class,    'PDO'],
+			['PDO_MYSQL', PDOMySQLDriver::class, 'PDO'],
 			['PDO_POSTGRES', PDOPostgresDriver::class, 'PDO'],
 #			['PDO_FIREBIRD', PDOFirebirdDriver::class, 'PDO'], // https://github.com/asfernandes/firebird/blob/master/.travis.yml
-			['PDO_SQLITE',   PDOSQLiteDriver::class,   'PDO'],
+			['PDO_SQLITE', PDOSQLiteDriver::class, 'PDO'],
 		];
 	}
 

src/DBOptions.php

Spacing +1 added lines, -1 removed lines

@@ -129,7 +129,7 @@
 	 * 
 	 * @var int
 	 */
-	public $sqlite_flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE;
+	public $sqlite_flags = SQLITE3_OPEN_READWRITE|SQLITE3_OPEN_CREATE;
 	/**
 	 * An optional encryption key used when encrypting and decrypting an SQLite database.
 	 *

src/Drivers/MySQLi/MySQLiDriver.php

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

@@ -12,6 +12,7 @@ 
 
 namespace chillerlan\Database\Drivers\MySQLi;
 
+use ReflectionMethod;
 use chillerlan\Database\DBException;
 use chillerlan\Database\Drivers\DBBaseDriver;
 use chillerlan\Database\Drivers\DBDriverInterface;
@@ -19,8 +20,6 @@ 
 use mysqli_result;
 use mysqli_sql_exception;
 use mysqli_stmt;
-use ReflectionClass;
-use ReflectionMethod;
 use stdClass;
 
 /**

Spacing +4 added lines, -4 removed lines

@@ -186,7 +186,7 @@ 
 
 			$out = [];
 			$method = 'fetch_'.($assoc ? ($fetch_array ? 'assoc' : 'object') : 'row');
-			$i = 0 ;
+			$i = 0;
 
 			// ok, we have a result with one or more rows, loop out the rows and output as array
 			while($row = $result->{$method}()){
@@ -352,7 +352,7 @@ 
 	 *
 	 * @return void
 	 */
-	protected function insertPreparedRow(mysqli_stmt &$stmt, ReflectionMethod &$reflectionMethod, array &$row){
+	protected function insertPreparedRow(mysqli_stmt&$stmt, ReflectionMethod&$reflectionMethod, array &$row){
 		$references = $this->getReferences($row);
 		array_unshift($references, $this->getTypes($references));
 		$reflectionMethod->invokeArgs($stmt, $references);
@@ -370,7 +370,7 @@ 
 	 *
 	 * @return array|bool
 	 */
-	protected function getResult(mysqli_stmt &$stmt, mysqli_result &$result, string $index = null, bool $assoc, bool $fetch_array){
+	protected function getResult(mysqli_stmt&$stmt, mysqli_result&$result, string $index = null, bool $assoc, bool $fetch_array){
 		// get the columns and their references
 		// http://php.net/manual/mysqli-stmt.bind-result.php
 		$cols = $refs = [];
@@ -426,7 +426,7 @@ 
 		foreach($values as &$v){
 			switch(gettype($v)){
 				case 'integer': $types[] = 'i'; break;
-				case 'double': $types[] ='d'; break;
+				case 'double': $types[] = 'd'; break;
 				default: $types[] = 's'; break;
 			}
 		}

src/Drivers/SQLite/SQLite3Driver.php

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

@@ -12,10 +12,10 @@
 
 namespace chillerlan\Database\Drivers\SQLite;
 
-use chillerlan\Database\DBException;
-use chillerlan\Database\Drivers\DBDriverAbstract;
 use Exception;
 use SQLite3;
+use chillerlan\Database\DBException;
+use chillerlan\Database\Drivers\DBDriverAbstract;
 
 /**
  *

src/Drivers/PDO/PDODriver.php

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

@@ -12,10 +12,10 @@
 
 namespace chillerlan\Database\Drivers\SQLite;
 
-use chillerlan\Database\DBException;
-use chillerlan\Database\Drivers\DBDriverAbstract;
 use Exception;
 use SQLite3;
+use chillerlan\Database\DBException;
+use chillerlan\Database\Drivers\DBDriverAbstract;
 
 /**
  *

Spacing +5 added lines, -5 removed lines

@@ -191,10 +191,10 @@ 
 	 * @return array
 	 * @internal
 	 */
-	protected function getResult(PDOStatement &$stmt, string $index = null, bool $assoc, bool $fetch_array):array {
+	protected function getResult(PDOStatement&$stmt, string $index = null, bool $assoc, bool $fetch_array):array {
 		$out = [];
 		$method = $assoc ? ($fetch_array ? PDO::FETCH_ASSOC : PDO::FETCH_OBJ) : PDO::FETCH_NUM;
-		$i = 0 ;
+		$i = 0;
 
 		// ok, we have a result with one or more rows, loop out the rows and output as array
 		while($row = $stmt->fetch($method)){
@@ -225,16 +225,16 @@ 
 	 * @return void
 	 * @internal
 	 */
-	protected function bindParams(PDOStatement &$stmt, array $values){
+	protected function bindParams(PDOStatement&$stmt, array $values){
 		$param_no = 1;
 
 		foreach($values as $v){
 
 			switch(gettype($v)){
 				case 'boolean': $type = PDO::PARAM_BOOL; break;
-				case 'integer': $type = PDO::PARAM_INT;  break;
+				case 'integer': $type = PDO::PARAM_INT; break;
 				case 'NULL':    $type = PDO::PARAM_NULL; break;
-				default:        $type = PDO::PARAM_STR;  break;
+				default:        $type = PDO::PARAM_STR; break;
 			}
 
 			$stmt->bindValue($param_no, $v, $type);

src/Drivers/PDO/PDOFirebirdDriver.php

Doc Comments +1 added lines, -1 removed lines

@@ -52,7 +52,7 @@
 	 * Firebird -> SQLSTATE[IM001]: driver does not support lastInsertId()
 	 *
 	 * @link http://php.net/manual/pdo.lastinsertid.php
-	 * @return null
+	 * @return string
 	 */
 	protected function insertID():string {
 		return null;

src/Drivers/DBDriverInterface.php

Spacing +1 added lines, -1 removed lines

@@ -58,7 +58,7 @@
 	 *
 	 * @return array stats
 	 */
-	public function getStats():array ;
+	public function getStats():array;
 
 	/**
 	 * Enables query stat recording

src/Drivers/PostgreSQL/PostgreSQLDriver.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
 	 * @return resource the database resource object
 	 * @throws \chillerlan\Database\DBException
 	 */
-	public function connect() {
+	public function connect(){
 
 		if(gettype($this->db) === 'resource'){
 			return $this->db;

Braces +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
 	 * @return resource the database resource object
 	 * @throws \chillerlan\Database\DBException
 	 */
-	public function connect() {
+	public function connect(){
 
 		if(gettype($this->db) === 'resource'){
 			return $this->db;