lagdo / dbadmin-driver-pgsql

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;