Sqlite::getTableFields() - Code Metrics - Inspection of "test fix" - oscarotero/simple-crud - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 0eeb04...4002ae )

by Oscar

created 2016-02-17 00:37 UTC

Sqlite::getTableFields() A

↳ Parent: Sqlite

Complexity

Conditions	2
Paths	2

Size

Total Lines	20
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	20
rs	9.4285
cc	2
eloc	13
nc	2
nop	1

<?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;
    }
}


1			<?php
2
3			namespace SimpleCrud\Scheme;
4
5			use PDO;
6
7			/**
8			* Class to retrieve info from a sqlite database.
9			*/
10			class Sqlite extends Scheme
11			{
12			/**
13			* {@inheritdoc}
14			*/
15			protected function getTables()
16			{
17			return $this->db->execute('SELECT name FROM sqlite_master WHERE (type="table" OR type="view") AND name != "sqlite_sequence"')->fetchAll(PDO::FETCH_COLUMN, 0);
18			}
19
20			/**
21			* {@inheritdoc}
22			*/
23			protected function getTableFields($table)
24			{
25			$result = $this->db->execute("pragma table_info(`{$table}`)")->fetchAll(PDO::FETCH_ASSOC);
26			$fields = [];
27
28			foreach ($result as $field) {
29			$name = $field['name'];
30
31			$fields[$name] = [
32			'type' => strtolower($field['type']),
33			'null' => ($field['notnull'] !== '1'),
34			'default' => $field['dflt_value'],
35			'unsigned' => null,
36			'length' => null,
37			'values' => null,
38			];
39			}
40
41			return $fields;
42			}
43			}
44

oscarotero / simple-crud

Push — master ( 0eeb04...4002ae )

Sqlite::getTableFields() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like