@@ -21,7 +21,7 @@ discard block |
||
| 21 | 21 | * |
| 22 | 22 | * @var array |
| 23 | 23 | */ |
| 24 | - private $types = [ //! arrays |
|
| 24 | + private $types = [//! arrays |
|
| 25 | 25 | 'Numbers' => ["integer" => 0, "real" => 0, "numeric" => 0], |
| 26 | 26 | 'Strings' => ["text" => 0], |
| 27 | 27 | 'Binary' => ["blob" => 0], |
@@ -63,7 +63,7 @@ discard block |
||
| 63 | 63 | */ |
| 64 | 64 | private $editFunctions = [[ |
| 65 | 65 | // "text" => "date('now')/time('now')/datetime('now')", |
| 66 | - ],[ |
|
| 66 | + ], [ |
|
| 67 | 67 | "integer|real|numeric" => "+/-", |
| 68 | 68 | // "text" => "date/time/datetime", |
| 69 | 69 | "text" => "||", |
@@ -84,11 +84,9 @@ |
||
| 84 | 84 | { |
| 85 | 85 | if (class_exists("SQLite3")) { |
| 86 | 86 | $connection = new Db\Sqlite\Connection($this, $this->util, $this->trans, 'SQLite3'); |
| 87 | - } |
|
| 88 | - elseif (extension_loaded("pdo_sqlite")) { |
|
| 87 | + } elseif (extension_loaded("pdo_sqlite")) { |
|
| 89 | 88 | $connection = new Db\Pdo\Connection($this, $this->util, $this->trans, 'PDO_SQLite'); |
| 90 | - } |
|
| 91 | - else { |
|
| 89 | + } else { |
|
| 92 | 90 | throw new AuthException($this->trans->lang('No package installed to open a Sqlite database.')); |
| 93 | 91 | } |
| 94 | 92 | |
@@ -27,10 +27,10 @@ |
||
| 27 | 27 | $directory = rtrim($this->driver->options('directory'), '/\\'); |
| 28 | 28 | $iterator = new DirectoryIterator($directory); |
| 29 | 29 | // Iterate on dir content |
| 30 | - foreach($iterator as $file) |
|
| 30 | + foreach ($iterator as $file) |
|
| 31 | 31 | { |
| 32 | 32 | // Skip everything except Sqlite files |
| 33 | - if(!$file->isFile() || !$this->validateName($filename = $file->getFilename())) |
|
| 33 | + if (!$file->isFile() || !$this->validateName($filename = $file->getFilename())) |
|
| 34 | 34 | { |
| 35 | 35 | continue; |
| 36 | 36 | } |
@@ -56,8 +56,7 @@ |
||
| 56 | 56 | public function quote(string $string) |
| 57 | 57 | { |
| 58 | 58 | return ($this->util->isUtf8($string) ? |
| 59 | - "'" . $this->client->escapeString($string) . "'" : |
|
| 60 | - "x'" . reset(unpack('H*', $string)) . "'"); |
|
| 59 | + "'" . $this->client->escapeString($string) . "'" : "x'" . reset(unpack('H*', $string)) . "'"); |
|
| 61 | 60 | } |
| 62 | 61 | |
| 63 | 62 | public function multiQuery(string $query) |
@@ -42,7 +42,7 @@ |
||
| 42 | 42 | if ($name == '') { |
| 43 | 43 | continue; |
| 44 | 44 | } |
| 45 | - $columns = implode(", ", array_map(function ($key) { |
|
| 45 | + $columns = implode(", ", array_map(function($key) { |
|
| 46 | 46 | return $this->escapeId($key); |
| 47 | 47 | }, $index->columns)); |
| 48 | 48 | $query .= ";\n\n" . $this->sqlForCreateIndex($table, $index->type, $name, "($columns)"); |
@@ -149,7 +149,7 @@ discard block |
||
| 149 | 149 | if ($originals && !$this->driver->execute("INSERT INTO " . $this->driver->table($tempName) . |
| 150 | 150 | " (" . implode(", ", $originals) . ") SELECT " . implode( |
| 151 | 151 | ", ", |
| 152 | - array_map(function ($key) { |
|
| 152 | + array_map(function($key) { |
|
| 153 | 153 | return $this->driver->escapeId($key); |
| 154 | 154 | }, array_keys($originals)) |
| 155 | 155 | ) . " FROM " . $this->driver->table($table))) { |
@@ -161,8 +161,7 @@ discard block |
||
| 161 | 161 | $triggers[] = "CREATE TRIGGER " . $this->driver->escapeId($trigger_name) . " " . |
| 162 | 162 | implode(" ", $timing_event) . " ON " . $this->driver->table($name) . "\n$trigger[Statement]"; |
| 163 | 163 | } |
| 164 | - $autoIncrement = $autoIncrement ? 0 : |
|
| 165 | - $this->connection->result("SELECT seq FROM sqlite_sequence WHERE name = " . |
|
| 164 | + $autoIncrement = $autoIncrement ? 0 : $this->connection->result("SELECT seq FROM sqlite_sequence WHERE name = " . |
|
| 166 | 165 | $this->driver->quote($table)); // if $autoIncrement is set then it will be updated later |
| 167 | 166 | // drop before creating indexes and triggers to allow using old names |
| 168 | 167 | if (!$this->driver->execute("DROP TABLE " . $this->driver->table($table)) || |
@@ -196,8 +195,7 @@ discard block |
||
| 196 | 195 | } |
| 197 | 196 | foreach (array_reverse($alter) as $val) { |
| 198 | 197 | if (!$this->driver->execute($val[2] == "DROP" ? |
| 199 | - "DROP INDEX " . $this->driver->escapeId($val[1]) : |
|
| 200 | - $this->driver->sqlForCreateIndex($table, $val[0], $val[1], "(" . implode(", ", $val[2]) . ")") |
|
| 198 | + "DROP INDEX " . $this->driver->escapeId($val[1]) : $this->driver->sqlForCreateIndex($table, $val[0], $val[1], "(" . implode(", ", $val[2]) . ")") |
|
| 201 | 199 | )) { |
| 202 | 200 | return false; |
| 203 | 201 | } |
@@ -15,8 +15,7 @@ |
||
| 15 | 15 | { |
| 16 | 16 | return preg_match('~^INTO~', $query) || |
| 17 | 17 | $this->connection->result("SELECT sqlite_compileoption_used('ENABLE_UPDATE_DELETE_LIMIT')") ? |
| 18 | - $this->driver->limit($query, $where, 1, 0, $separator) : |
|
| 19 | - //! use primary key in tables with WITHOUT rowid |
|
| 18 | + $this->driver->limit($query, $where, 1, 0, $separator) : //! use primary key in tables with WITHOUT rowid |
|
| 20 | 19 | " $query WHERE rowid = (SELECT rowid FROM " . $this->driver->table($table) . $where . $separator . "LIMIT 1)"; |
| 21 | 20 | } |
| 22 | 21 | |