@@ -32,19 +32,19 @@ discard block |
||
32 | 32 | $columns = Collection::from($this |
33 | 33 | ->query( |
34 | 34 | "SELECT * FROM user_tab_cols WHERE UPPER(table_name) = ?", |
35 | - [ strtoupper($table) ] |
|
35 | + [strtoupper($table)] |
|
36 | 36 | )) |
37 | - ->map(function ($v) { |
|
37 | + ->map(function($v) { |
|
38 | 38 | $new = []; |
39 | 39 | foreach ($v as $kk => $vv) { |
40 | 40 | $new[strtoupper($kk)] = $vv; |
41 | 41 | } |
42 | 42 | return $new; |
43 | 43 | }) |
44 | - ->mapKey(function ($v): string { |
|
44 | + ->mapKey(function($v): string { |
|
45 | 45 | return $v['COLUMN_NAME']; |
46 | 46 | }) |
47 | - ->map(function ($v) { |
|
47 | + ->map(function($v) { |
|
48 | 48 | $v['length'] = null; |
49 | 49 | if (!isset($v['DATA_TYPE'])) { |
50 | 50 | return $v; |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | default: |
57 | 57 | if (strpos($type, 'char') !== false && strpos($type, '(') !== false) { |
58 | 58 | // extract length from varchar |
59 | - $v['length'] = (int)explode(')', (explode('(', $type)[1] ?? ''))[0]; |
|
59 | + $v['length'] = (int) explode(')', (explode('(', $type)[1] ?? ''))[0]; |
|
60 | 60 | $v['length'] = $v['length'] > 0 ? $v['length'] : null; |
61 | 61 | } |
62 | 62 | break; |
@@ -73,9 +73,9 @@ discard block |
||
73 | 73 | ->query( |
74 | 74 | "SELECT constraint_name FROM user_constraints |
75 | 75 | WHERE table_name = ? AND constraint_type = ?", |
76 | - [ strtoupper($table), 'P' ] |
|
76 | + [strtoupper($table), 'P'] |
|
77 | 77 | )) |
78 | - ->map(function ($v) { |
|
78 | + ->map(function($v) { |
|
79 | 79 | $new = []; |
80 | 80 | foreach ($v as $kk => $vv) { |
81 | 81 | $new[strtoupper($kk)] = $vv; |
@@ -90,9 +90,9 @@ discard block |
||
90 | 90 | ->query( |
91 | 91 | "SELECT column_name FROM user_cons_columns |
92 | 92 | WHERE table_name = ? AND constraint_name = ?", |
93 | - [ strtoupper($table), $pkname ] |
|
93 | + [strtoupper($table), $pkname] |
|
94 | 94 | )) |
95 | - ->map(function ($v) { |
|
95 | + ->map(function($v) { |
|
96 | 96 | $new = []; |
97 | 97 | foreach ($v as $kk => $vv) { |
98 | 98 | $new[strtoupper($kk)] = $vv; |
@@ -120,9 +120,9 @@ discard block |
||
120 | 120 | WHERE |
121 | 121 | ac.R_CONSTRAINT_NAME = ? AND ac.CONSTRAINT_TYPE = ? |
122 | 122 | ORDER BY cc.POSITION", |
123 | - [ $pkname, 'R' ] |
|
123 | + [$pkname, 'R'] |
|
124 | 124 | )) |
125 | - ->map(function ($v) { |
|
125 | + ->map(function($v) { |
|
126 | 126 | $new = []; |
127 | 127 | foreach ($v as $kk => $vv) { |
128 | 128 | $new[strtoupper($kk)] = $vv; |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | as $relation |
133 | 133 | ) { |
134 | 134 | $relations[$relation['CONSTRAINT_NAME']]['table'] = $relation['TABLE_NAME']; |
135 | - $relations[$relation['CONSTRAINT_NAME']]['keymap'][$primary[(int)$relation['POSITION']-1]] = |
|
135 | + $relations[$relation['CONSTRAINT_NAME']]['keymap'][$primary[(int) $relation['POSITION'] - 1]] = |
|
136 | 136 | $relation['COLUMN_NAME']; |
137 | 137 | } |
138 | 138 | foreach ($relations as $data) { |
@@ -162,9 +162,9 @@ discard block |
||
162 | 162 | ac.TABLE_NAME = ? AND ac.CONSTRAINT_TYPE = ? AND |
163 | 163 | cc.COLUMN_NAME IN (??) |
164 | 164 | ORDER BY POSITION", |
165 | - [ $data['table'], 'R', $columns ] |
|
165 | + [$data['table'], 'R', $columns] |
|
166 | 166 | )) |
167 | - ->map(function ($v) { |
|
167 | + ->map(function($v) { |
|
168 | 168 | $new = []; |
169 | 169 | foreach ($v as $kk => $vv) { |
170 | 170 | $new[strtoupper($kk)] = $vv; |
@@ -184,9 +184,9 @@ discard block |
||
184 | 184 | ->query( |
185 | 185 | "SELECT COLUMN_NAME FROM user_cons_columns |
186 | 186 | WHERE CONSTRAINT_NAME = ? ORDER BY POSITION", |
187 | - [ current($foreign['keymap']) ] |
|
187 | + [current($foreign['keymap'])] |
|
188 | 188 | )) |
189 | - ->map(function ($v) { |
|
189 | + ->map(function($v) { |
|
190 | 190 | $new = []; |
191 | 191 | foreach ($v as $kk => $vv) { |
192 | 192 | $new[strtoupper($kk)] = $vv; |
@@ -201,7 +201,7 @@ discard block |
||
201 | 201 | $relname = $foreign['table']; |
202 | 202 | $cntr = 1; |
203 | 203 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
204 | - $relname = $foreign['table'] . '_' . (++ $cntr); |
|
204 | + $relname = $foreign['table'].'_'.(++$cntr); |
|
205 | 205 | } |
206 | 206 | $definition->addRelation( |
207 | 207 | new TableRelation( |
@@ -221,7 +221,7 @@ discard block |
||
221 | 221 | $relname = $data['table']; |
222 | 222 | $cntr = 1; |
223 | 223 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
224 | - $relname = $data['table'] . '_' . (++ $cntr); |
|
224 | + $relname = $data['table'].'_'.(++$cntr); |
|
225 | 225 | } |
226 | 226 | $definition->addRelation( |
227 | 227 | new TableRelation( |
@@ -255,9 +255,9 @@ discard block |
||
255 | 255 | LEFT JOIN user_cons_columns cc ON cc.CONSTRAINT_NAME = ac.CONSTRAINT_NAME |
256 | 256 | WHERE ac.TABLE_NAME = ? AND ac.CONSTRAINT_TYPE = ? |
257 | 257 | ORDER BY cc.POSITION", |
258 | - [ strtoupper($table), 'R' ] |
|
258 | + [strtoupper($table), 'R'] |
|
259 | 259 | )) |
260 | - ->map(function ($v) { |
|
260 | + ->map(function($v) { |
|
261 | 261 | $new = []; |
262 | 262 | foreach ($v as $kk => $vv) { |
263 | 263 | $new[strtoupper($kk)] = $vv; |
@@ -275,9 +275,9 @@ discard block |
||
275 | 275 | ->query( |
276 | 276 | "SELECT COLUMN_NAME FROM user_cons_columns |
277 | 277 | WHERE CONSTRAINT_NAME = ? ORDER BY POSITION", |
278 | - [ current($data['keymap']) ] |
|
278 | + [current($data['keymap'])] |
|
279 | 279 | )) |
280 | - ->map(function ($v) { |
|
280 | + ->map(function($v) { |
|
281 | 281 | $new = []; |
282 | 282 | foreach ($v as $kk => $vv) { |
283 | 283 | $new[strtoupper($kk)] = $vv; |
@@ -292,7 +292,7 @@ discard block |
||
292 | 292 | $relname = $data['table']; |
293 | 293 | $cntr = 1; |
294 | 294 | while ($definition->hasRelation($relname) || $definition->getName() == $relname) { |
295 | - $relname = $data['table'] . '_' . (++ $cntr); |
|
295 | + $relname = $data['table'].'_'.(++$cntr); |
|
296 | 296 | } |
297 | 297 | $definition->addRelation( |
298 | 298 | new TableRelation( |
@@ -316,18 +316,18 @@ discard block |
||
316 | 316 | SELECT VIEW_NAME AS TABLE_NAME FROM USER_VIEWS", |
317 | 317 | [] |
318 | 318 | )) |
319 | - ->map(function ($v) { |
|
319 | + ->map(function($v) { |
|
320 | 320 | $new = []; |
321 | 321 | foreach ($v as $kk => $vv) { |
322 | 322 | $new[strtoupper($kk)] = $vv; |
323 | 323 | } |
324 | 324 | return $new; |
325 | 325 | }) |
326 | - ->mapKey(function ($v) { |
|
326 | + ->mapKey(function($v) { |
|
327 | 327 | return strtolower($v['TABLE_NAME']); |
328 | 328 | }) |
329 | 329 | ->pluck('TABLE_NAME') |
330 | - ->map(function ($v) { |
|
330 | + ->map(function($v) { |
|
331 | 331 | return $this->table($v)->toLowerCase(); |
332 | 332 | }) |
333 | 333 | ->toArray(); |