lagdo / jaxon-dbadmin

src/Driver/Facades/ViewFacade.php

Spacing +1 added lines, -2 removed lines

@@ -45,8 +45,7 @@
         // From table.inc.php
         $status = $this->status($view);
         $name = $this->page->tableName($status);
-        $title = ($status->engine == 'materialized view' ? $this->utils->trans->lang('Materialized view') :
-            $this->utils->trans->lang('View')) . ': ' . ($name != '' ? $name : $this->utils->str->html($view));
+        $title = ($status->engine == 'materialized view' ? $this->utils->trans->lang('Materialized view') : $this->utils->trans->lang('View')) . ': ' . ($name != '' ? $name : $this->utils->str->html($view));
 
         $comment = $status->comment;
 

src/Driver/Facades/SelectFacade.php

Spacing +6 added lines, -9 removed lines

@@ -34,7 +34,7 @@ 
     /**
      * @var SelectEntity|null
      */
-    private SelectEntity|null $selectEntity = null;
+    private SelectEntity | null $selectEntity = null;
 
     /**
      * @param AbstractFacade $dbFacade
@@ -117,11 +117,9 @@ 
         $value = $this->selectEntity->queryOptions["columns"][$valueKey] ?? [];
 
         $fun = $value["fun"] ?? '';
-        $fieldKey = !$this->selectEntity->select ? $key :
-            ($value["col"] ?? current($this->selectEntity->select));
+        $fieldKey = !$this->selectEntity->select ? $key : ($value["col"] ?? current($this->selectEntity->select));
         $field = $this->selectEntity->fields[$fieldKey];
-        $name = !$field ? ($fun ? "*" : $key) :
-            $this->page->fieldName($field, $rank);
+        $name = !$field ? ($fun ? "*" : $key) : $this->page->fieldName($field, $rank);
 
         return [$fun, $name, $field];
     }
@@ -247,8 +245,7 @@ 
     private function getRowIdMd5Key(string $key, string $collation): string
     {
         return $this->driver->jush() != 'sql' ||
-            preg_match("~^utf8~", $collation) ? $key :
-                "CONVERT($key USING " . $this->driver->charset() . ")";
+            preg_match("~^utf8~", $collation) ? $key : "CONVERT($key USING " . $this->driver->charset() . ")";
     }
 
     /**
@@ -357,8 +354,8 @@ 
             $query = $this->driver->getRowCountQuery($table,
                 $this->selectEntity->where, $this->hasGroupsInFields(),
                 $this->selectEntity->group);
-            return (int)$this->driver->result($query);
-        } catch(Exception $_) {
+            return (int) $this->driver->result($query);
+        } catch (Exception $_) {
             return -1;
         }
     }

src/Driver/Facades/TableFacade.php

Spacing +3 added lines, -4 removed lines

@@ -126,8 +126,7 @@ 
         }
         $foreignKey = $this->foreignKeys[$field->type] ?? null;
         //! Can collide with user defined type
-        $typeField = ($foreignKey === null ? $field :
-            TableFieldEntity::make($this->referencableTables[$foreignKey]));
+        $typeField = ($foreignKey === null ? $field : TableFieldEntity::make($this->referencableTables[$foreignKey]));
         $processedField = $this->driver->processField($field, $typeField);
         $origField = $this->fields[$field->name] ?? null;
         $this->after = '';
@@ -374,14 +373,14 @@ 
                 $target .= '<b>' . $this->utils->str->html($foreignKey->schema) . '</b>.';
             }
             $target = $this->utils->str->html($foreignKey->table) .
-                '(' . implode(', ', array_map(function ($key) {
+                '(' . implode(', ', array_map(function($key) {
                     return $this->utils->str->html($key);
                 }, $foreignKey->target)) . ')';
             $details[] = [
                 'name' => $this->utils->str->html($name),
                 'source' => '<i>' . implode(
                     '</i>, <i>',
-                    array_map(function ($key) {
+                    array_map(function($key) {
                         return $this->utils->str->html($key);
                     }, $foreignKey->source)
                 ) . '</i>',

src/Driver/Facades/ExportFacade.php

Spacing +6 added lines, -10 removed lines

@@ -144,8 +144,7 @@ 
             $key = $this->driver->escapeId($field->name());
             $values[] = "$key = VALUES($key)";
         }
-        $dump->suffix = $this->options['data_style'] !== 'INSERT+UPDATE' ? ';' :
-            "\nON DUPLICATE KEY UPDATE " . implode(', ', $values) . ';';
+        $dump->suffix = $this->options['data_style'] !== 'INSERT+UPDATE' ? ';' : "\nON DUPLICATE KEY UPDATE " . implode(', ', $values) . ';';
 
         return $keys;
     }
@@ -171,7 +170,7 @@ 
 
         if ($dump->insert === '') {
             $dump->insert = 'INSERT INTO ' . $this->driver->escapeTableName($dump->table) . ' (' .
-                implode(', ', array_map(function ($key) {
+                implode(', ', array_map(function($key) {
                     return $this->driver->escapeId($key);
                 }, $keys)) . ') VALUES';
         }
@@ -197,8 +196,7 @@ 
         $fields = $this->options['format'] !== 'sql' ? [] : $this->driver->fields($dump->table);
         $keys = [];
         $fetchFunction = $dump->table !== '' ?
-            fn($statement) => $statement->fetchAssoc() :
-            fn($statement) => $statement->fetchRow();
+            fn($statement) => $statement->fetchAssoc() : fn($statement) => $statement->fetchRow();
         while ($row = $fetchFunction($statement)) {
             if (empty($keys)) {
                 $keys = $this->getDataRowKeys($dump, $row, $statement);
@@ -467,12 +465,10 @@ 
         // From dump.inc.php create_routine()
         $routineName = $this->driver->escapeId(trim($routine->name));
         $routineParams = $this->getRoutineParams($routineInfo->params);
-        $routineReturns = $routine->type !== 'FUNCTION' ? '' :
-            ' RETURNS' . $this->driver->processType($routineInfo->return, 'CHARACTER SET');
+        $routineReturns = $routine->type !== 'FUNCTION' ? '' : ' RETURNS' . $this->driver->processType($routineInfo->return, 'CHARACTER SET');
         $routineLanguage = $routineInfo->language ? " LANGUAGE {$routineInfo->language}" : '';
         $definition = rtrim($routineInfo->definition, ';');
-        $routineDefinition = $this->driver->jush() !== 'pgsql' ? "\n$definition;" :
-            ' AS ' . $this->driver->quote($definition);
+        $routineDefinition = $this->driver->jush() !== 'pgsql' ? "\n$definition;" : ' AS ' . $this->driver->quote($definition);
 
         return "CREATE {$routine->type} $routineName ($routineParams)" .
             "{$routineReturns}{$routineLanguage}{$routineDefinition};";
@@ -638,7 +634,7 @@ 
      *
      * @return array|string
      */
