@@ -56,13 +56,11 @@ |
||
56 | 56 | try |
57 | 57 | { |
58 | 58 | $text = $http->getStatusText(65431); |
59 | - } |
|
60 | - catch (\Exception $e) |
|
59 | + } catch (\Exception $e) |
|
61 | 60 | { |
62 | 61 | $errorObject = ($e instanceof \RuntimeException); |
63 | 62 | $message = $e->getMessage(); |
64 | - } |
|
65 | - finally |
|
63 | + } finally |
|
66 | 64 | { |
67 | 65 | $this->assertTrue($errorObject, $message); |
68 | 66 | } |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | break; |
95 | 95 | |
96 | 96 | case self::LAST_YEAR: |
97 | - $year = ((int) date('Y'))- 1; |
|
97 | + $year = ((int) date('Y')) - 1; |
|
98 | 98 | break; |
99 | 99 | |
100 | 100 | default: |
@@ -142,7 +142,7 @@ discard block |
||
142 | 142 | $d->setDate($year, (int) $d->format('m'), (int) $d->format('d')); |
143 | 143 | } |
144 | 144 | |
145 | - $d->add(new \DateInterval('P'.($day - 1).'D')); |
|
145 | + $d->add(new \DateInterval('P' . ($day - 1) . 'D')); |
|
146 | 146 | } |
147 | 147 | |
148 | 148 | return $d; |
@@ -63,8 +63,9 @@ discard block |
||
63 | 63 | */ |
64 | 64 | public static function getMonth($month_number) |
65 | 65 | { |
66 | - if (!array_key_exists($month_number, self::MONTHS)) |
|
67 | - throw new Exception\MonthOutOfRange("Invalid Month"); |
|
66 | + if (!array_key_exists($month_number, self::MONTHS)) { |
|
67 | + throw new Exception\MonthOutOfRange("Invalid Month"); |
|
68 | + } |
|
68 | 69 | |
69 | 70 | return self::MONTHS[$month_number]; |
70 | 71 | } |
@@ -78,14 +79,17 @@ discard block |
||
78 | 79 | */ |
79 | 80 | public static function create(array $date = []) |
80 | 81 | { |
81 | - if (!array_key_exists('day', $date)) |
|
82 | - $date["day"] = self::TODAY; |
|
82 | + if (!array_key_exists('day', $date)) { |
|
83 | + $date["day"] = self::TODAY; |
|
84 | + } |
|
83 | 85 | |
84 | - if (!array_key_exists('month', $date)) |
|
85 | - $date["month"] = self::THIS_MONTH; |
|
86 | + if (!array_key_exists('month', $date)) { |
|
87 | + $date["month"] = self::THIS_MONTH; |
|
88 | + } |
|
86 | 89 | |
87 | - if (!array_key_exists('year', $date)) |
|
88 | - $date["year"] = self::THIS_YEAR; |
|
90 | + if (!array_key_exists('year', $date)) { |
|
91 | + $date["year"] = self::THIS_YEAR; |
|
92 | + } |
|
89 | 93 | |
90 | 94 | switch ($date['year']) |
91 | 95 | { |
@@ -130,13 +134,13 @@ discard block |
||
130 | 134 | break; |
131 | 135 | } |
132 | 136 | |
133 | - if (is_string($day)) |
|
134 | - $d = new \DateTime("$day $month $year"); |
|
135 | - else |
|
137 | + if (is_string($day)) { |
|
138 | + $d = new \DateTime("$day $month $year"); |
|
139 | + } else |
|
136 | 140 | { |
137 | - if (in_array($month, self::MONTHS)) |
|
138 | - $d = new \DateTime("first day of $month $year"); |
|
139 | - else |
|
141 | + if (in_array($month, self::MONTHS)) { |
|
142 | + $d = new \DateTime("first day of $month $year"); |
|
143 | + } else |
|
140 | 144 | { |
141 | 145 | $d = new \DateTime("first day of $month"); |
142 | 146 | $d->setDate($year, (int) $d->format('m'), (int) $d->format('d')); |
@@ -126,7 +126,7 @@ |
||
126 | 126 | public function getContentsFromUrl($filename) |
127 | 127 | { |
128 | 128 | $headers = get_headers($url); |
129 | - $exists = stripos($headers[0],"200 OK") ? true : false; |
|
129 | + $exists = stripos($headers[0], "200 OK") ? true : false; |
|
130 | 130 | |
131 | 131 | if ($exists) |
132 | 132 | return file_get_contents($filename); |
@@ -90,13 +90,11 @@ discard block |
||
90 | 90 | try |
91 | 91 | { |
92 | 92 | $ctrl->addNonExistingError(); |
93 | - } |
|
94 | - catch (\Exception $e) |
|
93 | + } catch (\Exception $e) |
|
95 | 94 | { |
96 | 95 | $errorObject = ($e instanceof \LogicException); |
97 | 96 | $message = $e->getMessage(); |
98 | - } |
|
99 | - finally |
|
97 | + } finally |
|
100 | 98 | { |
101 | 99 | $this->assertTrue($errorObject, $message); |
102 | 100 | } |
@@ -109,18 +107,20 @@ discard block |
||
109 | 107 | |
110 | 108 | public function getContentsFromFile($filename) |
111 | 109 | { |
112 | - if (file_exists($filename)) |
|
113 | - return file_get_contents($filename); |
|
114 | - else |
|
115 | - $this->error(Errno::FILE_NOT_FOUND, $filename); |
|
110 | + if (file_exists($filename)) { |
|
111 | + return file_get_contents($filename); |
|
112 | + } else { |
|
113 | + $this->error(Errno::FILE_NOT_FOUND, $filename); |
|
114 | + } |
|
116 | 115 | } |
117 | 116 | |
118 | 117 | public function getContentsFromFileWithoutFilenameOnError($filename) |
119 | 118 | { |
120 | - if (file_exists($filename)) |
|
121 | - return file_get_contents($filename); |
|
122 | - else |
|
123 | - $this->error(Errno::FILE_NOT_FOUND); |
|
119 | + if (file_exists($filename)) { |
|
120 | + return file_get_contents($filename); |
|
121 | + } else { |
|
122 | + $this->error(Errno::FILE_NOT_FOUND); |
|
123 | + } |
|
124 | 124 | } |
125 | 125 | |
126 | 126 | public function getContentsFromUrl($filename) |
@@ -128,10 +128,11 @@ discard block |
||
128 | 128 | $headers = get_headers($url); |
129 | 129 | $exists = stripos($headers[0],"200 OK") ? true : false; |
130 | 130 | |
131 | - if ($exists) |
|
132 | - return file_get_contents($filename); |
|
133 | - else |
|
134 | - $this->error("URL not found"); |
|
131 | + if ($exists) { |
|
132 | + return file_get_contents($filename); |
|
133 | + } else { |
|
134 | + $this->error("URL not found"); |
|
135 | + } |
|
135 | 136 | } |
136 | 137 | |
137 | 138 | public function addNonExistingError() |
@@ -39,13 +39,11 @@ |
||
39 | 39 | try |
40 | 40 | { |
41 | 41 | $this->assertEquals('June', Dt::getMonth(13)); |
42 | - } |
|
43 | - catch (\Exception $e) |
|
42 | + } catch (\Exception $e) |
|
44 | 43 | { |
45 | 44 | $errorObject = ($e instanceof MonthOutOfRange); |
46 | 45 | $message = $e->getMessage(); |
47 | - } |
|
48 | - finally |
|
46 | + } finally |
|
49 | 47 | { |
50 | 48 | $this->assertTrue($errorObject, $message); |
51 | 49 | } |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | public function testCannotStablishConnectionWhenExists() |
69 | 69 | { |
70 | 70 | $options = $this->options; |
71 | - $options["dbhost"] = 'myserver'; // this server does not exists |
|
71 | + $options["dbhost"] = 'myserver'; // this server does not exists |
|
72 | 72 | |
73 | 73 | $errorObject = null; |
74 | 74 | |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | public function testCannotStablishConnection() |
99 | 99 | { |
100 | 100 | $options = $this->options; |
101 | - $options["dbhost"] = 'myserver'; // this server does not exists |
|
101 | + $options["dbhost"] = 'myserver'; // this server does not exists |
|
102 | 102 | |
103 | 103 | $entity = new MyEntity(); |
104 | 104 | $gateway = new TableGateway($entity, ["other" => $options]); |
@@ -78,13 +78,11 @@ discard block |
||
78 | 78 | { |
79 | 79 | $entity = new MyEntity(); |
80 | 80 | $gateway = new TableGateway($entity, ["default" => $options]); |
81 | - } |
|
82 | - catch (\Exception $e) |
|
81 | + } catch (\Exception $e) |
|
83 | 82 | { |
84 | 83 | $errorObject = ($e instanceof \RuntimeException); |
85 | 84 | $message = $e->getMessage(); |
86 | - } |
|
87 | - finally |
|
85 | + } finally |
|
88 | 86 | { |
89 | 87 | $this->assertTrue($errorObject, $message); |
90 | 88 | } |
@@ -110,13 +108,11 @@ discard block |
||
110 | 108 | try |
111 | 109 | { |
112 | 110 | $gateway->getDb()->connect(); |
113 | - } |
|
114 | - catch (\Exception $e) |
|
111 | + } catch (\Exception $e) |
|
115 | 112 | { |
116 | 113 | $errorObject = ($e instanceof ConnectionException); |
117 | 114 | $message = $e->getMessage(); |
118 | - } |
|
119 | - finally |
|
115 | + } finally |
|
120 | 116 | { |
121 | 117 | $this->assertTrue($errorObject, $message); |
122 | 118 | $this->assertNotTrue($gateway->getDb()->isConnected()); |
@@ -145,13 +141,11 @@ discard block |
||
145 | 141 | try |
146 | 142 | { |
147 | 143 | AbstractTableGateway::getDriver('other3'); |
148 | - } |
|
149 | - catch (\Exception $e) |
|
144 | + } catch (\Exception $e) |
|
150 | 145 | { |
151 | 146 | $errorObject = ($e instanceof \RuntimeException); |
152 | 147 | $message = $e->getMessage(); |
153 | - } |
|
154 | - finally |
|
148 | + } finally |
|
155 | 149 | { |
156 | 150 | $this->assertTrue($errorObject, $message); |
157 | 151 | } |
@@ -250,13 +244,11 @@ discard block |
||
250 | 244 | try |
251 | 245 | { |
252 | 246 | $gateway->wrongDML(); |
253 | - } |
|
254 | - catch (\Exception $e) |
|
247 | + } catch (\Exception $e) |
|
255 | 248 | { |
256 | 249 | $errorObject = ($e instanceof InvalidQueryException); |
257 | 250 | $message = $e->getMessage(); |
258 | - } |
|
259 | - finally |
|
251 | + } finally |
|
260 | 252 | { |
261 | 253 | $this->assertTrue($errorObject, $message); |
262 | 254 | } |
@@ -440,7 +440,7 @@ |
||
440 | 440 | { |
441 | 441 | parent::__construct($data); |
442 | 442 | $this->setTableName("MYTABLE"); |
443 | - } |
|
443 | + } |
|
444 | 444 | } |
445 | 445 | |
446 | 446 | class MyEntityGateway extends TableGateway |
@@ -87,24 +87,25 @@ discard block |
||
87 | 87 | { |
88 | 88 | $this->currentConnection = $connection; |
89 | 89 | $this->getDriver($connection); |
90 | - } |
|
91 | - else if (is_array($connection)) |
|
90 | + } else if (is_array($connection)) |
|
92 | 91 | { |
93 | 92 | $identifier = key($connection); |
94 | 93 | $connection_options = $connection[$identifier]; |
95 | 94 | |
96 | 95 | $this->currentConnection = $identifier; |
97 | 96 | |
98 | - if (!array_key_exists('driver', $connection_options)) |
|
99 | - throw new \RuntimeException("The database driver key has not been declared"); |
|
100 | - |
|
101 | - if (!isset(self::$drivers[$identifier])) |
|
102 | - self::$drivers[$identifier] = DriverFactory::create($connection_options); |
|
103 | - else |
|
104 | - throw new \RuntimeException("The database connection already exists"); |
|
97 | + if (!array_key_exists('driver', $connection_options)) { |
|
98 | + throw new \RuntimeException("The database driver key has not been declared"); |
|
99 | + } |
|
100 | + |
|
101 | + if (!isset(self::$drivers[$identifier])) { |
|
102 | + self::$drivers[$identifier] = DriverFactory::create($connection_options); |
|
103 | + } else { |
|
104 | + throw new \RuntimeException("The database connection already exists"); |
|
105 | + } |
|
106 | + } else { |
|
107 | + throw new \InvalidArgumentException("Invalid type given. Array or string expected"); |
|
105 | 108 | } |
106 | - else |
|
107 | - throw new \InvalidArgumentException("Invalid type given. Array or string expected"); |
|
108 | 109 | } |
109 | 110 | |
110 | 111 | /** |
@@ -118,8 +119,9 @@ discard block |
||
118 | 119 | */ |
119 | 120 | public static function getDriver($identifier) |
120 | 121 | { |
121 | - if (!array_key_exists($identifier, self::$drivers)) |
|
122 | - throw new \RuntimeException("The database connection does not exists"); |
|
122 | + if (!array_key_exists($identifier, self::$drivers)) { |
|
123 | + throw new \RuntimeException("The database connection does not exists"); |
|
124 | + } |
|
123 | 125 | |
124 | 126 | return self::$drivers[$identifier]; |
125 | 127 | } |
@@ -135,8 +137,9 @@ discard block |
||
135 | 137 | */ |
136 | 138 | public static function hasDriver($identifier) |
137 | 139 | { |
138 | - if (!array_key_exists($identifier, self::$drivers)) |
|
139 | - return false; |
|
140 | + if (!array_key_exists($identifier, self::$drivers)) { |
|
141 | + return false; |
|
142 | + } |
|
140 | 143 | |
141 | 144 | return true; |
142 | 145 | } |
@@ -34,14 +34,16 @@ |
||
34 | 34 | "Sqlsrv" => "Drone\Db\Driver\SQLServer", |
35 | 35 | ]; |
36 | 36 | |
37 | - if (!array_key_exists('driver', $connection_options)) |
|
38 | - throw new \RuntimeException("The database driver key has not been declared"); |
|
37 | + if (!array_key_exists('driver', $connection_options)) { |
|
38 | + throw new \RuntimeException("The database driver key has not been declared"); |
|
39 | + } |
|
39 | 40 | |
40 | 41 | $drv = $connection_options["driver"]; |
41 | 42 | |
42 | - if (array_key_exists($drv, $drivers)) |
|
43 | - return new $drivers[$drv]($connection_options); |
|
44 | - else |
|
45 | - throw new \RuntimeException("The database driver does not exists"); |
|
43 | + if (array_key_exists($drv, $drivers)) { |
|
44 | + return new $drivers[$drv]($connection_options); |
|
45 | + } else { |
|
46 | + throw new \RuntimeException("The database driver does not exists"); |
|
47 | + } |
|
46 | 48 | } |
47 | 49 | } |
48 | 50 | \ No newline at end of file |
@@ -252,7 +252,7 @@ |
||
252 | 252 | { |
253 | 253 | parent::__construct($data); |
254 | 254 | $this->setTableName("USER"); |
255 | - } |
|
255 | + } |
|
256 | 256 | } |
257 | 257 | |
258 | 258 | class UserGateway extends TableGateway |
@@ -78,11 +78,11 @@ discard block |
||
78 | 78 | { |
79 | 79 | $k++; |
80 | 80 | |
81 | - if (is_null($value)) |
|
82 | - $parsed_where[] = "$key IS NULL"; |
|
83 | - elseif ($value instanceof SQLFunction) |
|
84 | - $parsed_where[] = "$key = " . $value->getStatement(); |
|
85 | - elseif (is_array($value)) |
|
81 | + if (is_null($value)) { |
|
82 | + $parsed_where[] = "$key IS NULL"; |
|
83 | + } elseif ($value instanceof SQLFunction) { |
|
84 | + $parsed_where[] = "$key = " . $value->getStatement(); |
|
85 | + } elseif (is_array($value)) |
|
86 | 86 | { |
87 | 87 | $parsed_in = []; |
88 | 88 | |
@@ -105,8 +105,7 @@ discard block |
||
105 | 105 | } |
106 | 106 | |
107 | 107 | $parsed_where[] = "$key IN (" . implode(", ", $parsed_in) . ")"; |
108 | - } |
|
109 | - else |
|
108 | + } else |
|
110 | 109 | { |
111 | 110 | switch ($driver) |
112 | 111 | { |
@@ -124,9 +123,9 @@ discard block |
||
124 | 123 | } |
125 | 124 | |
126 | 125 | $where = "WHERE \r\n\t" . implode(" AND\r\n\t", $parsed_where); |
126 | + } else { |
|
127 | + $where = ""; |
|
127 | 128 | } |
128 | - else |
|
129 | - $where = ""; |
|
130 | 129 | |
131 | 130 | $table = $this->entity->getTableName(); |
132 | 131 | |
@@ -135,10 +134,11 @@ discard block |
||
135 | 134 | $this->lastQuery = $sql; |
136 | 135 | $this->lastValues = $bind_values; |
137 | 136 | |
138 | - if (count($bind_values)) |
|
139 | - $this->getDb()->execute($sql, $bind_values); |
|
140 | - else |
|
141 | - $this->getDb()->execute($sql); |
|
137 | + if (count($bind_values)) { |
|
138 | + $this->getDb()->execute($sql, $bind_values); |
|
139 | + } else { |
|
140 | + $this->getDb()->execute($sql); |
|
141 | + } |
|
142 | 142 | |
143 | 143 | return $this->getDb()->getArrayResult(); |
144 | 144 | } |
@@ -155,8 +155,9 @@ discard block |
||
155 | 155 | */ |
156 | 156 | public function insert(Array $data) |
157 | 157 | { |
158 | - if (!count($data)) |
|
159 | - throw new \LogicException("Missing values for INSERT statement!"); |
|
158 | + if (!count($data)) { |
|
159 | + throw new \LogicException("Missing values for INSERT statement!"); |
|
160 | + } |
|
160 | 161 | |
161 | 162 | $bind_values = []; |
162 | 163 | |
@@ -179,11 +180,11 @@ discard block |
||
179 | 180 | continue; |
180 | 181 | } |
181 | 182 | |
182 | - if (is_null($value)) |
|
183 | - $value = "NULL"; |
|
184 | - elseif ($value instanceof SQLFunction) |
|
185 | - $value = $value->getStatement(); |
|
186 | - else { |
|
183 | + if (is_null($value)) { |
|
184 | + $value = "NULL"; |
|
185 | + } elseif ($value instanceof SQLFunction) { |
|
186 | + $value = $value->getStatement(); |
|
187 | + } else { |
|
187 | 188 | |
188 | 189 | switch ($driver) |
189 | 190 | { |
@@ -236,11 +237,13 @@ discard block |
||
236 | 237 | { |
237 | 238 | $parsed_set = []; |
238 | 239 | |
239 | - if (!count($set)) |
|
240 | - throw new \LogicException("You cannot update rows without SET clause"); |
|
240 | + if (!count($set)) { |
|
241 | + throw new \LogicException("You cannot update rows without SET clause"); |
|
242 | + } |
|
241 | 243 | |
242 | - if (!count($where)) |
|
243 | - throw new SecurityException("You cannot update rows without WHERE clause!"); |
|
244 | + if (!count($where)) { |
|
245 | + throw new SecurityException("You cannot update rows without WHERE clause!"); |
|
246 | + } |
|
244 | 247 | |
245 | 248 | $bind_values = []; |
246 | 249 | |
@@ -252,11 +255,11 @@ discard block |
||
252 | 255 | { |
253 | 256 | $k++; |
254 | 257 | |
255 | - if (is_null($value)) |
|
256 | - $parsed_set[] = "$key = NULL"; |
|
257 | - elseif ($value instanceof SQLFunction) |
|
258 | - $parsed_set[] = "$key = " . $value->getStatement(); |
|
259 | - elseif (is_array($value)) |
|
258 | + if (is_null($value)) { |
|
259 | + $parsed_set[] = "$key = NULL"; |
|
260 | + } elseif ($value instanceof SQLFunction) { |
|
261 | + $parsed_set[] = "$key = " . $value->getStatement(); |
|
262 | + } elseif (is_array($value)) |
|
260 | 263 | { |
261 | 264 | $parsed_in = []; |
262 | 265 | |
@@ -267,8 +270,9 @@ discard block |
||
267 | 270 | case 'Oci8': |
268 | 271 | |
269 | 272 | # [POSSIBLE BUG] - To Future revision (What about non-string values ?) |
270 | - if (is_string($in_value)) |
|
271 | - $parsed_in[] = ":$k"; |
|
273 | + if (is_string($in_value)) { |
|
274 | + $parsed_in[] = ":$k"; |
|
275 | + } |
|
272 | 276 | |
273 | 277 | $bind_values[":$k"] = $in_value; |
274 | 278 | break; |
@@ -283,8 +287,7 @@ discard block |
||
283 | 287 | } |
284 | 288 | |
285 | 289 | $parsed_set[] = "$key IN (" . implode(", ", $parsed_in) . ")"; |
286 | - } |
|
287 | - else |
|
290 | + } else |
|
288 | 291 | { |
289 | 292 | switch ($driver) |
290 | 293 | { |
@@ -309,11 +312,11 @@ discard block |
||
309 | 312 | { |
310 | 313 | $k++; |
311 | 314 | |
312 | - if (is_null($value)) |
|
313 | - $parsed_where[] = "$key IS NULL"; |
|
314 | - elseif ($value instanceof SQLFunction) |
|
315 | - $parsed_where[] = "$key = " . $value->getStatement(); |
|
316 | - elseif (is_array($value)) |
|
315 | + if (is_null($value)) { |
|
316 | + $parsed_where[] = "$key IS NULL"; |
|
317 | + } elseif ($value instanceof SQLFunction) { |
|
318 | + $parsed_where[] = "$key = " . $value->getStatement(); |
|
319 | + } elseif (is_array($value)) |
|
317 | 320 | { |
318 | 321 | $parsed_in = []; |
319 | 322 | |
@@ -336,8 +339,7 @@ discard block |
||
336 | 339 | } |
337 | 340 | |
338 | 341 | $parsed_where[] = "$key IN (" . implode(", ", $parsed_in) . ")"; |
339 | - } |
|
340 | - else |
|
342 | + } else |
|
341 | 343 | { |
342 | 344 | switch ($driver) |
343 | 345 | { |
@@ -392,11 +394,11 @@ discard block |
||
392 | 394 | { |
393 | 395 | $k++; |
394 | 396 | |
395 | - if (is_null($value)) |
|
396 | - $parsed_where[] = "$key IS NULL"; |
|
397 | - elseif ($value instanceof SQLFunction) |
|
398 | - $parsed_where[] = "$key = " . $value->getStatement(); |
|
399 | - elseif (is_array($value)) |
|
397 | + if (is_null($value)) { |
|
398 | + $parsed_where[] = "$key IS NULL"; |
|
399 | + } elseif ($value instanceof SQLFunction) { |
|
400 | + $parsed_where[] = "$key = " . $value->getStatement(); |
|
401 | + } elseif (is_array($value)) |
|
400 | 402 | { |
401 | 403 | $parsed_in = []; |
402 | 404 | |
@@ -419,8 +421,7 @@ discard block |
||
419 | 421 | } |
420 | 422 | |
421 | 423 | $parsed_where[] = "$key IN (" . implode(", ", $parsed_in) . ")"; |
422 | - } |
|
423 | - else |
|
424 | + } else |
|
424 | 425 | { |
425 | 426 | switch ($driver) |
426 | 427 | { |
@@ -438,9 +439,9 @@ discard block |
||
438 | 439 | } |
439 | 440 | |
440 | 441 | $where = "\r\nWHERE \r\n\t" . implode(" AND\r\n\t", $parsed_where); |
442 | + } else { |
|
443 | + throw new SecurityException("You cannot delete rows without WHERE clause!. Use TRUNCATE statement instead."); |
|
441 | 444 | } |
442 | - else |
|
443 | - throw new SecurityException("You cannot delete rows without WHERE clause!. Use TRUNCATE statement instead."); |
|
444 | 445 | |
445 | 446 | $table = $this->entity->getTableName(); |
446 | 447 |