StmtCache::getCachedStmt() - Code Metrics - Inspection of "Factor out stmt cache" - Level-2/Maphper - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5b283a...d58ab5 )

by Richard

created 2017-12-30 17:42 UTC

StmtCache::getCachedStmt() A

↳ Parent: StmtCache

Complexity

Conditions	3
Paths	3

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
eloc	6
nc	3
nop	1
dl	0
loc	8
rs	9.4285
c	0
b	0
f	0

<?php
namespace Maphper\DataSource;
class StmtCache {
    private $pdo;
    private $queryCache = [];

    public function __construct(\PDO $pdo) {
        $this->pdo = $pdo;
    }

    public function getCachedStmt($sql) {
		$queryId = $this->getQueryId($sql);
		if (isset($this->queryCache[$queryId])) $stmt = $this->queryCache[$queryId];
		else {
			$stmt = $this->pdo->prepare($sql, [\PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY]);
			if ($stmt) $this->queryCache[$queryId] = $stmt;
		}
		return $stmt;
	}

    private function getQueryId($sql) {
        return md5($sql);
    }

    public function deleteQueryFromCache($sql) {
        unset($this->queryCache[$this->getQueryId($sql)]);
    }
}


1			<?php
2			namespace Maphper\DataSource;
3			class StmtCache {
4			private $pdo;
5			private $queryCache = [];
6
7			public function __construct(\PDO $pdo) {
8			$this->pdo = $pdo;
9			}
10
11			public function getCachedStmt($sql) {
12			$queryId = $this->getQueryId($sql);
13			if (isset($this->queryCache[$queryId])) $stmt = $this->queryCache[$queryId];
14			else {
15			$stmt = $this->pdo->prepare($sql, [\PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY]);
16			if ($stmt) $this->queryCache[$queryId] = $stmt;
17			}
18			return $stmt;
19			}
20
21			private function getQueryId($sql) {
22			return md5($sql);
23			}
24
25			public function deleteQueryFromCache($sql) {
26			unset($this->queryCache[$this->getQueryId($sql)]);
27			}
28			}
29

Level-2 / Maphper

Push — master ( 5b283a...d58ab5 )

StmtCache::getCachedStmt() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like