@@ -27,8 +27,8 @@ |
||
27 | 27 | * @return DBExprFilter |
28 | 28 | */ |
29 | 29 | public function __invoke($expression, $keyPath, $validator = null) { |
30 | - return new DBExprFilter($expression, $this->map, $keyPath, $validator, function ($result, array $data) { |
|
31 | - if(!$result) { |
|
30 | + return new DBExprFilter($expression, $this->map, $keyPath, $validator, function($result, array $data) { |
|
31 | + if (!$result) { |
|
32 | 32 | throw new RequiredValueNotFoundException(sprintf("Required value %s not found", $data['key'])); |
33 | 33 | } |
34 | 34 | }); |
@@ -28,16 +28,16 @@ discard block |
||
28 | 28 | $this->value = $data; |
29 | 29 | $this->keyPath = $this->buildKey($keyPath); |
30 | 30 | $this->value = $this->recursiveGet($data, $this->keyPath, null); |
31 | - if($validator === null) { |
|
32 | - $validator = function ($data) { |
|
33 | - if(is_array($data)) { |
|
31 | + if ($validator === null) { |
|
32 | + $validator = function($data) { |
|
33 | + if (is_array($data)) { |
|
34 | 34 | return $this->isValidArray($data); |
35 | 35 | } |
36 | 36 | return (string) $data !== ''; |
37 | 37 | }; |
38 | 38 | } |
39 | - if($validationResultHandler === null) { |
|
40 | - $validationResultHandler = function () {}; |
|
39 | + if ($validationResultHandler === null) { |
|
40 | + $validationResultHandler = function() {}; |
|
41 | 41 | } |
42 | 42 | $this->validator = $validator; |
43 | 43 | $this->validationResultHandler = $validationResultHandler; |
@@ -75,10 +75,10 @@ discard block |
||
75 | 75 | * @throws Exception |
76 | 76 | */ |
77 | 77 | private function buildKey($keyPath) { |
78 | - if(is_string($keyPath)) { |
|
78 | + if (is_string($keyPath)) { |
|
79 | 79 | $keyPath = explode('.', $keyPath); |
80 | 80 | } |
81 | - if(!is_array($keyPath)) { |
|
81 | + if (!is_array($keyPath)) { |
|
82 | 82 | throw new Exception('Invalid key'); |
83 | 83 | } |
84 | 84 | return $keyPath; |
@@ -89,8 +89,8 @@ discard block |
||
89 | 89 | * @return bool |
90 | 90 | */ |
91 | 91 | private function isValidArray(array $array) { |
92 | - $data = array_filter($array, function ($value) { |
|
93 | - if(is_array($value)) { |
|
92 | + $data = array_filter($array, function($value) { |
|
93 | + if (is_array($value)) { |
|
94 | 94 | return $this->isValidArray($value); |
95 | 95 | } |
96 | 96 | return (string) $value !== ''; |
@@ -109,9 +109,9 @@ discard block |
||
109 | 109 | if (!$count) { |
110 | 110 | return $default; |
111 | 111 | } |
112 | - for($idx = 0; $idx < $count; $idx++) { |
|
112 | + for ($idx = 0; $idx < $count; $idx++) { |
|
113 | 113 | $part = $path[$idx]; |
114 | - if(!array_key_exists($part, $array)) { |
|
114 | + if (!array_key_exists($part, $array)) { |
|
115 | 115 | return $default; |
116 | 116 | } |
117 | 117 | $array = $array[$part]; |
@@ -74,7 +74,7 @@ |
||
74 | 74 | } |
75 | 75 | |
76 | 76 | /** |
77 | - * @return mixed |
|
77 | + * @return integer |
|
78 | 78 | */ |
79 | 79 | public function key() { |
80 | 80 | return $this->idx; |
@@ -42,16 +42,16 @@ discard block |
||
42 | 42 | */ |
43 | 43 | public function current() { |
44 | 44 | $row = $this->currentItem; |
45 | - if($this->preserveTypes) { |
|
45 | + if ($this->preserveTypes) { |
|
46 | 46 | $columnDefinitions = FieldTypeProvider::getFieldTypes($this->getStmt()); |
47 | 47 | $row = FieldValueConverter::convertValues($row, $columnDefinitions); |
48 | 48 | } |
49 | 49 | $callback = $this->callback; |
50 | - if($callback !== null) { |
|
50 | + if ($callback !== null) { |
|
51 | 51 | $result = $callback($row); |
52 | - if($result instanceof DBIgnoreRow) { |
|
52 | + if ($result instanceof DBIgnoreRow) { |
|
53 | 53 | // Do nothing in this case |
54 | - } elseif($result !== null) { |
|
54 | + } elseif ($result !== null) { |
|
55 | 55 | return $result; |
56 | 56 | } else { |
57 | 57 | return $row; |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | */ |
80 | 80 | public function valid() { |
81 | 81 | $result = !!$this->currentItem; |
82 | - if(!$result) { |
|
82 | + if (!$result) { |
|
83 | 83 | $this->closeCursor(); |
84 | 84 | } |
85 | 85 | return $result; |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | /** |
89 | 89 | */ |
90 | 90 | public function rewind() { |
91 | - if($this->stmt !== null) { |
|
91 | + if ($this->stmt !== null) { |
|
92 | 92 | throw new RuntimeException("It's not possible to rewind this iterator"); |
93 | 93 | } |
94 | 94 | $this->stmt = call_user_func($this->statementFactory); |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | * @return QueryStatement |
101 | 101 | */ |
102 | 102 | private function getStmt() { |
103 | - if($this->stmt === null) { |
|
103 | + if ($this->stmt === null) { |
|
104 | 104 | $this->rewind(); |
105 | 105 | } |
106 | 106 | return $this->stmt; |
@@ -109,7 +109,7 @@ discard block |
||
109 | 109 | /** |
110 | 110 | */ |
111 | 111 | private function closeCursor() { |
112 | - if($this->stmt instanceof QueryStatement) { |
|
112 | + if ($this->stmt instanceof QueryStatement) { |
|
113 | 113 | $this->stmt->closeCursor(); |
114 | 114 | } |
115 | 115 | $this->stmt = null; |
@@ -78,7 +78,7 @@ |
||
78 | 78 | } |
79 | 79 | |
80 | 80 | /** |
81 | - * @return array |
|
81 | + * @return string[] |
|
82 | 82 | */ |
83 | 83 | public function getFields() { |
84 | 84 | return $this->fields; |
@@ -28,10 +28,10 @@ |
||
28 | 28 | */ |
29 | 29 | protected function buildLimit($query, $offset = null) { |
30 | 30 | $limit = $this->limit; |
31 | - if($limit === null && $offset !== null) { |
|
31 | + if ($limit === null && $offset !== null) { |
|
32 | 32 | $limit = '18446744073709551615'; |
33 | 33 | } |
34 | - if($limit !== null) { |
|
34 | + if ($limit !== null) { |
|
35 | 35 | $query .= "LIMIT\n\t{$limit}\n"; |
36 | 36 | } |
37 | 37 | return $query; |
@@ -21,16 +21,16 @@ |
||
21 | 21 | * @return array[]|\Generator |
22 | 22 | */ |
23 | 23 | public function generate(QueryStatement $statement, Closure $callback = null) { |
24 | - while($row = $statement->fetch()) { |
|
25 | - if($this->preserveTypes) { |
|
24 | + while ($row = $statement->fetch()) { |
|
25 | + if ($this->preserveTypes) { |
|
26 | 26 | $columnDefinitions = FieldTypeProvider::getFieldTypes($statement); |
27 | 27 | $row = FieldValueConverter::convertValues($row, $columnDefinitions); |
28 | 28 | } |
29 | - if($callback !== null) { |
|
29 | + if ($callback !== null) { |
|
30 | 30 | $result = $callback($row); |
31 | - if($result instanceof DBIgnoreRow) { |
|
31 | + if ($result instanceof DBIgnoreRow) { |
|
32 | 32 | // Do nothing in this case |
33 | - } elseif($result !== null) { |
|
33 | + } elseif ($result !== null) { |
|
34 | 34 | yield $result; |
35 | 35 | } else { |
36 | 36 | yield $row; |
@@ -46,12 +46,12 @@ discard block |
||
46 | 46 | * @return $this |
47 | 47 | */ |
48 | 48 | public function setFetchMode($mode, $arg0 = null, array $arg1 = null) { |
49 | - if($arg1 !== null) { |
|
49 | + if ($arg1 !== null) { |
|
50 | 50 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
51 | 51 | $this->statement->setFetchMode($mode, $arg0, $arg1); |
52 | 52 | return $this; |
53 | 53 | } |
54 | - if($arg0 !== null) { |
|
54 | + if ($arg0 !== null) { |
|
55 | 55 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
56 | 56 | $this->statement->setFetchMode($mode, $arg0); |
57 | 57 | return $this; |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | $timer = microtime(true); |
71 | 71 | $response = $this->statement->execute($params); |
72 | 72 | $this->queryLoggers->log($this->query, microtime(true)-$timer); |
73 | - if(!$response) { |
|
73 | + if (!$response) { |
|
74 | 74 | throw new SqlException('Execution returned with "false".'); |
75 | 75 | } |
76 | 76 | }); |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | */ |
86 | 86 | public function fetchAll($fetchStyle = null, $fetchArgument = null, array $ctorArgs = []) { |
87 | 87 | return $this->exceptionHandler(function() use ($fetchStyle, $fetchArgument, $ctorArgs) { |
88 | - if($fetchArgument !== null) { |
|
88 | + if ($fetchArgument !== null) { |
|
89 | 89 | return $this->statement->fetchAll($fetchStyle, $fetchArgument, $ctorArgs); |
90 | 90 | } |
91 | 91 | return $this->statement->fetchAll($fetchStyle); |
@@ -12,28 +12,28 @@ |
||
12 | 12 | * @return string |
13 | 13 | */ |
14 | 14 | protected function buildTableName($alias, $name) { |
15 | - if(is_object($name)) { |
|
15 | + if (is_object($name)) { |
|
16 | 16 | $name = (string) $name; |
17 | 17 | $lines = explode("\n", $name); |
18 | - foreach($lines as &$line) { |
|
18 | + foreach ($lines as &$line) { |
|
19 | 19 | $line = "\t{$line}"; |
20 | 20 | } |
21 | 21 | $name = join("\n", $lines); |
22 | - $name = '(' . trim(rtrim(trim($name), ';')) . ')'; |
|
22 | + $name = '('.trim(rtrim(trim($name), ';')).')'; |
|
23 | 23 | } |
24 | - if(is_array($name)) { |
|
24 | + if (is_array($name)) { |
|
25 | 25 | $parts = []; |
26 | - foreach($name as $bucket) { |
|
26 | + foreach ($name as $bucket) { |
|
27 | 27 | $values = []; |
28 | - foreach($bucket as $field => $value) { |
|
28 | + foreach ($bucket as $field => $value) { |
|
29 | 29 | $values[] = sprintf('%s AS %s', $this->db()->quote($value), $this->db()->quoteField($field)); |
30 | 30 | } |
31 | 31 | $parts[] = sprintf("SELECT %s", join(', ', $values)); |
32 | 32 | } |
33 | - $name = '(' . join("\n\tUNION\n\t", $parts) . ')'; |
|
33 | + $name = '('.join("\n\tUNION\n\t", $parts).')'; |
|
34 | 34 | } |
35 | 35 | $name = $this->aliasReplacer()->replace($name); |
36 | - if($alias !== null) { |
|
36 | + if ($alias !== null) { |
|
37 | 37 | return sprintf("%s %s", $name, $alias); |
38 | 38 | } |
39 | 39 | return $name; |
@@ -15,8 +15,8 @@ discard block |
||
15 | 15 | * @return $this |
16 | 16 | */ |
17 | 17 | public function orderBy($expression, $direction = 'asc') { |
18 | - if($expression instanceof OrderBySpecification) { |
|
19 | - foreach($expression->getFields() as $field) { |
|
18 | + if ($expression instanceof OrderBySpecification) { |
|
19 | + foreach ($expression->getFields() as $field) { |
|
20 | 20 | $this->addOrder($field[0], $field[1]); |
21 | 21 | } |
22 | 22 | return $this; |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | */ |
33 | 33 | public function orderByValues($fieldName, array $values) { |
34 | 34 | $expr = []; |
35 | - foreach(array_values($values) as $idx => $value) { |
|
35 | + foreach (array_values($values) as $idx => $value) { |
|
36 | 36 | $expr[] = $this->db()->quoteExpression("WHEN ? THEN ?", array($value, $idx)); |
37 | 37 | } |
38 | 38 | $this->orderBy[] = array(sprintf("CASE %s\n\t\t%s\n\tEND", $this->db()->quoteField($fieldName), join("\n\t\t", $expr)), 'ASC'); |
@@ -44,12 +44,12 @@ discard block |
||
44 | 44 | * @return string |
45 | 45 | */ |
46 | 46 | protected function buildOrder($query) { |
47 | - if(!count($this->orderBy)) { |
|
47 | + if (!count($this->orderBy)) { |
|
48 | 48 | return $query; |
49 | 49 | } |
50 | 50 | $query .= "ORDER BY\n"; |
51 | 51 | $arr = array(); |
52 | - foreach($this->orderBy as $order) { |
|
52 | + foreach ($this->orderBy as $order) { |
|
53 | 53 | list($expression, $direction) = $order; |
54 | 54 | $arr[] = sprintf("\t%s %s", $expression, strtoupper($direction)); |
55 | 55 | } |
@@ -62,8 +62,8 @@ discard block |
||
62 | 62 | */ |
63 | 63 | private function addOrder($expression, $direction) { |
64 | 64 | $direction = $this->fixDirection($direction); |
65 | - if(is_array($expression)) { |
|
66 | - if(!count($expression)) { |
|
65 | + if (is_array($expression)) { |
|
66 | + if (!count($expression)) { |
|
67 | 67 | return; |
68 | 68 | } |
69 | 69 | $arguments = array( |