Passed
Branch master (a007d8)
by Alfred
06:37
created
src/bin/GeoipDatabase.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
     /**
Please login to merge, or discard this patch.