Ajde_Db_PDO::query() - Code Metrics - nabble/ajde - Measure and Improve Code Quality continuously with Scrutinizer

Ajde_Db_PDO::query() B
last analyzed 2016-09-18 20:02 UTC

↳ Parent: Ajde_Db_PDO

Complexity

Conditions	4
Paths	4

Size

Total Lines	34
Code Lines	18

Duplication

Lines	10
Ratio	29.41 %

Importance

Changes

Metric	Value
cc	4
eloc	18
nc	4
nop	1
dl	10
loc	34
rs	8.5806
c	0
b	0
f	0

<?php
/**
 * @source http://www.coderholic.com/php-database-query-logging-with-pdo/
 * Modified for use with Ajde_Document_Processor_Html_Debugger
 */

/**
 * Extends PDO and logs all queries that are executed and how long
 * they take, including queries issued via prepared statements.
 */
class Ajde_Db_PDO extends PDO
{
    public static $log = [];

    public function __construct($dsn, $username = null, $password = null, $options = [])
    {
        $options = $options + [
                PDO::ATTR_STATEMENT_CLASS => ['Ajde_Db_PDOStatement', [$this]],
            ];
        parent::__construct($dsn, $username, $password, $options);
    }

    public function query($query)
    {
        //$cache = Ajde_Db_Cache::getInstance();
        $log = ['query' => $query];
        $start = microtime(true);
        //if (!$cache->has($query)) {

        try {
            $result = parent::query($query);
        } catch (Exception $e) {
            if (config('app.debug') === true) {

                if (isset($this->queryString)) {
                    dump($this->queryString);
class MyClass { }

$x = new MyClass();
$x->foo = true;
                }
                dump('Go to '.config('app.rootUrl').'?install=1 to install DB');
                throw new Ajde_Db_Exception($e->getMessage());
            } else {
                Ajde_Exception_Log::logException($e);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
                die('DB connection problem. <a href="?install=1">Install database?</a>');
            }
        }

        //$cache->set($query, serialize($result));
        //	$log['cache'] = false;
        //} else {
        //	$result = $cache->get($query);
        //	$log['cache'] = true;
        //}
        $time = microtime(true) - $start;
        $log['time'] = round($time * 1000, 0);
        self::$log[] = $log;

        return $result;
    }

    public static function getLog()
    {
        return self::$log;
    }
}


1		<?php
2		/**
3		* @source http://www.coderholic.com/php-database-query-logging-with-pdo/
4		* Modified for use with Ajde_Document_Processor_Html_Debugger
5		*/
6
7		/**
8		* Extends PDO and logs all queries that are executed and how long
9		* they take, including queries issued via prepared statements.
10		*/
11		class Ajde_Db_PDO extends PDO
12		{
13		public static $log = [];
14
15		public function __construct($dsn, $username = null, $password = null, $options = [])
16		{
17		$options = $options + [
18		PDO::ATTR_STATEMENT_CLASS => ['Ajde_Db_PDOStatement', [$this]],
19		];
20		parent::__construct($dsn, $username, $password, $options);
21		}
22
23		public function query($query)
24		{
25		//$cache = Ajde_Db_Cache::getInstance();
26		$log = ['query' => $query];
27		$start = microtime(true);
28		//if (!$cache->has($query)) {
29
30		try {
31		$result = parent::query($query);
32		} catch (Exception $e) {
33	View Code Duplication	if (config('app.debug') === true) {
		0 ignored issues – show Duplication introduced 2015-12-10 15:15 UTC by Report Bug Copy Issue Report This code seems to be duplicated across 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...
34		if (isset($this->queryString)) {
35		dump($this->queryString);
		0 ignored issues – show Bug introduced 2015-12-10 15:15 UTC by Report Bug Copy Issue Report The property `queryString` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
36		}
37		dump('Go to '.config('app.rootUrl').'?install=1 to install DB');
38		throw new Ajde_Db_Exception($e->getMessage());
39		} else {
40		Ajde_Exception_Log::logException($e);
		0 ignored issues – show Documentation introduced 2016-09-18 20:01 UTC by Report Bug Copy Issue Report `$e` is of type `object<Exception>`, but the function expects a `object<Throwable>`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
41		die('DB connection problem. <a href="?install=1">Install database?</a>');
42		}
43		}
44
45		//$cache->set($query, serialize($result));
46		// $log['cache'] = false;
47		//} else {
48		// $result = $cache->get($query);
49		// $log['cache'] = true;
50		//}
51		$time = microtime(true) - $start;
52		$log['time'] = round($time * 1000, 0);
53		self::$log[] = $log;
54
55		return $result;
56		}
57
58		public static function getLog()
59		{
60		return self::$log;
61		}
62		}
63

nabble / ajde

Ajde_Db_PDO::query() B last analyzed 2016-09-18 20:02 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Ajde_Db_PDO::query() B
last analyzed 2016-09-18 20:02 UTC