Db::pdo_connect() - Code Metrics - codysnider/tt-rss - Measure and Improve Code Quality continuously with Scrutinizer

Db::pdo_connect() B
last analyzed 2019-12-23 07:25 UTC

↳ Parent: Db

Complexity

Conditions	10
Paths	80

Size

Total Lines	32
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	10
eloc	20
c	0
b	0
f	0
nc	80
nop	0
dl	0
loc	32
rs	7.6666

How to fix Complexity

<?php
class Db
{

    /* @var Db $instance */
    private static $instance;

    /* @var IDb $adapter */
    private $adapter;

    private $link;

    /* @var PDO $pdo */
    private $pdo;

    private function __clone() {
        //
    }

    private function legacy_connect() {

        user_error("Legacy connect requested to ".DB_TYPE, E_USER_NOTICE);


        $er = error_reporting(E_ALL);

        switch (DB_TYPE) {
        case "mysql":
            $this->adapter = new Db_Mysqli();
            break;
        case "pgsql":
            $this->adapter = new Db_Pgsql();
            break;
        default:
            die("Unknown DB_TYPE: ".DB_TYPE);

        }

        if (!$this->adapter) {
            print("Error initializing database adapter for ".DB_TYPE);
            exit(100);

        }

        $this->link = $this->adapter->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, defined('DB_PORT') ? DB_PORT : "");


        if (!$this->link) {
            print("Error connecting through adapter: ".$this->adapter->last_error());
            exit(101);

        }

        error_reporting($er);
    }

    // this really shouldn't be used unless a separate PDO connection is needed
    // normal usage is Db::pdo()->prepare(...) etc
    public function pdo_connect() {

        $db_port = defined('DB_PORT') && DB_PORT ? ';port='.DB_PORT : '';

        $db_host = defined('DB_HOST') && DB_HOST ? ';host='.DB_HOST : '';


        try {
            $pdo = new PDO(DB_TYPE.':dbname='.DB_NAME.$db_host.$db_port,

                DB_USER,

                DB_PASS);

        } catch (Exception $e) {
            print "<pre>Exception while creating PDO object:".$e->getMessage()."</pre>";
            exit(101);

        }

        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        if (DB_TYPE == "pgsql") {

            $pdo->query("set client_encoding = 'UTF-8'");
            $pdo->query("set datestyle = 'ISO, european'");
            $pdo->query("set TIME ZONE 0");
            $pdo->query("set cpu_tuple_cost = 0.5");

        } else if (DB_TYPE == "mysql") {
            $pdo->query("SET time_zone = '+0:0'");

            if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {

                $pdo->query("SET NAMES ".MYSQL_CHARSET);
            }
        }

        return $pdo;
    }

    public static function instance() {
        if (self::$instance == null) {
                    self::$instance = new self();
        }

        return self::$instance;
    }

    public static function get() {
        if (self::$instance == null) {
                    self::$instance = new self();
        }

        if (!self::$instance->adapter) {
            self::$instance->legacy_connect();
        }

        return self::$instance->adapter;
    }

    public static function pdo() {
        if (self::$instance == null) {
                    self::$instance = new self();
        }

        if (!self::$instance->pdo) {
            self::$instance->pdo = self::$instance->pdo_connect();
        }

        return self::$instance->pdo;
    }
}


