| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 |
- <?php
- namespace Illuminate\Database\Query\Processors;
- class MySqlProcessor extends Processor
- {
- /**
- * Process the results of a columns query.
- *
- * @param array $results
- * @return array
- */
- public function processColumns($results)
- {
- return array_map(function ($result) {
- $result = (object) $result;
- return [
- 'name' => $result->name,
- 'type_name' => $result->type_name,
- 'type' => $result->type,
- 'collation' => $result->collation,
- 'nullable' => $result->nullable === 'YES',
- 'default' => $result->default,
- 'auto_increment' => $result->extra === 'auto_increment',
- 'comment' => $result->comment ?: null,
- 'generation' => $result->expression ? [
- 'type' => match ($result->extra) {
- 'STORED GENERATED' => 'stored',
- 'VIRTUAL GENERATED' => 'virtual',
- default => null,
- },
- 'expression' => $result->expression,
- ] : null,
- ];
- }, $results);
- }
- /**
- * Process the results of an indexes query.
- *
- * @param array $results
- * @return array
- */
- public function processIndexes($results)
- {
- return array_map(function ($result) {
- $result = (object) $result;
- return [
- 'name' => $name = strtolower($result->name),
- 'columns' => explode(',', $result->columns),
- 'type' => strtolower($result->type),
- 'unique' => (bool) $result->unique,
- 'primary' => $name === 'primary',
- ];
- }, $results);
- }
- /**
- * Process the results of a foreign keys query.
- *
- * @param array $results
- * @return array
- */
- public function processForeignKeys($results)
- {
- return array_map(function ($result) {
- $result = (object) $result;
- return [
- 'name' => $result->name,
- 'columns' => explode(',', $result->columns),
- 'foreign_schema' => $result->foreign_schema,
- 'foreign_table' => $result->foreign_table,
- 'foreign_columns' => explode(',', $result->foreign_columns),
- 'on_update' => strtolower($result->on_update),
- 'on_delete' => strtolower($result->on_delete),
- ];
- }, $results);
- }
- }
|