Demo\DataBaseConnection

Complexity

Total Complexity

6

Size/Duplication

Total Lines	58
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

0%

Importance

Changes	15
Bugs	7	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	17	1
A	getDataBaseDriver()	0	13	4
A	loadEnv()	0	5	1

<?php

/**
 * This class is involve in connection to the database.
 *
 * @author   Raimi Ademola <ademola.raimi@andela.com>
 * @copyright: 2016 Andela
 */
namespace Demo;

use Dotenv\Dotenv;
use PDO;

class DataBaseConnection extends PDO
{
    private $servername;
    private $username;
    private $password;
    private $driver;
    private $dbname;

    /**
     * This is a constructor; a default method  that will be called automatically during class instantiation.
     */
    public function __construct()
    {
        $this->loadEnv();

        $this->servername = getenv('DB_HOST');
        $this->username   = getenv('DB_USERNAME');
        $this->password   = getenv('DB_PASSWORD');
        $this->driver     = getenv('DB_DRIVER');
        $this->dbname     = getenv('DB_NAME');

        $options = [
            PDO::ATTR_PERSISTENT => true,
            PDO::ATTR_ERRMODE    => PDO::ERRMODE_EXCEPTION,
        ];

        parent::__construct($this->getDataBaseDriver(), $this->username, $this->password, $options);
    }

    /**
     * This method determines the driver to be used for appropriate database server.
     *
     *
     * @return string dsn
     */
    public function getDataBaseDriver()
    {
        if ($this->driver === 'mysql') {
            $dns = 'mysql:host='.$this->servername.';dbname='.$this->dbname;
            return $dns;
        } elseif ($this->driver === 'sqlite') {
            $dns = 'sqlite:host='.$this->servername.';dbname='.$this->dbname;
            return $dns;    
        } elseif ($this->driver === 'pgsqlsql') {
             $dns = 'pgsqlsql:host='.$this->servername.';dbname='.$this->dbname;
             return $dns;
        }
    }

    /**
     * Load Dotenv to grant getenv() access to environment variables in .env file.
     */
    private function loadEnv()
    {
        $dotenv = new Dotenv(__DIR__.'/../../');
        $dotenv->load();
    }
}