@@ -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)"); |
@@ -142,8 +142,8 @@ |
||
142 | 142 | ' (' . implode(', ', $originals) . ') SELECT ' . implode( |
143 | 143 | ', ', |
144 | 144 | array_map(function ($key) { |
145 | - return $this->driver->escapeId($key); |
|
146 | - }, array_keys($originals)) |
|
145 | + return $this->driver->escapeId($key); |
|
146 | + }, array_keys($originals)) |
|
147 | 147 | ) . ' FROM ' . $this->driver->table($table))) { |
148 | 148 | return false; |
149 | 149 | } |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | if ($originals && !$this->driver->execute('INSERT INTO ' . $this->driver->table($tempName) . |
100 | 100 | ' (' . implode(', ', $originals) . ') SELECT ' . implode( |
101 | 101 | ', ', |
102 | - array_map(function ($key) { |
|
102 | + array_map(function($key) { |
|
103 | 103 | return $this->driver->escapeId($key); |
104 | 104 | }, array_keys($originals)) |
105 | 105 | ) . ' FROM ' . $this->driver->table($table))) { |
@@ -111,8 +111,7 @@ discard block |
||
111 | 111 | $triggers[] = 'CREATE TRIGGER ' . $this->driver->escapeId($trigger_name) . ' ' . |
112 | 112 | implode(' ', $timing_event) . ' ON ' . $this->driver->table($name) . "\n$trigger[Statement]"; |
113 | 113 | } |
114 | - $autoIncrement = $autoIncrement ? 0 : |
|
115 | - $this->connection->result('SELECT seq FROM sqlite_sequence WHERE name = ' . |
|
114 | + $autoIncrement = $autoIncrement ? 0 : $this->connection->result('SELECT seq FROM sqlite_sequence WHERE name = ' . |
|
116 | 115 | $this->driver->quote($table)); // if $autoIncrement is set then it will be updated later |
117 | 116 | // drop before creating indexes and triggers to allow using old names |
118 | 117 | if (!$this->driver->execute('DROP TABLE ' . $this->driver->table($table)) || |
@@ -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) : |
|
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 |