Passed
Push — master ( 094b5b...ea377a )
by Alfred
03:51 queued 01:55
created
src/bin/GeoipDatabase.php 1 patch
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -3,7 +3,7 @@  discard block
 block discarded – undo
3 3
 namespace geolocation\bin;
4 4
 
5 5
 use \PDO;
6
-use \SplFileInfo ;
6
+use \SplFileInfo;
7 7
 use \Throwable;
8 8
 
9 9
 class GeoipDatabase
@@ -86,7 +86,7 @@  discard block
 block discarded – undo
86 86
      */
87 87
     private function genDsn(string $database = null)
88 88
     {
89
-        $database || $database='Geoip.db.sqlite';
89
+        $database || $database = 'Geoip.db.sqlite';
90 90
         try {
91 91
             $destination = rtrim(dirname(__DIR__), self::DS);
92 92
             if (!is_writeable($destination))
@@ -94,15 +94,15 @@  discard block
 block discarded – undo
94 94
                 throw new Throwable(sprintf('The required destination path is not writable: `%s`', $destination));
95 95
             }
96 96
             $info = new SplFileInfo($database);
97
-            $dbName= $info->getFilename();
98
-            $dbSuffix='.sqlite';
99
-            if (substr_compare(strtolower($dbName), $dbSuffix, -strlen($dbSuffix)) !== 0) { $dbName .= $dbSuffix ; }
97
+            $dbName = $info->getFilename();
98
+            $dbSuffix = '.sqlite';
99
+            if (substr_compare(strtolower($dbName), $dbSuffix, -strlen($dbSuffix)) !== 0) { $dbName .= $dbSuffix; }
100 100
         } catch (Throwable $th) {
101 101
             trigger_error($th->getMessage(), E_USER_ERROR);
102 102
         }
103 103
         $destination .= self::DS.'data';
104 104
         if (!is_dir($destination)) { mkdir($destination, '0755', true); }
105
-        return 'sqlite:'.realpath($destination).self::DS.$dbName ;
105
+        return 'sqlite:'.realpath($destination).self::DS.$dbName;
106 106
     }
107 107
 
108 108
     /**
@@ -163,16 +163,16 @@  discard block
 block discarded – undo
163 163
             $sCommand .= 'FROM `ipv%dRange` ';
164 164
             $sCommand .= 'WHERE `start` <= :start ';
165 165
             $sCommand .= 'ORDER BY start DESC LIMIT 1';
166
-            $statement = $this->oPDOInstance->prepare(sprintf($sCommand, $ipVersion)) ;
167
-            $statement->execute([':start' => $start ]) ;
168
-            $row = $statement->fetch(PDO::FETCH_OBJ) ;
166
+            $statement = $this->oPDOInstance->prepare(sprintf($sCommand, $ipVersion));
167
+            $statement->execute([':start' => $start]);
168
+            $row = $statement->fetch(PDO::FETCH_OBJ);
169 169
             if (is_bool($row) && $row === false)
170 170
             {
171 171
                 $row = new \stdClass();
172
-                $row->end = 0 ;
172
+                $row->end = 0;
173 173
             }
174
-            if ($row->end < $start || !$row->country) { $row->country = 'ZZ' ; }
175
-            return $row->country ;
174
+            if ($row->end < $start || !$row->country) { $row->country = 'ZZ'; }
175
+            return $row->country;
176 176
         } catch (\PDOException $th) {
177 177
             trigger_error($th->getMessage(), E_USER_ERROR);
178 178
         }
@@ -184,7 +184,7 @@  discard block
 block discarded – undo
184 184
      * @param array $tablesList
185 185
      * @return void
186 186
      */
187
-    public function flush(array $tablesList=[])
187
+    public function flush(array $tablesList = [])
188 188
     {
189 189
         !empty($tablesList) || $tablesList = $this->showTables();
190 190
         is_array($tablesList) || $tablesList = [$tablesList];
@@ -198,7 +198,7 @@  discard block
 block discarded – undo
198 198
                 $this->oPDOInstance->query('VACUUM');
199 199
             endif;
200 200
         } catch (\PDOException $th) {
201
-            trigger_error('Statement failed: ' . $th->getMessage(), E_USER_ERROR);
201
+            trigger_error('Statement failed: '.$th->getMessage(), E_USER_ERROR);
202 202
         }
203 203
     }
204 204
 
@@ -215,17 +215,17 @@  discard block
 block discarded – undo
215 215
     {
216 216
         try
217 217
         {
218
-            $sQuery ='INSERT INTO `ipv%dRange` (`start`, `end`, `country`) values (:start, :end, :country)';
218
+            $sQuery = 'INSERT INTO `ipv%dRange` (`start`, `end`, `country`) values (:start, :end, :country)';
219 219
             $command = sprintf($sQuery, $ipVersion);
220 220
             $statement = $this->oPDOInstance->prepare($command);
221 221
             $statement->execute([
222 222
                 ':start'   => $start,
223 223
                 ':end'     => $end,
224 224
                 ':country' => $country
225
-            ]) ;
225
+            ]);
226 226
             return $this->oPDOInstance->lastInsertId();
227 227
         } catch (\PDOException $th) {
228
-            trigger_error('Statement failed: ' . $th->getMessage(), E_USER_ERROR);
228
+            trigger_error('Statement failed: '.$th->getMessage(), E_USER_ERROR);
229 229
         }
230 230
     }
231 231
     /**
@@ -235,7 +235,7 @@  discard block
 block discarded – undo
235 235
      */
236 236
     public function beginTransaction()
237 237
     {
238
-        if (!$this->transactionCounter++) {return $this->oPDOInstance->beginTransaction();}
238
+        if (!$this->transactionCounter++) {return $this->oPDOInstance->beginTransaction(); }
239 239
         return $this->transactionCounter >= 0;
240 240
     }
241 241
 
@@ -246,7 +246,7 @@  discard block
 block discarded – undo
246 246
      */
247 247
     public function commit()
248 248
     {
249
-        if (!--$this->transactionCounter) {return $this->oPDOInstance->commit();}
249
+        if (!--$this->transactionCounter) {return $this->oPDOInstance->commit(); }
250 250
         return $this->transactionCounter >= 0;
251 251
     }
252 252
 
Please login to merge, or discard this patch.