SimpleCrud\Scheme\Mysql::getTableFields()

Complexity

Conditions	6
Paths	6

Size

Total Lines	40
Code Lines	27

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    protected function getTableFields($table)
    {
        $result = $this->db->execute("DESCRIBE `{$table}`")->fetchAll(PDO::FETCH_ASSOC);
        $fields = [];

        foreach ($result as $field) {
            $name = $field['Field'];

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

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

            switch ($config['type']) {
                case 'enum':
                case 'set':
                    $config['values'] = explode(',', $matches[3]);
                    break;

                default:
                    if (!isset($matches[3])) {
                        $config['length'] = null;
                    } elseif (strpos($matches[3], ',')) {
                        $config['length'] = floatval(str_replace(',', '.', $matches[3]));
                    } else {
                        $config['length'] = intval($matches[3]);
                    }
            }

            $fields[$name] = $config;
        }

        return $fields;
    }
}