@@ -44,7 +44,8 @@ discard block |
||
| 44 | 44 | $database = $dbal->database($this->option('database')); |
| 45 | 45 | $schema = $database->table($this->argument('table'))->getSchema(); |
| 46 | 46 | |
| 47 | - if (!$schema->exists()) { |
|
| 47 | + if (!$schema->exists()) |
|
| 48 | + { |
|
| 48 | 49 | throw new DBALException( |
| 49 | 50 | "Table {$database->getName()}.{$this->argument('table')} does not exists." |
| 50 | 51 | ); |
@@ -58,11 +59,13 @@ discard block |
||
| 58 | 59 | |
| 59 | 60 | $this->describeColumns($schema); |
| 60 | 61 | |
| 61 | - if (!empty($indexes = $schema->getIndexes())) { |
|
| 62 | + if (!empty($indexes = $schema->getIndexes())) |
|
| 63 | + { |
|
| 62 | 64 | $this->describeIndexes($database, $indexes); |
| 63 | 65 | } |
| 64 | 66 | |
| 65 | - if (!empty($foreignKeys = $schema->getForeignKeys())) { |
|
| 67 | + if (!empty($foreignKeys = $schema->getForeignKeys())) |
|
| 68 | + { |
|
| 66 | 69 | $this->describeForeignKeys($database, $foreignKeys); |
| 67 | 70 | } |
| 68 | 71 | |
@@ -84,10 +87,12 @@ discard block |
||
| 84 | 87 | ] |
| 85 | 88 | ); |
| 86 | 89 | |
| 87 | - foreach ($schema->getColumns() as $column) { |
|
| 90 | + foreach ($schema->getColumns() as $column) |
|
| 91 | + { |
|
| 88 | 92 | $name = $column->getName(); |
| 89 | 93 | |
| 90 | - if (in_array($column->getName(), $schema->getPrimaryKeys(), true)) { |
|
| 94 | + if (in_array($column->getName(), $schema->getPrimaryKeys(), true)) |
|
| 95 | + { |
|
| 91 | 96 | $name = "<fg=magenta>{$name}</fg=magenta>"; |
| 92 | 97 | } |
| 93 | 98 | |
@@ -120,7 +125,8 @@ discard block |
||
| 120 | 125 | ); |
| 121 | 126 | |
| 122 | 127 | $indexesTable = $this->table(['Name:', 'Type:', 'Columns:']); |
| 123 | - foreach ($indexes as $index) { |
|
| 128 | + foreach ($indexes as $index) |
|
| 129 | + { |
|
| 124 | 130 | $indexesTable->addRow( |
| 125 | 131 | [ |
| 126 | 132 | $index->getName(), |
@@ -155,7 +161,8 @@ discard block |
||
| 155 | 161 | ] |
| 156 | 162 | ); |
| 157 | 163 | |
| 158 | - foreach ($foreignKeys as $reference) { |
|
| 164 | + foreach ($foreignKeys as $reference) |
|
| 165 | + { |
|
| 159 | 166 | $foreignTable->addRow( |
| 160 | 167 | [ |
| 161 | 168 | $reference->getName(), |
@@ -180,13 +187,15 @@ discard block |
||
| 180 | 187 | { |
| 181 | 188 | $defaultValue = $column->getDefaultValue(); |
| 182 | 189 | |
| 183 | - if ($defaultValue instanceof FragmentInterface) { |
|
| 190 | + if ($defaultValue instanceof FragmentInterface) |
|
| 191 | + { |
|
| 184 | 192 | $value = $driver->getQueryCompiler()->compile(new QueryParameters(), '', $defaultValue); |
| 185 | 193 | |
| 186 | 194 | return "<info>{$value}</info>"; |
| 187 | 195 | } |
| 188 | 196 | |
| 189 | - if ($defaultValue instanceof \DateTimeInterface) { |
|
| 197 | + if ($defaultValue instanceof \DateTimeInterface) |
|
| 198 | + { |
|
| 190 | 199 | $defaultValue = $defaultValue->format('c'); |
| 191 | 200 | } |
| 192 | 201 | |
@@ -203,11 +212,13 @@ discard block |
||
| 203 | 212 | |
| 204 | 213 | $abstractType = $column->getAbstractType(); |
| 205 | 214 | |
| 206 | - if ($column->getSize()) { |
|
| 215 | + if ($column->getSize()) |
|
| 216 | + { |
|
| 207 | 217 | $type .= " ({$column->getSize()})"; |
| 208 | 218 | } |
| 209 | 219 | |
| 210 | - if ($abstractType === 'decimal') { |
|
| 220 | + if ($abstractType === 'decimal') |
|
| 221 | + { |
|
| 211 | 222 | $type .= " ({$column->getPrecision()}, {$column->getScale()})"; |
| 212 | 223 | } |
| 213 | 224 | |
@@ -222,7 +233,8 @@ discard block |
||
| 222 | 233 | { |
| 223 | 234 | $abstractType = $column->getAbstractType(); |
| 224 | 235 | |
| 225 | - if (in_array($abstractType, ['primary', 'bigPrimary'])) { |
|
| 236 | + if (in_array($abstractType, ['primary', 'bigPrimary'])) |
|
| 237 | + { |
|
| 226 | 238 | $abstractType = "<fg=magenta>{$abstractType}</fg=magenta>"; |
| 227 | 239 | } |
| 228 | 240 | |