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

@@ -91,11 +91,9 @@
     {
         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/Table.php

Spacing +1 added lines, -2 removed lines

@@ -246,8 +246,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];

src/Db/Database.php

Spacing +2 added lines, -3 removed lines

@@ -88,8 +88,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") {
@@ -202,7 +201,7 @@ 
      */
     public function truncateTables(array $tables)
     {
-        $this->driver->execute("TRUNCATE " . implode(", ", array_map(function ($table) {
+        $this->driver->execute("TRUNCATE " . implode(", ", array_map(function($table) {
             return $this->driver->table($table);
         }, $tables)));
         return true;

src/Db/Query.php

Spacing +1 added lines, -3 removed lines

@@ -18,9 +18,7 @@
      */
     protected function limitToOne(string $table, string $query, string $where, string $separator = "\n")
     {
-        return (preg_match('~^INTO~', $query) ? $this->driver->limit($query, $where, 1, 0, $separator) :
-            " $query" . ($this->driver->isView($this->driver->tableStatusOrName($table)) ? $where :
-            " WHERE ctid = (SELECT ctid FROM " . $this->driver->table($table) . $where . $separator . "LIMIT 1)")
+        return (preg_match('~^INTO~', $query) ? $this->driver->limit($query, $where, 1, 0, $separator) : " $query" . ($this->driver->isView($this->driver->tableStatusOrName($table)) ? $where : " WHERE ctid = (SELECT ctid FROM " . $this->driver->table($table) . $where . $separator . "LIMIT 1)")
         );
     }
 

src/Db/Grammar.php

Spacing +2 added lines, -2 removed lines

@@ -114,13 +114,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;