@@ -71,7 +71,7 @@ |
||
71 | 71 | "char" => "md5/sha1/password/encrypt/uuid", |
72 | 72 | "binary" => "md5/sha1", |
73 | 73 | "date|time" => "now", |
74 | - ],[ |
|
74 | + ], [ |
|
75 | 75 | // $this->numberRegex() => "+/-", |
76 | 76 | "date" => "+ interval/- interval", |
77 | 77 | "time" => "addtime/subtime", |
@@ -94,11 +94,9 @@ |
||
94 | 94 | { |
95 | 95 | if (extension_loaded("mysqli")) { |
96 | 96 | $connection = new Db\MySqli\Connection($this, $this->util, $this->trans, 'MySQLi'); |
97 | - } |
|
98 | - elseif (extension_loaded("pdo_mysql")) { |
|
97 | + } elseif (extension_loaded("pdo_mysql")) { |
|
99 | 98 | $connection = new Db\Pdo\Connection($this, $this->util, $this->trans, 'PDO_MySQL'); |
100 | - } |
|
101 | - else { |
|
99 | + } else { |
|
102 | 100 | throw new AuthException($this->trans->lang('No package installed to connect to a MySQL server.')); |
103 | 101 | } |
104 | 102 |
@@ -12,8 +12,8 @@ |
||
12 | 12 | class Connection extends AbstractConnection |
13 | 13 | { |
14 | 14 | /** |
15 | - * @inheritDoc |
|
16 | - */ |
|
15 | + * @inheritDoc |
|
16 | + */ |
|
17 | 17 | public function open(string $database, string $schema = '') |
18 | 18 | { |
19 | 19 | $server = $this->driver->options('server'); |
@@ -24,8 +24,7 @@ discard block |
||
24 | 24 | foreach ($fields as $field) { |
25 | 25 | $alter[] = ($field[1] ? ($table != "" ? ($field[0] != "" ? "CHANGE " . |
26 | 26 | $this->driver->escapeId($field[0]) : "ADD") : " ") . " " . |
27 | - implode($field[1]) . ($table != "" ? $field[2] : "") : |
|
28 | - "DROP " . $this->driver->escapeId($field[0]) |
|
27 | + implode($field[1]) . ($table != "" ? $field[2] : "") : "DROP " . $this->driver->escapeId($field[0]) |
|
29 | 28 | ); |
30 | 29 | } |
31 | 30 | $alter = array_merge($alter, $foreign); |
@@ -74,8 +73,7 @@ discard block |
||
74 | 73 | public function tables() |
75 | 74 | { |
76 | 75 | return $this->driver->keyValues($this->driver->minVersion(5) ? |
77 | - "SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME" : |
|
78 | - "SHOW TABLES"); |
|
76 | + "SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME" : "SHOW TABLES"); |
|
79 | 77 | } |
80 | 78 | |
81 | 79 | /** |
@@ -95,7 +93,7 @@ discard block |
||
95 | 93 | */ |
96 | 94 | public function dropViews(array $views) |
97 | 95 | { |
98 | - $this->driver->execute("DROP VIEW " . implode(", ", array_map(function ($view) { |
|
96 | + $this->driver->execute("DROP VIEW " . implode(", ", array_map(function($view) { |
|
99 | 97 | return $this->driver->table($view); |
100 | 98 | }, $views))); |
101 | 99 | return true; |
@@ -106,7 +104,7 @@ discard block |
||
106 | 104 | */ |
107 | 105 | public function dropTables(array $tables) |
108 | 106 | { |
109 | - $this->driver->execute("DROP TABLE " . implode(", ", array_map(function ($table) { |
|
107 | + $this->driver->execute("DROP TABLE " . implode(", ", array_map(function($table) { |
|
110 | 108 | return $this->driver->table($table); |
111 | 109 | }, $tables))); |
112 | 110 | return true; |
@@ -15,8 +15,7 @@ discard block |
||
15 | 15 | { |
16 | 16 | // !!! Caching and slow query handling are temporarily disabled !!! |
17 | 17 | $query = $this->driver->minVersion(5) ? |
18 | - "SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME" : |
|
19 | - "SHOW DATABASES"; |
|
18 | + "SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME" : "SHOW DATABASES"; |
|
20 | 19 | return $this->driver->values($query); |
21 | 20 | |
22 | 21 | // SHOW DATABASES can take a very long time so it is cached |
@@ -121,7 +120,7 @@ discard block |
||
121 | 120 | */ |
122 | 121 | public function dropDatabases(array $databases) |
123 | 122 | { |
124 | - return $this->driver->applyQueries("DROP DATABASE", $databases, function ($database) { |
|
123 | + return $this->driver->applyQueries("DROP DATABASE", $databases, function($database) { |
|
125 | 124 | return $this->driver->escapeId($database); |
126 | 125 | }); |
127 | 126 | } |
@@ -25,8 +25,7 @@ discard block |
||
25 | 25 | $query = ($fast && $this->driver->minVersion(5)) ? |
26 | 26 | "SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment " . |
27 | 27 | "FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() " . |
28 | - ($table != "" ? "AND TABLE_NAME = " . $this->driver->quote($table) : "ORDER BY Name") : |
|
29 | - "SHOW TABLE STATUS" . ($table != "" ? " LIKE " . $this->driver->quote(addcslashes($table, "%_\\")) : ""); |
|
28 | + ($table != "" ? "AND TABLE_NAME = " . $this->driver->quote($table) : "ORDER BY Name") : "SHOW TABLE STATUS" . ($table != "" ? " LIKE " . $this->driver->quote(addcslashes($table, "%_\\")) : ""); |
|
30 | 29 | return $this->driver->rows($query); |
31 | 30 | } |
32 | 31 | |
@@ -181,8 +180,7 @@ discard block |
||
181 | 180 | $index = new IndexEntity(); |
182 | 181 | |
183 | 182 | $name = $row["Key_name"]; |
184 | - $index->type = ($name == "PRIMARY" ? "PRIMARY" : |
|
185 | - ($row["Index_type"] == "FULLTEXT" ? "FULLTEXT" : ($row["Non_unique"] ? |
|
183 | + $index->type = ($name == "PRIMARY" ? "PRIMARY" : ($row["Index_type"] == "FULLTEXT" ? "FULLTEXT" : ($row["Non_unique"] ? |
|
186 | 184 | ($row["Index_type"] == "SPATIAL" ? "SPATIAL" : "INDEX") : "UNIQUE"))); |
187 | 185 | $index->columns[] = $row["Column_name"]; |
188 | 186 | $index->lengths[] = ($row["Index_type"] == "SPATIAL" ? null : $row["Sub_part"]); |
@@ -222,10 +220,10 @@ discard block |
||
222 | 220 | |
223 | 221 | $foreignKey->database = $this->driver->unescapeId($match4 != "" ? $match3 : $match4); |
224 | 222 | $foreignKey->table = $this->driver->unescapeId($match4 != "" ? $match4 : $match3); |
225 | - $foreignKey->source = array_map(function ($idf) { |
|
223 | + $foreignKey->source = array_map(function($idf) { |
|
226 | 224 | return $this->driver->unescapeId($idf); |
227 | 225 | }, $source[0]); |
228 | - $foreignKey->target = array_map(function ($idf) { |
|
226 | + $foreignKey->target = array_map(function($idf) { |
|
229 | 227 | return $this->driver->unescapeId($idf); |
230 | 228 | }, $target[0]); |
231 | 229 | $foreignKey->onDelete = $matchCount > 6 ? $match[6] : "RESTRICT"; |