lagdo / dbadmin-driver-sqlite

src/Driver.php

Spacing +2 added lines, -2 removed lines

@@ -21,7 +21,7 @@ 
      *
      * @var array
      */
-    private $types = [ //! arrays
+    private $types = [//! arrays
         'Numbers' => ["integer" => 0, "real" => 0, "numeric" => 0],
         'Strings' => ["text" => 0],
         'Binary' => ["blob" => 0],
@@ -63,7 +63,7 @@ 
      */
     private $editFunctions = [[
         // "text" => "date('now')/time('now')/datetime('now')",
-    ],[
+    ], [
         "integer|real|numeric" => "+/-",
         // "text" => "date/time/datetime",
         "text" => "||",

Braces +2 added lines, -4 removed lines

@@ -84,11 +84,9 @@
     {
         if (class_exists("SQLite3")) {
             $connection = new Db\Sqlite\Connection($this, $this->util, $this->trans, 'SQLite3');
-        }
-        elseif (extension_loaded("pdo_sqlite")) {
+        } elseif (extension_loaded("pdo_sqlite")) {
             $connection = new Db\Pdo\Connection($this, $this->util, $this->trans, 'PDO_SQLite');
-        }
-        else {
+        } else {
             throw new AuthException($this->trans->lang('No package installed to open a Sqlite database.'));
         }
 

src/Db/Grammar.php

Spacing +2 added lines, -3 removed lines

@@ -30,8 +30,7 @@ 
     {
         return preg_match('~^INTO~', $query) ||
             $this->connection->result("SELECT sqlite_compileoption_used('ENABLE_UPDATE_DELETE_LIMIT')") ?
-            $this->limit($query, $where, 1, 0, $separator) :
-            //! use primary key in tables with WITHOUT rowid
+            $this->limit($query, $where, 1, 0, $separator) : //! use primary key in tables with WITHOUT rowid
             " $query WHERE rowid = (SELECT rowid FROM " . $this->table($table) . $where . $separator . "LIMIT 1)";
     }
 
@@ -54,7 +53,7 @@ 
             if ($name == '') {
                 continue;
             }
-            $columns = implode(", ", array_map(function ($key) {
+            $columns = implode(", ", array_map(function($key) {
                 return $this->escapeId($key);
             }, $index->columns));
             $query .= ";\n\n" . $this->sqlForCreateIndex($table, $index->type, $name, "($columns)");

src/Db/Server.php

Spacing +2 added lines, -2 removed lines

@@ -27,10 +27,10 @@
         $directory = rtrim($this->driver->options('directory'), '/\\');
         $iterator = new DirectoryIterator($directory);
         // Iterate on dir content
-        foreach($iterator as $file)
+        foreach ($iterator as $file)
         {
             // Skip everything except Sqlite files
-            if(!$file->isFile() || !$this->validateName($filename = $file->getFilename()))
+            if (!$file->isFile() || !$this->validateName($filename = $file->getFilename()))
             {
                 continue;
             }

src/Db/Table.php

Indentation +2 added lines, -2 removed lines

@@ -328,8 +328,8 @@
                 " (" . implode(", ", $originals) . ") SELECT " . implode(
                     ", ",
                     array_map(function ($key) {
-                   return $this->driver->escapeId($key);
-               }, array_keys($originals))
+                    return $this->driver->escapeId($key);
+                }, array_keys($originals))
                 ) . " FROM " . $this->driver->table($table))) {
                 return false;
             }

Spacing +4 added lines, -7 removed lines

@@ -84,8 +84,7 @@ 
                 "text" : (preg_match('~blob~i', $type) ? "blob" : (preg_match('~real|floa|doub~i', $type) ?
                 "real" : "numeric"))));
             $field->fullType = $type;
-            $field->default = (preg_match("~'(.*)'~", $default, $match) ? str_replace("''", "'", $match[1]) :
-                ($default == "NULL" ? null : $default));
+            $field->default = (preg_match("~'(.*)'~", $default, $match) ? str_replace("''", "'", $match[1]) : ($default == "NULL" ? null : $default));
             $field->null = !$row["notnull"];
             $field->privileges = ["select" => 1, "insert" => 1, "update" => 1];
             $field->primary = $row["pk"];
@@ -327,7 +326,7 @@ 
             if ($originals && !$this->driver->execute("INSERT INTO " . $this->driver->table($tempName) .
                 " (" . implode(", ", $originals) . ") SELECT " . implode(
                     ", ",
-                    array_map(function ($key) {
+                    array_map(function($key) {
                    return $this->driver->escapeId($key);
                }, array_keys($originals))
                 ) . " FROM " . $this->driver->table($table))) {
@@ -339,8 +338,7 @@ 
                 $triggers[] = "CREATE TRIGGER " . $this->driver->escapeId($trigger_name) . " " .
                     implode(" ", $timing_event) . " ON " . $this->driver->table($name) . "\n$trigger[Statement]";
             }
-            $autoIncrement = $autoIncrement ? 0 :
-                $this->connection->result("SELECT seq FROM sqlite_sequence WHERE name = " .
+            $autoIncrement = $autoIncrement ? 0 : $this->connection->result("SELECT seq FROM sqlite_sequence WHERE name = " .
                 $this->driver->quote($table)); // if $autoIncrement is set then it will be updated later
             // drop before creating indexes and triggers to allow using old names
             if (!$this->driver->execute("DROP TABLE " . $this->driver->table($table)) ||
@@ -374,8 +372,7 @@ 
         }
         foreach (array_reverse($alter) as $val) {
             if (!$this->driver->execute($val[2] == "DROP" ?
-                "DROP INDEX " . $this->driver->escapeId($val[1]) :
-                $this->driver->sqlForCreateIndex($table, $val[0], $val[1], "(" . implode(", ", $val[2]) . ")")
+                "DROP INDEX " . $this->driver->escapeId($val[1]) : $this->driver->sqlForCreateIndex($table, $val[0], $val[1], "(" . implode(", ", $val[2]) . ")")
             )) {
                 return false;
             }

src/Db/Sqlite/Connection.php

Spacing +1 added lines, -2 removed lines

@@ -56,8 +56,7 @@
     public function quote(string $string)
     {
         return ($this->util->isUtf8($string) ?
-            "'" . $this->client->escapeString($string) . "'" :
-            "x'" . reset(unpack('H*', $string)) . "'");
+            "'" . $this->client->escapeString($string) . "'" : "x'" . reset(unpack('H*', $string)) . "'");
     }
 
     public function multiQuery(string $query)