kristuff / patabase

lib/Driver/Mysql/MysqlDriver.php

Indentation +10 added lines, -10 removed lines

@@ -89,7 +89,7 @@ 
         $port    = !empty($settings['port'])     ?  ';port='.$settings['port']        : '';
         $dbname  = !empty($settings['database']) ?  ';dbname='.$settings['database']  : '';
         $options = [
-          //  \PDO::ATTR_EMULATE_PREPARES => false,
+            //  \PDO::ATTR_EMULATE_PREPARES => false,
         ];
 
         $this->pdo = new \PDO(
@@ -153,11 +153,11 @@ 
     public function addForeignKey($fkName, $srcTable, $srcColumn, $refTable, $refColumn)
     {
         $sql = sprintf('ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s)',
-                       $this->escape($srcTable),
-                       $fkName,
-                       $this->escape($srcColumn),
-                       $this->escape($refTable),
-                       $this->escape($refColumn)
+                        $this->escape($srcTable),
+                        $fkName,
+                        $this->escape($srcColumn),
+                        $this->escape($refTable),
+                        $this->escape($refColumn)
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -174,8 +174,8 @@ 
     public function dropForeignKey($fkName, $tableName)
     {
         $sql = sprintf('ALTER TABLE %s DROP FOREIGN KEY %s',
-                       $this->escape($tableName),
-                       $fkName
+                        $this->escape($tableName),
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -230,7 +230,7 @@ 
                     "'" . $userPassword ."'"
         ));
         return $this->prepareAndExecuteSql($sql);
-   }
+    }
 
     /**
      * Drop a user
@@ -260,7 +260,7 @@ 
      *
      * @return bool     True if the user has been granted, otherwise false. 
      */
-     public function grantUser($databaseName, $userName)
+        public function grantUser($databaseName, $userName)
     {
         $sql = trim(sprintf('GRANT ALL ON %s.* TO %s@%s; FLUSH PRIVILEGES;', 
             $this->escape($databaseName),

Spacing +11 added lines, -11 removed lines

@@ -59,7 +59,7 @@ 
      */
     public function escapeIdentifier($identifier)
     {
-        return '`' . $identifier .'`';
+        return '`'.$identifier.'`';
     }
 
     /**
@@ -85,15 +85,15 @@ 
      */
     public function createConnection(array $settings)
     {
-        $charset = !empty($settings['charset'])  ?  ';charset='.$settings['charset']  : ';charset=utf8';
-        $port    = !empty($settings['port'])     ?  ';port='.$settings['port']        : '';
-        $dbname  = !empty($settings['database']) ?  ';dbname='.$settings['database']  : '';
+        $charset = !empty($settings['charset']) ? ';charset='.$settings['charset'] : ';charset=utf8';
+        $port    = !empty($settings['port']) ? ';port='.$settings['port'] : '';
+        $dbname  = !empty($settings['database']) ? ';dbname='.$settings['database'] : '';
         $options = [
           //  \PDO::ATTR_EMULATE_PREPARES => false,
         ];
 
         $this->pdo = new \PDO(
-            'mysql:host='.$settings['hostname'] .$port .$dbname .$charset,
+            'mysql:host='.$settings['hostname'].$port.$dbname.$charset,
             $settings['username'],
             $settings['password'],
             $options
@@ -192,7 +192,7 @@ 
     {
         $sql = 'SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = :dbName'; 
         $query = $this->pdo->prepare($sql);
-        $query->bindValue(':dbName',  $databaseName, \PDO::PARAM_STR);
+        $query->bindValue(':dbName', $databaseName, \PDO::PARAM_STR);
         $query->execute();
         return (bool) $query->fetchColumn();
     }
@@ -209,7 +209,7 @@ 
      */
     public function createDatabase($databaseName, $owner)
     {
-        $sql = trim(sprintf('CREATE DATABASE %s',  $this->escape($databaseName)));
+        $sql = trim(sprintf('CREATE DATABASE %s', $this->escape($databaseName)));
         return $this->prepareAndExecuteSql($sql);
     }
     
@@ -227,7 +227,7 @@ 
         $sql = trim(sprintf('CREATE USER %s@%s IDENTIFIED BY %s', 
                     $this->escape($userName),
                     $this->escape($this->getHostName()),
-                    "'" . $userPassword ."'"
+                    "'".$userPassword."'"
         ));
         return $this->prepareAndExecuteSql($sql);
    }
@@ -244,7 +244,7 @@ 
     public function dropUser($userName, $ifExists = false)
     {
         $sql = trim(sprintf('DROP USER %s %s@%s', 
-                    $ifExists === true ? 'IF EXISTS': '',
+                    $ifExists === true ? 'IF EXISTS' : '',
                     $this->escape($userName),
                     $this->escape($this->getHostName())
         ));
@@ -311,7 +311,7 @@ 
      */
     public function sqlCreateTableOptions() 
     {
-        $engine =  !empty($settings['engine'])  ? $settings['engine']  : 'InnoDB';
+        $engine = !empty($settings['engine']) ? $settings['engine'] : 'InnoDB';
         $charset = !empty($settings['charset']) ? $settings['charset'] : 'utf8';
         $collate = !empty($settings['collate']) ? $settings['collate'] : 'utf8_unicode_ci';
         return sprintf('ENGINE=%s DEFAULT CHARSET=%s COLLATE=%s;', $engine, $charset, $collate);
@@ -340,7 +340,7 @@ 
      */
     public function sqlColumnAutoIncrement($type)
     {
-        return $type .' AUTO_INCREMENT';
+        return $type.' AUTO_INCREMENT';
     }
     
 }