SQLiteDriver::getTable() - Code Metrics - Inspection of "Update descriptions" - rougin/describe - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( bd6b93...2911b9 )

by Rougin

created 2016-03-06 08:34 UTC

SQLiteDriver::getTable() B

↳ Parent: SQLiteDriver

Complexity

Conditions	4
Paths	5

Size

Total Lines	32
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	22
CRAP Score	4

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	32
ccs	22
cts	22
cp	1
rs	8.5806
cc	4
eloc	18
nc	5
nop	1
crap	4

<?php

namespace Rougin\Describe\Driver;

use PDO;
use Rougin\Describe\Driver\DriverInterface;
use Rougin\Describe\Column;

/**
 * SQLite Driver
 *
 * A database driver extension for SQLite.
 * 
 * @package  Describe
 * @category Driver
 * @author   Rougin Royce Gutib <[email protected]>
 */
class SQLiteDriver implements DriverInterface
{
    protected $pdo;

    /**
     * @param PDO $pdo
     */
    public function __construct(PDO $pdo)
    {
        $this->pdo = $pdo;
    }

    /**
     * Returns the result.
     * 
     * @return array
     */
    public function getTable($table)
    {
        $columns = [];

        $information = $this->pdo->prepare(
            'PRAGMA table_info("' . $table . '");'
        );

        $information->execute();
        $information->setFetchMode(PDO::FETCH_OBJ);

        while ($row = $information->fetch()) {
            $column = new Column;

            if ( ! $row->notnull) {
                $column->setNull(TRUE);
            }

            if ($row->pk) {
                $column->setPrimary(TRUE);
                $column->setAutoIncrement(TRUE);
            }

            $column->setDefaultValue($row->dflt_value);
            $column->setField($row->name);
            $column->setDataType(strtolower($row->type));

            array_push($columns, $column);
        }

        return $columns;
    }

    /**
     * Shows the list of tables.
     * 
     * @return array
     */
    public function showTables()
    {
        return [];
    }
}


1		<?php
2
3		namespace Rougin\Describe\Driver;
4
5		use PDO;
6		use Rougin\Describe\Driver\DriverInterface;
7		use Rougin\Describe\Column;
8
9		/**
10		* SQLite Driver
11		*
12		* A database driver extension for SQLite.
13		*
14		* @package Describe
15		* @category Driver
16		* @author Rougin Royce Gutib <[email protected]>
17		*/
18		class SQLiteDriver implements DriverInterface
19		{
20		protected $pdo;
21
22		/**
23		* @param PDO $pdo
24		*/
25	15	public function __construct(PDO $pdo)
26		{
27	15	$this->pdo = $pdo;
28	15	}
29
30		/**
31		* Returns the result.
32		*
33		* @return array
34		*/
35	12	public function getTable($table)
36		{
37	12	$columns = [];
38
39	12	$information = $this->pdo->prepare(
40	12	'PRAGMA table_info("' . $table . '");'
41	12	);
42
43	12	$information->execute();
44	12	$information->setFetchMode(PDO::FETCH_OBJ);
45
46	12	while ($row = $information->fetch()) {
47	12	$column = new Column;
48
49	12	if ( ! $row->notnull) {
50	12	$column->setNull(TRUE);
51	12	}
52
53	12	if ($row->pk) {
54	12	$column->setPrimary(TRUE);
55	12	$column->setAutoIncrement(TRUE);
56	12	}
57
58	12	$column->setDefaultValue($row->dflt_value);
59	12	$column->setField($row->name);
60	12	$column->setDataType(strtolower($row->type));
61
62	12	array_push($columns, $column);
63	12	}
64
65	12	return $columns;
66		}
67
68		/**
69		* Shows the list of tables.
70		*
71		* @return array
72		*/
73	3	public function showTables()
74		{
75	3	return [];
76		}
77		}
78

rougin / describe

Push — master ( bd6b93...2911b9 )

SQLiteDriver::getTable() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like