-    public function exportDatabases(array $databases, array $options): array|string
+    public function exportDatabases(array $databases, array $options): array | string
     {
         // From dump.inc.php
         // $tables = array_flip($options['tables']) + array_flip($options['data']);

Braces +1 added lines, -2 removed lines

@@ -279,8 +279,7 @@
         foreach ($databases as $database => $tables) {
             try {
                 $this->dumpDatabase($database, $tables);
-            }
-            catch (Exception $e) {
+            } catch (Exception $e) {
                 return $e->getMessage();
             }
         }

src/Driver/Facades/AbstractFacade.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
     /**
      * @var AppDriver|null
      */
-    protected AppDriver|null $driver = null;
+    protected AppDriver | null $driver = null;
 
     /**
      * @var AppPage

src/Page/TableExport.php

Spacing +1 added lines, -2 removed lines

@@ -30,8 +30,7 @@
     public function getSelectDataValues(): array
     {
         //! use insertOrUpdate() in all drivers
-        return $this->driver->jush() !== 'sql' ? ['', 'TRUNCATE+INSERT', 'INSERT'] :
-            ['', 'TRUNCATE+INSERT', 'INSERT', 'INSERT+UPDATE'];
+        return $this->driver->jush() !== 'sql' ? ['', 'TRUNCATE+INSERT', 'INSERT'] : ['', 'TRUNCATE+INSERT', 'INSERT', 'INSERT+UPDATE'];
     }
 
     private function getDataRowOptions(string $database, string $table): array

src/Page/Dql/SelectOptions.php

Spacing +4 added lines, -4 removed lines

@@ -25,7 +25,7 @@ 
     {
         return [
             'select' => $select,
-            'values' => (array)$options["columns"],
+            'values' => (array) $options["columns"],
             'columns' => $columns,
             'functions' => $this->driver->functions(),
             'grouping' => $this->driver->grouping(),
@@ -49,7 +49,7 @@ 
         }
         return [
             // 'where' => $where,
-            'values' => (array)$options["where"],
+            'values' => (array) $options["where"],
             'columns' => $columns,
             'indexes' => $indexes,
             'operators' => $this->driver->operators(),
@@ -68,8 +68,8 @@ 
     private function getSortingOptions(array $columns, array $options): array
     {
         $values = [];
-        $descs = (array)$options["desc"];
-        foreach ((array)$options["order"] as $key => $value) {
+        $descs = (array) $options["desc"];
+        foreach ((array) $options["order"] as $key => $value) {
             $values[] = [
                 'col' => $value,
                 'desc' => $descs[$key] ?? 0,

src/Page/Dql/SelectQuery.php

Spacing +3 added lines, -3 removed lines

@@ -286,7 +286,7 @@ 
         $col = $value['col'];
         $prefix = '';
         if ($op === 'FIND_IN_SET') {
-            $prefix = $op .'(' . $this->driver->quote($value['val']) . ', ';
+            $prefix = $op . '(' . $this->driver->quote($value['val']) . ', ';
         }
         $condition = $this->getWhereCondition($value, $fields);
         if ($col !== '') {
@@ -315,7 +315,7 @@ 
      */
     private function getMatchExpression(IndexEntity $index, int $i): string
     {
-        $columns = array_map(function ($column) {
+        $columns = array_map(function($column) {
             return $this->driver->escapeId($column);
         }, $index->columns);
         $fulltext = $this->utils->input->values['fulltext'][$i] ?? '';
@@ -341,7 +341,7 @@ 
             }
         }
         foreach ((array) $this->utils->input->values['where'] as $value) {
-            if (($value['col'] !== '' ||  $value['val'] !== '') &&
+            if (($value['col'] !== '' || $value['val'] !== '') &&
                 in_array($value['op'], $this->driver->operators())) {
                 $selectEntity->where[] = $this
                     ->getSelectExpression($value, $selectEntity->fields);

src/Page/Dql/SelectEntity.php

Spacing +1 added lines, -1 removed lines

@@ -105,7 +105,7 @@
     /**
      * @var string|null
      */
-    public string|null $error = null;
+    public string | null $error = null;
 
     /**
      * @var TableSelectEntity