SimpleCrud\Scheme\Mysql::loadTableFields()

Complexity

Conditions	5
Paths	1

Size

Total Lines

38

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function loadTableFields(string $table): array
    {
        $result = $this->pdo->query("DESCRIBE `{$table}`")->fetchAll(PDO::FETCH_ASSOC);

        return array_map(
            function ($field) {
                preg_match('#^(\w+)(\((.+)\))?( unsigned)?#', $field['Type'], $matches);

                $info = [
                    'name' => $field['Field'],
                    'type' => $matches[1],
                    'null' => ($field['Null'] === 'YES'),
                    'default' => $field['Default'],
                    'unsigned' => !empty($matches[4]),
                    'length' => null,
                    'values' => null,
                ];

                switch ($info['type']) {
                    case 'enum':
                    case 'set':
                        $info['values'] = explode(',', $matches[3]);
                        break;
                    default:
                        if (!isset($matches[3])) {
                            $info['length'] = null;
                        } elseif (strpos($matches[3], ',')) {
                            $info['length'] = floatval(str_replace(',', '.', $matches[3]));
                        } else {
                            $info['length'] = intval($matches[3]);
                        }
                }

                return $info;
            },
            $result
        );
    }
}