lagdo / dbadmin-driver-pgsql

src/Driver.php

Spacing +2 added lines, -2 removed lines

@@ -21,7 +21,7 @@ 
      *
      * @var array
      */
-    private $types = [ //! arrays
+    private $types = [//! arrays
         'Numbers' => ["smallint" => 5, "integer" => 10, "bigint" => 19, "boolean" => 1,
             "numeric" => 0, "real" => 7, "double precision" => 16, "money" => 20],
         'Date and time' => ["date" => 13, "time" => 17, "timestamp" => 20, "timestamptz" => 21, "interval" => 0],
@@ -70,7 +70,7 @@ 
     private $editFunctions = [[
         "char" => "md5",
         "date|time" => "now",
-    ],[
+    ], [
         // $this->numberRegex() => "+/-",
         "date|time" => "+ interval/- interval", //! escape
         "char|text" => "||",

Braces +2 added lines, -4 removed lines

@@ -92,11 +92,9 @@
         $connection = null;
         if (extension_loaded("pgsql")) {
             $connection = new Db\PgSql\Connection($this, $this->util, $this->trans, 'PgSQL');
-        }
-        elseif (extension_loaded("pdo_pgsql")) {
+        } elseif (extension_loaded("pdo_pgsql")) {
             $connection = new Db\Pdo\Connection($this, $this->util, $this->trans, 'PDO_PgSQL');
-        }
-        else {
+        } else {
             throw new AuthException($this->trans->lang('No package installed to connect to a PostgreSQL server.'));
         }
 

src/Db/Pdo/Connection.php

Indentation +2 added lines, -2 removed lines

@@ -17,8 +17,8 @@
     public $timeout;
 
     /**
-    * @inheritDoc
-    */
+     * @inheritDoc
+     */
     public function open(string $database, string $schema = '')
     {
         $server = str_replace(":", "' port='", addcslashes($this->driver->options('server'), "'\\"));

src/Db/Grammar.php

Spacing +3 added lines, -5 removed lines

@@ -28,9 +28,7 @@ 
      */
     public function limitToOne(string $table, string $query, string $where, string $separator = "\n")
     {
-        return (preg_match('~^INTO~', $query) ? $this->limit($query, $where, 1, 0, $separator) :
-            " $query" . ($this->driver->isView($this->driver->tableStatusOrName($table)) ? $where :
-            " WHERE ctid = (SELECT ctid FROM " . $this->table($table) . $where . $separator . "LIMIT 1)")
+        return (preg_match('~^INTO~', $query) ? $this->limit($query, $where, 1, 0, $separator) : " $query" . ($this->driver->isView($this->driver->tableStatusOrName($table)) ? $where : " WHERE ctid = (SELECT ctid FROM " . $this->table($table) . $where . $separator . "LIMIT 1)")
         );
     }
 
@@ -126,13 +124,13 @@ 
             switch ($index->type) {
                 case 'UNIQUE':
                     $clauses[] = "CONSTRAINT " . $this->escapeId($index_name) .
-                        " UNIQUE (" . implode(', ', array_map(function ($column) {
+                        " UNIQUE (" . implode(', ', array_map(function($column) {
                             return $this->escapeId($column);
                         }, $index->columns)) . ")";
                     break;
                 case 'PRIMARY':
                     $clauses[] = "CONSTRAINT " . $this->escapeId($index_name) .
-                        " PRIMARY KEY (" . implode(', ', array_map(function ($column) {
+                        " PRIMARY KEY (" . implode(', ', array_map(function($column) {
                             return $this->escapeId($column);
                         }, $index->columns)) . ")";
                     break;

src/Db/Server.php

Spacing +1 added lines, -1 removed lines

@@ -78,7 +78,7 @@
      */
     public function truncateTables(array $tables)
     {
-        return $this->driver->queries("TRUNCATE " . implode(", ", array_map(function ($table) {
+        return $this->driver->queries("TRUNCATE " . implode(", ", array_map(function($table) {
             return $this->driver->table($table);
         }, $tables)));
         return true;

src/Db/Query.php

Spacing +1 added lines, -1 removed lines

@@ -66,7 +66,7 @@
     {
         $query = "EXPLAIN SELECT * FROM " . $this->driver->escapeId($tableStatus->name) .
             ($where ? " WHERE " . implode(" AND ", $where) : "");
-        if (preg_match("~ rows=([0-9]+)~", $this->connection->result($query), $regs ))
+        if (preg_match("~ rows=([0-9]+)~", $this->connection->result($query), $regs))
         {
             return $regs[1];
         }

src/Db/Table.php

Spacing +2 added lines, -4 removed lines

@@ -179,8 +179,7 @@ 
             $index = new IndexEntity();
 
             $relname = $row["relname"];
-            $index->type = ($row["indispartial"] ? "INDEX" :
-                ($row["indisprimary"] ? "PRIMARY" : ($row["indisunique"] ? "UNIQUE" : "INDEX")));
+            $index->type = ($row["indispartial"] ? "INDEX" : ($row["indisprimary"] ? "PRIMARY" : ($row["indisunique"] ? "UNIQUE" : "INDEX")));
             $index->columns = [];
             foreach (explode(" ", $row["indkey"]) as $indkey) {
                 $index->columns[] = $columns[$indkey];
@@ -311,8 +310,7 @@ 
             if ($val[0] != "INDEX") {
                 //! descending UNIQUE indexes results in syntax error
                 $create[] = (
-                    $val[2] == "DROP" ? "\nDROP CONSTRAINT " . $this->driver->escapeId($val[1]) :
-                    "\nADD" . ($val[1] != "" ? " CONSTRAINT " . $this->driver->escapeId($val[1]) : "") .
+                    $val[2] == "DROP" ? "\nDROP CONSTRAINT " . $this->driver->escapeId($val[1]) : "\nADD" . ($val[1] != "" ? " CONSTRAINT " . $this->driver->escapeId($val[1]) : "") .
                     " $val[0] " . ($val[0] == "PRIMARY" ? "KEY " : "") . "(" . implode(", ", $val[2]) . ")"
                 );
             } elseif ($val[2] == "DROP") {