@@ -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(); |