@@ -90,7 +90,7 @@ |
||
90 | 90 | |
91 | 91 | public function begin() : bool |
92 | 92 | { |
93 | - return $this->transaction = true; |
|
93 | + return $this->transaction = true; |
|
94 | 94 | } |
95 | 95 | public function commit() : bool |
96 | 96 | { |
@@ -37,7 +37,7 @@ |
||
37 | 37 | { |
38 | 38 | if ($this->lnk === null) { |
39 | 39 | $this->lnk = new \mysqli( |
40 | - (isset($this->connection['opts']['persist']) && $this->connection['opts']['persist'] ? 'p:' : '') . |
|
40 | + (isset($this->connection['opts']['persist']) && $this->connection['opts']['persist'] ? 'p:' : ''). |
|
41 | 41 | $this->connection['host'], |
42 | 42 | $this->connection['user'], |
43 | 43 | $this->connection['pass'], |
@@ -124,7 +124,7 @@ |
||
124 | 124 | } |
125 | 125 | return $new; |
126 | 126 | }) |
127 | - as $relation |
|
127 | + as $relation |
|
128 | 128 | ) { |
129 | 129 | $relations[$relation['CONSTRAINT_NAME']]['table'] = $relation['TABLE_NAME']; |
130 | 130 | $relations[$relation['CONSTRAINT_NAME']]['keymap'][$primary[(int)$relation['POSITION']-1]] = |
@@ -29,19 +29,19 @@ discard block |
||
29 | 29 | $columns = Collection::from($this |
30 | 30 | ->query( |
31 | 31 | "SELECT * FROM all_tab_cols WHERE table_name = ? AND owner = ? and hidden_column = 'NO'", |
32 | - [ strtoupper($table), $this->name() ] |
|
32 | + [strtoupper($table), $this->name()] |
|
33 | 33 | )) |
34 | - ->map(function ($v) { |
|
34 | + ->map(function($v) { |
|
35 | 35 | $new = []; |
36 | 36 | foreach ($v as $kk => $vv) { |
37 | 37 | $new[strtoupper($kk)] = $vv; |
38 | 38 | } |
39 | 39 | return $new; |
40 | 40 | }) |
41 | - ->mapKey(function ($v) { |
|
41 | + ->mapKey(function($v) { |
|
42 | 42 | return $v['COLUMN_NAME']; |
43 | 43 | }) |
44 | - ->map(function ($v) { |
|
44 | + ->map(function($v) { |
|
45 | 45 | $v['length'] = null; |
46 | 46 | if (!isset($v['DATA_TYPE'])) { |
47 | 47 | return $v; |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | default: |
54 | 54 | if (strpos($type, 'char') !== false && strpos($type, '(') !== false) { |
55 | 55 | // extract length from varchar |
56 | - $v['length'] = (int)explode(')', (explode('(', $type)[1] ?? ''))[0]; |
|
56 | + $v['length'] = (int) explode(')', (explode('(', $type)[1] ?? ''))[0]; |
|
57 | 57 | $v['length'] = $v['length'] > 0 ? $v['length'] : null; |
58 | 58 | } |
59 | 59 | break; |
@@ -69,9 +69,9 @@ discard block |
||
69 | 69 | ->query( |
70 | 70 | "SELECT constraint_name FROM all_constraints |
71 | 71 | WHERE table_name = ? AND constraint_type = ? AND owner = ?", |
72 | - [ strtoupper($table), 'P', $owner ] |
|
72 | + [strtoupper($table), 'P', $owner] |
|
73 | 73 | )) |
74 | - ->map(function ($v) { |
|
74 | + ->map(function($v) { |
|
75 | 75 | $new = []; |
76 | 76 | foreach ($v as $kk => $vv) { |
77 | 77 | $new[strtoupper($kk)] = $vv; |
@@ -86,9 +86,9 @@ discard block |
||
86 | 86 | ->query( |
87 | 87 | "SELECT column_name FROM all_cons_columns |
88 | 88 | WHERE table_name = ? AND constraint_name = ? AND owner = ?", |
89 | - [ strtoupper($table), $pkname, $owner ] |
|
89 | + [strtoupper($table), $pkname, $owner] |
|
90 | 90 | )) |
91 | - ->map(function ($v) { |
|
91 | + ->map(function($v) { |
|
92 | 92 | $new = []; |
93 | 93 | foreach ($v as $kk => $vv) { |
94 | 94 | $new[strtoupper($kk)] = $vv; |
@@ -115,9 +115,9 @@ discard block |
||
115 | 115 | LEFT JOIN all_cons_columns cc ON cc.OWNER = ac.OWNER AND cc.CONSTRAINT_NAME = ac.CONSTRAINT_NAME |
116 | 116 | WHERE ac.OWNER = ? AND ac.R_OWNER = ? AND ac.R_CONSTRAINT_NAME = ? AND ac.CONSTRAINT_TYPE = ? |
117 | 117 | ORDER BY cc.POSITION", |
118 | - [ $owner, $owner, $pkname, 'R' ] |
|
118 | + [$owner, $owner, $pkname, 'R'] |
|
119 | 119 | )) |
120 | - ->map(function ($v) { |
|
120 | + ->map(function($v) { |
|
121 | 121 | $new = []; |
122 | 122 | foreach ($v as $kk => $vv) { |
123 | 123 | $new[strtoupper($kk)] = $vv; |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | as $relation |
128 | 128 | ) { |
129 | 129 | $relations[$relation['CONSTRAINT_NAME']]['table'] = $relation['TABLE_NAME']; |
130 | - $relations[$relation['CONSTRAINT_NAME']]['keymap'][$primary[(int)$relation['POSITION']-1]] = |
|
130 | + $relations[$relation['CONSTRAINT_NAME']]['keymap'][$primary[(int) $relation['POSITION'] - 1]] = |
|
131 | 131 | $relation['COLUMN_NAME']; |
132 | 132 | } |
133 | 133 | foreach ($relations as $data) { |
@@ -157,9 +157,9 @@ discard block |
||
157 | 157 | ac.OWNER = ? AND ac.R_OWNER = ? AND ac.TABLE_NAME = ? AND ac.CONSTRAINT_TYPE = ? AND |
158 | 158 | cc.COLUMN_NAME IN (??) |
159 | 159 | ORDER BY POSITION", |
160 | - [ $owner, $owner, $data['table'], 'R', $columns ] |
|
160 | + [$owner, $owner, $data['table'], 'R', $columns] |
|
161 | 161 | )) |
162 | - ->map(function ($v) { |
|
162 | + ->map(function($v) { |
|
163 | 163 | $new = []; |
164 | 164 | foreach ($v as $kk => $vv) { |
165 | 165 | $new[strtoupper($kk)] = $vv; |
@@ -179,9 +179,9 @@ discard block |
||
179 | 179 | ->query( |
180 | 180 | "SELECT COLUMN_NAME FROM all_cons_columns |
181 | 181 | WHERE OWNER = ? AND CONSTRAINT_NAME = ? ORDER BY POSITION", |
182 | - [ $owner, current($foreign['keymap']) ] |
|
182 | + [$owner, current($foreign['keymap'])] |
|
183 | 183 | )) |
184 | - ->map(function ($v) { |
|
184 | + ->map(function($v) { |
|
185 | 185 | $new = []; |
186 | 186 | foreach ($v as $kk => $vv) { |
187 | 187 | $new[strtoupper($kk)] = $vv; |
@@ -196,7 +196,7 @@ discard block |
||
196 | 196 | $relname = $foreign['table']; |
197 | 197 | $cntr = 1; |
198 | 198 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
199 | - $relname = $foreign['table'] . '_' . (++ $cntr); |
|
199 | + $relname = $foreign['table'].'_'.(++$cntr); |
|
200 | 200 | } |
201 | 201 | $definition->addRelation( |
202 | 202 | new TableRelation( |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | $relname = $data['table']; |
213 | 213 | $cntr = 1; |
214 | 214 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
215 | - $relname = $data['table'] . '_' . (++ $cntr); |
|
215 | + $relname = $data['table'].'_'.(++$cntr); |
|
216 | 216 | } |
217 | 217 | $definition->addRelation( |
218 | 218 | new TableRelation( |
@@ -240,9 +240,9 @@ discard block |
||
240 | 240 | LEFT JOIN all_cons_columns cc ON cc.OWNER = ac.OWNER AND cc.CONSTRAINT_NAME = ac.CONSTRAINT_NAME |
241 | 241 | WHERE ac.OWNER = ? AND ac.R_OWNER = ? AND ac.TABLE_NAME = ? AND ac.CONSTRAINT_TYPE = ? |
242 | 242 | ORDER BY cc.POSITION", |
243 | - [ $owner, $owner, strtoupper($table), 'R' ] |
|
243 | + [$owner, $owner, strtoupper($table), 'R'] |
|
244 | 244 | )) |
245 | - ->map(function ($v) { |
|
245 | + ->map(function($v) { |
|
246 | 246 | $new = []; |
247 | 247 | foreach ($v as $kk => $vv) { |
248 | 248 | $new[strtoupper($kk)] = $vv; |
@@ -260,9 +260,9 @@ discard block |
||
260 | 260 | ->query( |
261 | 261 | "SELECT COLUMN_NAME FROM all_cons_columns |
262 | 262 | WHERE OWNER = ? AND CONSTRAINT_NAME = ? ORDER BY POSITION", |
263 | - [ $owner, current($data['keymap']) ] |
|
263 | + [$owner, current($data['keymap'])] |
|
264 | 264 | )) |
265 | - ->map(function ($v) { |
|
265 | + ->map(function($v) { |
|
266 | 266 | $new = []; |
267 | 267 | foreach ($v as $kk => $vv) { |
268 | 268 | $new[strtoupper($kk)] = $vv; |
@@ -277,7 +277,7 @@ discard block |
||
277 | 277 | $relname = $data['table']; |
278 | 278 | $cntr = 1; |
279 | 279 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
280 | - $relname = $data['table'] . '_' . (++ $cntr); |
|
280 | + $relname = $data['table'].'_'.(++$cntr); |
|
281 | 281 | } |
282 | 282 | $definition->addRelation( |
283 | 283 | new TableRelation( |
@@ -298,18 +298,18 @@ discard block |
||
298 | 298 | "SELECT TABLE_NAME FROM ALL_TABLES where OWNER = ?", |
299 | 299 | [$this->connection['name']] |
300 | 300 | )) |
301 | - ->map(function ($v) { |
|
301 | + ->map(function($v) { |
|
302 | 302 | $new = []; |
303 | 303 | foreach ($v as $kk => $vv) { |
304 | 304 | $new[strtoupper($kk)] = $vv; |
305 | 305 | } |
306 | 306 | return $new; |
307 | 307 | }) |
308 | - ->mapKey(function ($v) { |
|
308 | + ->mapKey(function($v) { |
|
309 | 309 | return $v['TABLE_NAME']; |
310 | 310 | }) |
311 | 311 | ->pluck('TABLE_NAME') |
312 | - ->map(function ($v) { |
|
312 | + ->map(function($v) { |
|
313 | 313 | return $this->table($v); |
314 | 314 | }) |
315 | 315 | ->toArray(); |
@@ -29,7 +29,7 @@ discard block |
||
29 | 29 | if ($temp) { |
30 | 30 | $temp = $temp->fetch_fields(); |
31 | 31 | if ($temp) { |
32 | - $columns = array_map(function ($v) { |
|
32 | + $columns = array_map(function($v) { |
|
33 | 33 | return $v->name; |
34 | 34 | }, $temp); |
35 | 35 | } |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | } |
71 | 71 | public function current() |
72 | 72 | { |
73 | - return $this->nativeDriver ? $this->last : array_map(function ($v) { |
|
73 | + return $this->nativeDriver ? $this->last : array_map(function($v) { |
|
74 | 74 | return $v; |
75 | 75 | }, $this->row); |
76 | 76 | } |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | } |
90 | 90 | public function next() |
91 | 91 | { |
92 | - $this->fetched ++; |
|
92 | + $this->fetched++; |
|
93 | 93 | $this->last = $this->nativeDriver ? $this->result->fetch_assoc() : $this->statement->fetch(); |
94 | 94 | } |
95 | 95 | public function valid() |
@@ -47,8 +47,7 @@ |
||
47 | 47 | if (isset($this->definition->getRelations()[$method])) { |
48 | 48 | if (array_key_exists($method, $this->fetched)) { |
49 | 49 | return is_callable($this->fetched[$method]) ? |
50 | - $this->fetched[$method] = call_user_func($this->fetched[$method], $args[0] ?? null) : |
|
51 | - $this->fetched[$method]; |
|
50 | + $this->fetched[$method] = call_user_func($this->fetched[$method], $args[0] ?? null) : $this->fetched[$method]; |
|
52 | 51 | } |
53 | 52 | } |
54 | 53 | return null; |
@@ -83,7 +83,7 @@ |
||
83 | 83 | } |
84 | 84 | } |
85 | 85 | if (!$this->statement->execute()) { |
86 | - throw new DBException('Prepared execute error: ' . $this->statement->error); |
|
86 | + throw new DBException('Prepared execute error: '.$this->statement->error); |
|
87 | 87 | } |
88 | 88 | return new Result($this->statement, $buff); |
89 | 89 | } |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | $connection['pass'] = isset($temp['pass']) && strlen($temp['pass']) ? $temp['pass'] : null; |
75 | 75 | $connection['host'] = isset($temp['host']) && strlen($temp['host']) ? $temp['host'] : null; |
76 | 76 | $connection['name'] = isset($temp['path']) && strlen($temp['path']) ? trim($temp['path'], '/') : null; |
77 | - $connection['port'] = isset($temp['port']) && (int)$temp['port'] ? (int)$temp['port'] : null; |
|
77 | + $connection['port'] = isset($temp['port']) && (int) $temp['port'] ? (int) $temp['port'] : null; |
|
78 | 78 | if (isset($temp['query']) && strlen($temp['query'])) { |
79 | 79 | parse_str($temp['query'], $connection['opts']); |
80 | 80 | } |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | $new = ''; |
118 | 118 | $par = array_values($par); |
119 | 119 | if (substr_count($sql, '?') === 2 && !is_array($par[0])) { |
120 | - $par = [ $par ]; |
|
120 | + $par = [$par]; |
|
121 | 121 | } |
122 | 122 | $parts = explode('??', $sql); |
123 | 123 | $index = 0; |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | $index += count($tmp) - 1; |
128 | 128 | if (isset($par[$index])) { |
129 | 129 | if (!is_array($par[$index])) { |
130 | - $par[$index] = [ $par[$index] ]; |
|
130 | + $par[$index] = [$par[$index]]; |
|
131 | 131 | } |
132 | 132 | $params = $par[$index]; |
133 | 133 | array_splice($par, $index, 1, $params); |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | $new .= implode(',', array_fill(0, count($params), '?')); |
136 | 136 | } |
137 | 137 | } |
138 | - return [ $new, $par ]; |
|
138 | + return [$new, $par]; |
|
139 | 139 | } |
140 | 140 | /** |
141 | 141 | * Run a query (prepare & execute). |
@@ -184,7 +184,7 @@ discard block |
||
184 | 184 | ): Collection { |
185 | 185 | $coll = Collection::from($this->query($sql, $par, $buff)); |
186 | 186 | if (($keys = $this->driver->option('mode')) && in_array($keys, ['strtoupper', 'strtolower'])) { |
187 | - $coll->map(function ($v) use ($keys) { |
|
187 | + $coll->map(function($v) use ($keys) { |
|
188 | 188 | $new = []; |
189 | 189 | foreach ($v as $k => $vv) { |
190 | 190 | $new[call_user_func($keys, $k)] = $vv; |
@@ -193,18 +193,18 @@ discard block |
||
193 | 193 | }); |
194 | 194 | } |
195 | 195 | if ($key !== null) { |
196 | - $coll->mapKey(function ($v) use ($key) { |
|
196 | + $coll->mapKey(function($v) use ($key) { |
|
197 | 197 | return $v[$key]; |
198 | 198 | }); |
199 | 199 | } |
200 | 200 | if ($skip) { |
201 | - $coll->map(function ($v) use ($key) { |
|
201 | + $coll->map(function($v) use ($key) { |
|
202 | 202 | unset($v[$key]); |
203 | 203 | return $v; |
204 | 204 | }); |
205 | 205 | } |
206 | 206 | if ($opti) { |
207 | - $coll->map(function ($v) { |
|
207 | + $coll->map(function($v) { |
|
208 | 208 | return count($v) === 1 ? current($v) : $v; |
209 | 209 | }); |
210 | 210 | } |
@@ -299,8 +299,7 @@ discard block |
||
299 | 299 | public function definition(string $table, bool $detectRelations = true) : Table |
300 | 300 | { |
301 | 301 | return isset($this->tables[$table]) ? |
302 | - $this->tables[$table] : |
|
303 | - $this->driver->table($table, $detectRelations); |
|
302 | + $this->tables[$table] : $this->driver->table($table, $detectRelations); |
|
304 | 303 | } |
305 | 304 | /** |
306 | 305 | * Parse all tables from the database. |
@@ -317,13 +316,13 @@ discard block |
||
317 | 316 | */ |
318 | 317 | public function getSchema($asPlainArray = true) |
319 | 318 | { |
320 | - return !$asPlainArray ? $this->tables : array_map(function ($table) { |
|
319 | + return !$asPlainArray ? $this->tables : array_map(function($table) { |
|
321 | 320 | return [ |
322 | 321 | 'name' => $table->getName(), |
323 | 322 | 'schema' => $table->getSchema(), |
324 | 323 | 'pkey' => $table->getPrimaryKey(), |
325 | 324 | 'comment' => $table->getComment(), |
326 | - 'columns' => array_map(function ($column) { |
|
325 | + 'columns' => array_map(function($column) { |
|
327 | 326 | return [ |
328 | 327 | 'name' => $column->getName(), |
329 | 328 | 'type' => $column->getType(), |
@@ -334,9 +333,9 @@ discard block |
||
334 | 333 | 'nullable' => $column->isNullable() |
335 | 334 | ]; |
336 | 335 | }, $table->getFullColumns()), |
337 | - 'relations' => array_map(function ($rel) { |
|
336 | + 'relations' => array_map(function($rel) { |
|
338 | 337 | $relation = clone $rel; |
339 | - $relation = (array)$relation; |
|
338 | + $relation = (array) $relation; |
|
340 | 339 | $relation['table'] = $rel->table->getName(); |
341 | 340 | if ($rel->pivot) { |
342 | 341 | $relation['pivot'] = $rel->pivot->getName(); |
@@ -389,8 +388,7 @@ discard block |
||
389 | 388 | public function table(string $table, bool $mapped = false) |
390 | 389 | { |
391 | 390 | return $mapped ? |
392 | - new TableQueryMapped($this, $this->definition($table)) : |
|
393 | - new TableQuery($this, $this->definition($table)); |
|
391 | + new TableQueryMapped($this, $this->definition($table)) : new TableQuery($this, $this->definition($table)); |
|
394 | 392 | } |
395 | 393 | public function __call($method, $args) |
396 | 394 | { |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | public function collection(TableQueryIterator $iterator, Table $definition) : Collection |
53 | 53 | { |
54 | 54 | return Collection::from($iterator) |
55 | - ->map(function ($v) use ($definition) { |
|
55 | + ->map(function($v) use ($definition) { |
|
56 | 56 | return $this->entity($definition, $v); |
57 | 57 | }); |
58 | 58 | } |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | $definition = $entity->definition(); |
128 | 128 | foreach ($definition->getColumns() as $column) { |
129 | 129 | if (!array_key_exists($column, $data)) { |
130 | - $entity->__lazyProperty($column, function () use ($definition, $primary, $column) { |
|
130 | + $entity->__lazyProperty($column, function() use ($definition, $primary, $column) { |
|
131 | 131 | $query = $this->db->table($definition->getFullName()); |
132 | 132 | foreach ($primary as $k => $v) { |
133 | 133 | $query->filter($k, $v); |
@@ -141,12 +141,12 @@ discard block |
||
141 | 141 | $name, |
142 | 142 | array_key_exists($name, $data) && isset($data[$name]) ? |
143 | 143 | ($relation->many ? |
144 | - array_map(function ($v) use ($relation) { |
|
144 | + array_map(function($v) use ($relation) { |
|
145 | 145 | return $this->entity($relation->table, $v); |
146 | 146 | }, $data[$name]) : |
147 | 147 | $this->entity($relation->table, $data[$name]) |
148 | 148 | ) : |
149 | - function (array $columns = null) use ($entity, $definition, $relation, $data) { |
|
149 | + function(array $columns = null) use ($entity, $definition, $relation, $data) { |
|
150 | 150 | $query = $this->db->table($relation->table->getFullName(), true); |
151 | 151 | if ($columns !== null) { |
152 | 152 | $query->columns($columns); |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | ); |
173 | 173 | } |
174 | 174 | foreach ($definition->getPrimaryKey() as $v) { |
175 | - $query->filter($nm . '.' . $v, $data[$v] ?? null); |
|
175 | + $query->filter($nm.'.'.$v, $data[$v] ?? null); |
|
176 | 176 | } |
177 | 177 | } else { |
178 | 178 | foreach ($relation->keymap as $k => $v) { |
@@ -180,8 +180,7 @@ discard block |
||
180 | 180 | } |
181 | 181 | } |
182 | 182 | return $relation->many ? |
183 | - $query->iterator() : |
|
184 | - $query[0]; |
|
183 | + $query->iterator() : $query[0]; |
|
185 | 184 | } |
186 | 185 | ); |
187 | 186 | } |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | } |
24 | 24 | public function affected() : int |
25 | 25 | { |
26 | - return (int)\oci_num_rows($this->statement); |
|
26 | + return (int) \oci_num_rows($this->statement); |
|
27 | 27 | } |
28 | 28 | public function insertID(string $sequence = null) |
29 | 29 | { |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | } |
65 | 65 | public function next() |
66 | 66 | { |
67 | - $this->fetched ++; |
|
67 | + $this->fetched++; |
|
68 | 68 | $this->last = \oci_fetch_array($this->statement, \OCI_ASSOC + \OCI_RETURN_NULLS + \OCI_RETURN_LOBS); |
69 | 69 | } |
70 | 70 | public function valid() |