1			<?php
2			class Db
3			{
4
5			/* @var Db $instance */
6			private static $instance;
7
8			/* @var IDb $adapter */
9			private $adapter;
10
11			private $link;
12
13			/* @var PDO $pdo */
14			private $pdo;
15
16			private function __clone() {
17			//
18			}
19
20			private function legacy_connect() {
21
22			user_error("Legacy connect requested to ".DB_TYPE, E_USER_NOTICE);
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_TYPE` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
23
24			$er = error_reporting(E_ALL);
25
26			switch (DB_TYPE) {
27			case "mysql":
28			$this->adapter = new Db_Mysqli();
29			break;
30			case "pgsql":
31			$this->adapter = new Db_Pgsql();
32			break;
33			default:
34			die("Unknown DB_TYPE: ".DB_TYPE);
			0 ignored issues – show Best Practice introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report Using `exit` here is not recommended. In general, usage of exit should be done with care and only when running in a scripting context like a CLI script. Loading history...
35			}
36
37			if (!$this->adapter) {
38			print("Error initializing database adapter for ".DB_TYPE);
39			exit(100);
			0 ignored issues – show Best Practice introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report Using `exit` here is not recommended. In general, usage of exit should be done with care and only when running in a scripting context like a CLI script. Loading history...
40			}
41
42			$this->link = $this->adapter->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, defined('DB_PORT') ? DB_PORT : "");
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_PASS` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history... Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_HOST` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history... Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_PORT` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history... Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_USER` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history... Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_NAME` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
43
44			if (!$this->link) {
45			print("Error connecting through adapter: ".$this->adapter->last_error());
46			exit(101);
			0 ignored issues – show Best Practice introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report Using `exit` here is not recommended. In general, usage of exit should be done with care and only when running in a scripting context like a CLI script. Loading history...
47			}
48
49			error_reporting($er);
50			}
51
52			// this really shouldn't be used unless a separate PDO connection is needed
53			// normal usage is Db::pdo()->prepare(...) etc
54			public function pdo_connect() {
55
56			$db_port = defined('DB_PORT') && DB_PORT ? ';port='.DB_PORT : '';
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_PORT` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
57			$db_host = defined('DB_HOST') && DB_HOST ? ';host='.DB_HOST : '';
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_HOST` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
58
59			try {
60			$pdo = new PDO(DB_TYPE.':dbname='.DB_NAME.$db_host.$db_port,
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_TYPE` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history... Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_NAME` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
61			DB_USER,
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_USER` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
62			DB_PASS);
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `DB_PASS` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
63			} catch (Exception $e) {
64			print "<pre>Exception while creating PDO object:".$e->getMessage()."</pre>";
65			exit(101);
			0 ignored issues – show Best Practice introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report Using `exit` here is not recommended. In general, usage of exit should be done with care and only when running in a scripting context like a CLI script. Loading history...
66			}
67
68			$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
69
70			if (DB_TYPE == "pgsql") {
71
72			$pdo->query("set client_encoding = 'UTF-8'");
73			$pdo->query("set datestyle = 'ISO, european'");
74			$pdo->query("set TIME ZONE 0");
75			$pdo->query("set cpu_tuple_cost = 0.5");
76
77			} else if (DB_TYPE == "mysql") {
78			$pdo->query("SET time_zone = '+0:0'");
79
80			if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
			0 ignored issues – show Bug introduced 2019-12-19 19:08 UTC by Report Bug Copy Issue Report The constant `MYSQL_CHARSET` was not found. Maybe you did not declare it correctly or list all dependencies? Loading history...
81			$pdo->query("SET NAMES ".MYSQL_CHARSET);
82			}
83			}
84
85			return $pdo;
86			}
87
88			public static function instance() {
89			if (self::$instance == null) {
90			self::$instance = new self();
91			}
92
93			return self::$instance;
94			}
95
96			public static function get() {
97			if (self::$instance == null) {
98			self::$instance = new self();
99			}
100
101			if (!self::$instance->adapter) {
102			self::$instance->legacy_connect();
103			}
104
105			return self::$instance->adapter;
106			}
107
108			public static function pdo() {
109			if (self::$instance == null) {
110			self::$instance = new self();
111			}
112
113			if (!self::$instance->pdo) {
114			self::$instance->pdo = self::$instance->pdo_connect();
115			}
116
117			return self::$instance->pdo;
118			}
119			}
120

codysnider / tt-rss

Db::pdo_connect() B last analyzed 2019-12-23 07:25 UTC

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like

Db::pdo_connect() B
last analyzed 2019-12-23 07:25 UTC