@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | */ |
79 | 79 | private function genDsn(string $database = null) |
80 | 80 | { |
81 | - $database || $database='Geoip.db.sqlite'; |
|
81 | + $database || $database = 'Geoip.db.sqlite'; |
|
82 | 82 | try { |
83 | 83 | $destination = rtrim(dirname(__DIR__), self::DS); |
84 | 84 | if (!is_writeable($destination)) |
@@ -86,15 +86,15 @@ discard block |
||
86 | 86 | throw new \Throwable('The required destination path is not writable: '.$destination); |
87 | 87 | } |
88 | 88 | $info = new \SplFileInfo($database); |
89 | - $dbName= $info->getFilename(); |
|
90 | - $dbSuffix='.sqlite'; |
|
91 | - if (substr_compare(strtolower($dbName), $dbSuffix, -strlen($dbSuffix)) !== 0) { $dbName .= $dbSuffix ; } |
|
89 | + $dbName = $info->getFilename(); |
|
90 | + $dbSuffix = '.sqlite'; |
|
91 | + if (substr_compare(strtolower($dbName), $dbSuffix, -strlen($dbSuffix)) !== 0) { $dbName .= $dbSuffix; } |
|
92 | 92 | } catch (\Throwable $th) { |
93 | 93 | trigger_error($th->getMessage(), E_USER_ERROR); |
94 | 94 | } |
95 | 95 | $destination .= self::DS.'data'; |
96 | 96 | if (!is_dir($destination)) { mkdir($destination, '0755', true); } |
97 | - return 'sqlite:'.realpath($destination).self::DS.$dbName ; |
|
97 | + return 'sqlite:'.realpath($destination).self::DS.$dbName; |
|
98 | 98 | } |
99 | 99 | /** |
100 | 100 | * Get the table list in the database |
@@ -152,16 +152,16 @@ discard block |
||
152 | 152 | $sCommand .= 'FROM `ipv%dRange` '; |
153 | 153 | $sCommand .= 'WHERE `start` <= :start '; |
154 | 154 | $sCommand .= 'ORDER BY start DESC LIMIT 1'; |
155 | - $statement = $this->oPDOInstance->prepare(sprintf($sCommand, $ipVersion)) ; |
|
156 | - $statement->execute([':start' => $start ]) ; |
|
157 | - $row = $statement->fetch(\PDO::FETCH_OBJ) ; |
|
155 | + $statement = $this->oPDOInstance->prepare(sprintf($sCommand, $ipVersion)); |
|
156 | + $statement->execute([':start' => $start]); |
|
157 | + $row = $statement->fetch(\PDO::FETCH_OBJ); |
|
158 | 158 | if (is_bool($row) && $row === false) |
159 | 159 | { |
160 | 160 | $row = new \stdClass(); |
161 | - $row->end = 0 ; |
|
161 | + $row->end = 0; |
|
162 | 162 | } |
163 | - if ($row->end < $start || !$row->country) { $row->country = 'ZZ' ; } |
|
164 | - return $row->country ; |
|
163 | + if ($row->end < $start || !$row->country) { $row->country = 'ZZ'; } |
|
164 | + return $row->country; |
|
165 | 165 | } catch (\PDOException $th) { |
166 | 166 | trigger_error($th->getMessage(), E_USER_ERROR); |
167 | 167 | } |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | * @param array $tablesList |
173 | 173 | * @return void |
174 | 174 | */ |
175 | - public function flush(array $tablesList=[]) |
|
175 | + public function flush(array $tablesList = []) |
|
176 | 176 | { |
177 | 177 | !empty($tablesList) || $tablesList = $this->showTables(); |
178 | 178 | is_array($tablesList) || $tablesList = [$tablesList]; |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | $this->oPDOInstance->query('VACUUM'); |
187 | 187 | endif; |
188 | 188 | } catch (\PDOException $th) { |
189 | - trigger_error('Statement failed: ' . $th->getMessage(), E_USER_ERROR); |
|
189 | + trigger_error('Statement failed: '.$th->getMessage(), E_USER_ERROR); |
|
190 | 190 | } |
191 | 191 | } |
192 | 192 | /** |
@@ -202,16 +202,16 @@ discard block |
||
202 | 202 | { |
203 | 203 | try |
204 | 204 | { |
205 | - $sQuery ='INSERT INTO `ipv%dRange` (`start`, `end`, `country`) values (:start, :end, :country)'; |
|
205 | + $sQuery = 'INSERT INTO `ipv%dRange` (`start`, `end`, `country`) values (:start, :end, :country)'; |
|
206 | 206 | $command = sprintf($sQuery, $ipVersion); |
207 | 207 | $statement = $this->oPDOInstance->prepare($command); |
208 | 208 | $statement->execute([ |
209 | 209 | ':start' => $start, |
210 | 210 | ':end' => $end, |
211 | 211 | ':country' => $country |
212 | - ]) ; |
|
212 | + ]); |
|
213 | 213 | } catch (\PDOException $th) { |
214 | - trigger_error('Statement failed: ' . $th->getMessage(), E_USER_ERROR); |
|
214 | + trigger_error('Statement failed: '.$th->getMessage(), E_USER_ERROR); |
|
215 | 215 | } |
216 | 216 | } |
217 | 217 | /** |
@@ -221,7 +221,7 @@ discard block |
||
221 | 221 | */ |
222 | 222 | public function beginTransaction() |
223 | 223 | { |
224 | - if (!$this->transactionCounter++) {return $this->oPDOInstance->beginTransaction();} |
|
224 | + if (!$this->transactionCounter++) {return $this->oPDOInstance->beginTransaction(); } |
|
225 | 225 | return $this->transactionCounter >= 0; |
226 | 226 | } |
227 | 227 | /** |
@@ -231,7 +231,7 @@ discard block |
||
231 | 231 | */ |
232 | 232 | public function commit() |
233 | 233 | { |
234 | - if (!--$this->transactionCounter) {return $this->oPDOInstance->commit();} |
|
234 | + if (!--$this->transactionCounter) {return $this->oPDOInstance->commit(); } |
|
235 | 235 | return $this->transactionCounter >= 0; |
236 | 236 | } |
237 | 237 | /** |