@@ -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 | } |
@@ -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)"); |
@@ -118,7 +118,7 @@ discard block |
||
| 118 | 118 | $clauses = []; |
| 119 | 119 | foreach ($tableAttrs->fields as $field) { |
| 120 | 120 | if ($field[1]) { |
| 121 | - $clauses[] = ($field[0] != '' ? $field[1] : 'ADD ' . implode($field[1])); |
|
| 121 | + $clauses[] = ($field[0] != '' ? $field[1] : 'ADD ' . implode($field[1])); |
|
| 122 | 122 | } |
| 123 | 123 | } |
| 124 | 124 | $queries = []; |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | foreach (array_reverse($alter) as $index) { |
| 152 | 152 | // Can't alter primary keys |
| 153 | 153 | if ($index->type !== 'PRIMARY') { |
| 154 | - $queries[] = $this->driver->sqlForCreateIndex($table, $index->type, |
|
| 154 | + $queries[] = $this->driver->sqlForCreateIndex($table, $index->type, |
|
| 155 | 155 | $index->name, '(' . implode(', ', $index->columns) . ')'); |
| 156 | 156 | } |
| 157 | 157 | } |
@@ -15,8 +15,7 @@ |
||
| 15 | 15 | { |
| 16 | 16 | return preg_match('~^INTO~', $query) || |
| 17 | 17 | $this->driver->result("SELECT sqlite_compileoption_used('ENABLE_UPDATE_DELETE_LIMIT')") ? |
| 18 | - $this->driver->limit($query, $where, 1, 0) : |
|
| 19 | - //! use primary key in tables with WITHOUT rowid |
|
| 18 | + $this->driver->limit($query, $where, 1, 0) : //! use primary key in tables with WITHOUT rowid |
|
| 20 | 19 | " $query WHERE rowid = (SELECT rowid FROM " . $this->driver->table($table) . $where . ' LIMIT 1)'; |
| 21 | 20 | } |
| 22 | 21 | |