SimpleCrud\Scheme\Sqlite

Complexity

Total Complexity

3

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getTables()	0	4	1
A	getTableFields()	0	20	2

<?php

namespace SimpleCrud\Scheme;

use PDO;

/**
 * Class to retrieve info from a sqlite database.
 */
class Sqlite extends Scheme
{
    /**
     * {@inheritdoc}
     */
    protected function getTables()
    {
        return $this->db->execute('SELECT name FROM sqlite_master WHERE (type="table" OR type="view") AND name != "sqlite_sequence"')->fetchAll(PDO::FETCH_COLUMN, 0);
    }

    /**
     * {@inheritdoc}
     */
    protected function getTableFields($table)
    {
        $result = $this->db->execute("pragma table_info(`{$table}`)")->fetchAll(PDO::FETCH_ASSOC);
        $fields = [];

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

            $fields[$name] = [
                'type' => strtolower($field['type']),
                'null' => ($field['notnull'] !== '1'),
                'default' => $field['dflt_value'],
                'unsigned' => null,
                'length' => null,
                'values' => null,
            ];
        }

        return $fields;
    }
}