SqliteConnection::getPdo() - Code Metrics - andela-oogunjimi/Potato-ORM - Measure and Improve Code Quality continuously with Scrutinizer

SqliteConnection::getPdo() A
last analyzed 2016-05-02 03:35 UTC

↳ Parent: SqliteConnection

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	4
ccs	2
cts	2
cp	1
rs	10
cc	1
eloc	2
nc	1
nop	0
crap	1

<?php

namespace Opeyemiabiodun\PotatoORM\Connections;

use PDO;
use PDOException;
use InvalidArgumentException;

final class SqliteConnection implements Connection
{
    use DatabaseTransactionsTrait;

    /**
     * $_pdo The PDO instance of the connection.
     *
     * @var PDO
     */
    private $_pdo;

    /**
     * $columns Columns of the database table.
     *
     * @var array
     */
    private $columns = [];

    /**
     * $keys Keys of the database table.
     *
     * @var array
     */
    private $keys = [];

    /**
     * The method called in the constructor.
     *
     * @return void

     */
    public function __construct()
    {
        $dsn = 'sqlite:../../potatodb.sq3';

        try {
            $this->_pdo = new PDO($dsn);
        } catch (PDOException $e) {

        }
    }

    /**
     * Returns the columns of a table.
     *
     * @param string $table The table inspected for its columns.
     *
     * @return array The columns of the table.        
     */
    public function getColumns($table)

    {
        if (gettype($table) !== 'string') {
            throw new InvalidArgumentException("The parameter {$table} is not an string. A string is required instead.");
        }

        $this->loadColumnInfo($table);

        return $this->columns[$table];
    }

    /**
     * Returns the Connection's PDO.
     *
     * @return PDO PHP Data Objects
     */
    public function getPdo()
    {
        return $this->_pdo;
    }

    /**
     * Returns the primary key of a table.
     *
     * @param string $table The table inspected for its primary key.
     *
     * @return string The primary key of the table.
     */
    public function getPrimaryKey($table)

    {
        if (gettype($table) !== 'string') {
            throw new InvalidArgumentException("The parameter {$table} is not an string. A string is required instead.");
        }

        $this->loadColumnInfo($table);

        return $this->keys[$table][0];
    }

    private function loadColumnInfo($table)
    {
        $query = "PRAGMA table_info('{$table}')";
        $statement = $this->_pdo->query($query);

        /* @var $statement PDOStatement */
        $this->columns[$table] = [];
        $this->keys[$table] = [];

        while ($columnData = $statement->fetch(PDO::FETCH_NUM)) {
            $this->columns[$table][] = ['column_name' => $columnData[1]];

            if ($columnData[5] == 1) {
                $this->keys[$table][] = $columnData[1];
            }
        }
    }
}


1			<?php
2
3			namespace Opeyemiabiodun\PotatoORM\Connections;
4
5			use PDO;
6			use PDOException;
7			use InvalidArgumentException;
8
9			final class SqliteConnection implements Connection
10			{
11			use DatabaseTransactionsTrait;
12
13			/**
14			* $_pdo The PDO instance of the connection.
15			*
16			* @var PDO
17			*/
18			private $_pdo;
19
20			/**
21			* $columns Columns of the database table.
22			*
23			* @var array
24			*/
25			private $columns = [];
26
27			/**
28			* $keys Keys of the database table.
29			*
30			* @var array
31			*/
32			private $keys = [];
33
34			/**
35			* The method called in the constructor.
36			*
37			* @return void
			0 ignored issues – show Comprehensibility Best Practice introduced 2015-12-19 03:55 UTC by Report Bug Copy Issue Report Adding a `@return` annotation to constructors is generally not recommended as a constructor does not have a meaningful return value. Adding a `@return` annotation to a constructor is not recommended, since a constructor does not have a meaningful return value. Please refer to the PHP core documentation on constructors. Loading history...
38			*/
39			public function __construct()
40			{
41			$dsn = 'sqlite:../../potatodb.sq3';
42
43			try {
44			$this->_pdo = new PDO($dsn);
45			} catch (PDOException $e) {
			0 ignored issues – show Coding Style Comprehensibility introduced 2015-12-19 03:55 UTC by Report Bug Copy Issue Report Consider adding a comment why this CATCH block is empty. Loading history...
46			}
47			}
48
49			/**
50			* Returns the columns of a table.
51			*
52			* @param string $table The table inspected for its columns.
53			*
54			* @return array The columns of the table.
55			*/
56	7	View Code Duplication	public function getColumns($table)
			0 ignored issues – show Duplication introduced 2015-12-19 03:55 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
57			{
58	7		if (gettype($table) !== 'string') {
59			throw new InvalidArgumentException("The parameter {$table} is not an string. A string is required instead.");
60			}
61
62	7		$this->loadColumnInfo($table);
63
64	7		return $this->columns[$table];
65			}
66
67			/**
68			* Returns the Connection's PDO.
69			*
70			* @return PDO PHP Data Objects
71			*/
72	4		public function getPdo()
73			{
74	4		return $this->_pdo;
75			}
76
77			/**
78			* Returns the primary key of a table.
79			*
80			* @param string $table The table inspected for its primary key.
81			*
82			* @return string The primary key of the table.
83			*/
84	8	View Code Duplication	public function getPrimaryKey($table)
			0 ignored issues – show Duplication introduced 2015-12-20 20:20 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
85			{
86	8		if (gettype($table) !== 'string') {
87			throw new InvalidArgumentException("The parameter {$table} is not an string. A string is required instead.");
88			}
89
90	8		$this->loadColumnInfo($table);
91
92	8		return $this->keys[$table][0];
93			}
94
95	8		private function loadColumnInfo($table)
96			{
97	8		$query = "PRAGMA table_info('{$table}')";
98	8		$statement = $this->_pdo->query($query);
99
100			/* @var $statement PDOStatement */
101	8		$this->columns[$table] = [];
102	8		$this->keys[$table] = [];
103
104	8		while ($columnData = $statement->fetch(PDO::FETCH_NUM)) {
105	8		$this->columns[$table][] = ['column_name' => $columnData[1]];
106
107	8		if ($columnData[5] == 1) {
108	8		$this->keys[$table][] = $columnData[1];
109	8		}
110	8		}
111	8		}
112			}
113

andela-oogunjimi / Potato-ORM

SqliteConnection::getPdo() A last analyzed 2016-05-02 03:35 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

SqliteConnection::getPdo() A
last analyzed 2016-05-02 03:35 UTC