kristuff / patabase

lib/Driver/Postgres/PostgresDriver.php

Indentation +11 added lines, -12 removed lines

@@ -122,9 +122,9 @@ 
      */
     public function lastInsertedId(): string
     {
-       // Postgres does not set pdo->lastInsertedId
-       // use sequence
-       try {
+        // Postgres does not set pdo->lastInsertedId
+        // use sequence
+        try {
             $rq = $this->pdo->prepare('SELECT LASTVAL()');
             $rq->execute();
             // return string 
@@ -158,7 +158,6 @@ 
     /**
      * Get whether foreign keys are enabled or not
      * For compatibility with Sqlite, not implemented in that driver (allways enabled), return true 
-
      * @access public
      * @return bool     true if foreign keys are enabled, otherwise false
      */
@@ -182,11 +181,11 @@ 
     public function addForeignKey(string $fkName, string $srcTable, string $srcColumn, string $refTable, string $refColumn): bool
     {
         $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);
     }
@@ -203,9 +202,9 @@ 
     public function dropForeignKey(string $fkName, string $tableName, bool $ifExists = false): bool
     {
         $sql = sprintf('ALTER TABLE %s DROP CONSTRAINT %s %s',
-                       $this->escape($tableName),
-                       $ifExists ? 'IF EXISTS' : '',
-                       $fkName
+                        $this->escape($tableName),
+                        $ifExists ? 'IF EXISTS' : '',
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }

lib/Driver/Mysql/MysqlDriver.php

Indentation +10 added lines, -10 removed lines

@@ -86,7 +86,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(
@@ -162,11 +162,11 @@ 
     public function addForeignKey(string $fkName, string $srcTable, string $srcColumn, string $refTable, string $refColumn): bool
     {
         $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);
     }
@@ -183,8 +183,8 @@ 
     public function dropForeignKey(string $fkName, string $tableName): bool
     {
         $sql = sprintf('ALTER TABLE %s DROP FOREIGN KEY %s',
-                       $this->escape($tableName),
-                       $fkName
+                        $this->escape($tableName),
+                        $fkName
         );
         return $this->prepareAndExecuteSql($sql);
     }
@@ -239,7 +239,7 @@ 
                     "'" . $userPassword ."'"
         ));
         return $this->prepareAndExecuteSql($sql);
-   }
+    }
 
     /**
      * Drop a user
@@ -269,7 +269,7 @@ 
      *
      * @return bool     True if the user has been granted, otherwise false. 
      */
-     public function grantUser(string $databaseName, string $userName): bool
+        public function grantUser(string $databaseName, string $userName): bool
     {
         $sql = trim(sprintf('GRANT ALL ON %s.* TO %s@%s; FLUSH PRIVILEGES;', 
             $this->escape($databaseName),