lagdo / dbadmin-driver-mysql

src/Driver.php

Spacing +1 added lines, -1 removed lines

@@ -71,7 +71,7 @@
         "char" => "md5/sha1/password/encrypt/uuid",
         "binary" => "md5/sha1",
         "date|time" => "now",
-    ],[
+    ], [
         // $this->numberRegex() => "+/-",
         "date" => "+ interval/- interval",
         "time" => "addtime/subtime",

Braces +2 added lines, -4 removed lines

@@ -94,11 +94,9 @@
     {
         if (extension_loaded("mysqli")) {
             $connection = new Db\MySqli\Connection($this, $this->util, $this->trans, 'MySQLi');
-        }
-        elseif (extension_loaded("pdo_mysql")) {
+        } elseif (extension_loaded("pdo_mysql")) {
             $connection = new Db\Pdo\Connection($this, $this->util, $this->trans, 'PDO_MySQL');
-        }
-        else {
+        } else {
             throw new AuthException($this->trans->lang('No package installed to connect to a MySQL server.'));
         }
 

src/Db/MySqli/Connection.php

Indentation +2 added lines, -2 removed lines

@@ -12,8 +12,8 @@
 class Connection extends AbstractConnection
 {
     /**
-    * @inheritDoc
-    */
+     * @inheritDoc
+     */
     public function open(string $database, string $schema = '')
     {
         $server = $this->driver->options('server');

src/Db/Server.php

Spacing +2 added lines, -3 removed lines

@@ -15,8 +15,7 @@ 
     {
         // !!! Caching and slow query handling are temporarily disabled !!!
         $query = $this->driver->minVersion(5) ?
-            "SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME" :
-            "SHOW DATABASES";
+            "SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME" : "SHOW DATABASES";
         return $this->driver->values($query);
 
         // SHOW DATABASES can take a very long time so it is cached
@@ -121,7 +120,7 @@ 
      */
     public function dropDatabases(array $databases)
     {
-        return $this->driver->applyQueries("DROP DATABASE", $databases, function ($database) {
+        return $this->driver->applyQueries("DROP DATABASE", $databases, function($database) {
             return $this->driver->escapeId($database);
         });
     }

src/Db/Table.php

Spacing +4 added lines, -6 removed lines

@@ -25,8 +25,7 @@ 
         $query = ($fast && $this->driver->minVersion(5)) ?
             "SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment " .
             "FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() " .
-            ($table != "" ? "AND TABLE_NAME = " . $this->driver->quote($table) : "ORDER BY Name") :
-            "SHOW TABLE STATUS" . ($table != "" ? " LIKE " . $this->driver->quote(addcslashes($table, "%_\\")) : "");
+            ($table != "" ? "AND TABLE_NAME = " . $this->driver->quote($table) : "ORDER BY Name") : "SHOW TABLE STATUS" . ($table != "" ? " LIKE " . $this->driver->quote(addcslashes($table, "%_\\")) : "");
         return $this->driver->rows($query);
     }
 
@@ -181,8 +180,7 @@ 
             $index = new IndexEntity();
 
             $name = $row["Key_name"];
-            $index->type = ($name == "PRIMARY" ? "PRIMARY" :
-                ($row["Index_type"] == "FULLTEXT" ? "FULLTEXT" : ($row["Non_unique"] ?
+            $index->type = ($name == "PRIMARY" ? "PRIMARY" : ($row["Index_type"] == "FULLTEXT" ? "FULLTEXT" : ($row["Non_unique"] ?
                 ($row["Index_type"] == "SPATIAL" ? "SPATIAL" : "INDEX") : "UNIQUE")));
             $index->columns[] = $row["Column_name"];
             $index->lengths[] = ($row["Index_type"] == "SPATIAL" ? null : $row["Sub_part"]);
@@ -222,10 +220,10 @@ 
 
                 $foreignKey->database = $this->driver->unescapeId($match4 != "" ? $match3 : $match4);
                 $foreignKey->table = $this->driver->unescapeId($match4 != "" ? $match4 : $match3);
-                $foreignKey->source = array_map(function ($idf) {
+                $foreignKey->source = array_map(function($idf) {
                     return $this->driver->unescapeId($idf);
                 }, $source[0]);
-                $foreignKey->target = array_map(function ($idf) {
+                $foreignKey->target = array_map(function($idf) {
                     return $this->driver->unescapeId($idf);
                 }, $target[0]);
                 $foreignKey->onDelete = $matchCount > 6 ? $match[6] : "RESTRICT";

src/Db/Database.php

Spacing +6 added lines, -9 removed lines

@@ -77,7 +77,7 @@ 
             $clauses[] = 'DROP INDEX ' . $this->driver->escapeId($index->name);
         }
         foreach ($alter as $index) {
-            $clauses[] = 'ADD ' . ($index->type == 'PRIMARY' ? 'PRIMARY KEY ' :  $index->type . ' ') .
+            $clauses[] = 'ADD ' . ($index->type == 'PRIMARY' ? 'PRIMARY KEY ' : $index->type . ' ') .
                 ($index->name != '' ? $this->driver->escapeId($index->name) . ' ' : '') .
                 '(' . implode(', ', $index->columns) . ')';
         }
@@ -91,8 +91,7 @@ 
     public function tables()
     {
         return $this->driver->keyValues($this->driver->minVersion(5) ?
-            'SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME' :
-            'SHOW TABLES');
+            'SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME' : 'SHOW TABLES');
     }
 
     /**
@@ -112,7 +111,7 @@ 
      */
     public function dropViews(array $views)
     {
-        $this->driver->execute('DROP VIEW ' . implode(', ', array_map(function ($view) {
+        $this->driver->execute('DROP VIEW ' . implode(', ', array_map(function($view) {
             return $this->driver->table($view);
         }, $views)));
         return true;
@@ -123,7 +122,7 @@ 
      */
     public function dropTables(array $tables)
     {
-        $this->driver->execute('DROP TABLE ' . implode(', ', array_map(function ($table) {
+        $this->driver->execute('DROP TABLE ' . implode(', ', array_map(function($table) {
             return $this->driver->table($table);
         }, $tables)));
         return true;
@@ -183,16 +182,14 @@ 
             foreach ($this->driver->rows('SHOW TRIGGERS LIKE ' . $this->driver->quote(addcslashes($table, "%_\\"))) as $row) {
                 $trigger = $row['Trigger'];
                 if (!$this->driver->execute('CREATE TRIGGER ' .
-                    ($target == $this->driver->database() ? $this->driver->escapeId("copy_$trigger") :
-                    $this->driver->escapeId($target) . '.' . $this->driver->escapeId($trigger)) .
+                    ($target == $this->driver->database() ? $this->driver->escapeId("copy_$trigger") : $this->driver->escapeId($target) . '.' . $this->driver->escapeId($trigger)) .
                     " $row[Timing] $row[Event] ON $name FOR EACH ROW\n$row[Statement];")) {
                     return false;
                 }
             }
         }
         foreach ($views as $table) {
-            $name = ($target == $this->driver->database() ? $this->driver->table("copy_$table") :
-                $this->driver->escapeId($target) . '.' . $this->driver->table($table));
+            $name = ($target == $this->driver->database() ? $this->driver->table("copy_$table") : $this->driver->escapeId($target) . '.' . $this->driver->table($table));
             $view = $this->driver->view($table);
             if (($overwrite && !$this->driver->execute("DROP VIEW IF EXISTS $name"))
                 || !$this->driver->execute("CREATE VIEW $name AS $view[select]")) { //! USE to avoid db.table