PDOWrapper::getPrimaryKeys() - Code Metrics - Inspection of "Update myFirstFunctionalCept.php" - phpMv/ubiquity - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 9e15fe...1d956f )

by Jean-Christophe

created 2019-09-18 16:49 UTC

PDOWrapper::getPrimaryKeys() A

↳ Parent: PDOWrapper

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	7
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Ubiquity\db\providers\pdo;

use Ubiquity\db\providers\AbstractDbWrapper;

/**
 * Ubiquity\db\providers$PDOWrapper
 * This class is part of Ubiquity
 *
 * @author jcheron <[email protected]>
 * @version 1.0.0
 * @property \PDO $dbInstance
 *
 */
class PDOWrapper extends AbstractDbWrapper {
	protected static $savepointsDrivers = [ 'pgsql' => true,'mysql' => true,'sqlite' => true ];
	private static $quotes = [ 'mysql' => '`','sqlite' => '"','pgsql' => '"' ];
	protected $transactionLevel = 0;
	protected $dbType;

	public function __construct($dbType = 'mysql') {
		$this->quote = self::$quotes [$dbType] ?? '';
		$this->dbType = $dbType;
	}

	public function fetchAllColumn($statement, array $values = null, string $column = null) {
		$result = false;
		if ($statement->execute ( $values )) {
			$result = $statement->fetchAll ( \PDO::FETCH_COLUMN, $column );
		}
		$statement->closeCursor ();
		return $result;
	}

	public function lastInsertId() {
		return $this->dbInstance->lastInsertId ();
	}

	public function fetchAll($statement, array $values = null, $mode = null) {
		$result = false;
		if ($statement->execute ( $values )) {
			$result = $statement->fetchAll ( $mode );
		}
		$statement->closeCursor ();
		return $result;
	}

	public function fetchOne($statement, array $values = null, $mode = null) {
		$result = false;
		if ($statement->execute ( $values )) {
			$result = $statement->fetch ( $mode );
		}
		$statement->closeCursor ();
		return $result;
	}

	public static function getAvailableDrivers() {
		return \PDO::getAvailableDrivers ();
	}

	public function prepareStatement(string $sql) {
		return $this->dbInstance->prepare ( $sql );
	}

	public function fetchColumn($statement, array $values = null, int $columnNumber = null) {
		if ($statement->execute ( $values )) {
			return $statement->fetchColumn ( $columnNumber );
		}
		return false;
	}

	public function getStatement($sql) {
		$st = $this->dbInstance->prepare ( $sql );
		$st->setFetchMode ( \PDO::FETCH_ASSOC );
		return $st;
	}

	public function execute($sql) {
		return $this->dbInstance->exec ( $sql );
	}

	public function connect(string $dbType, $dbName, $serverName, string $port, string $user, string $password, array $options) {
		$options [\PDO::ATTR_ERRMODE] = \PDO::ERRMODE_EXCEPTION;
		$this->dbInstance = new \PDO ( $this->getDSN ( $serverName, $port, $dbName, $dbType ), $user, $password, $options );
	}

	public function getDSN(string $serverName, string $port, string $dbName, string $dbType = 'mysql') {
		return $dbType . ':dbname=' . $dbName . ';host=' . $serverName . ';charset=UTF8;port=' . $port;
	}

	public function bindValueFromStatement($statement, $parameter, $value) {
		return $statement->bindValue ( ":" . $parameter, $value );
	}

	public function query(string $sql) {
		return $this->dbInstance->query ( $sql );
	}

	public function queryAll(string $sql, int $fetchStyle = null) {
		return $this->dbInstance->query ( $sql )->fetchAll ( $fetchStyle );
	}

	public function queryColumn(string $sql, int $columnNumber = null) {
		return $this->dbInstance->query ( $sql )->fetchColumn ( $columnNumber );
	}

	public function executeStatement($statement, array $values = null) {
		return $statement->execute ( $values );
	}

	public function getTablesName() {
		$query = $this->dbInstance->query ( 'SHOW TABLES' );
		return $query->fetchAll ( \PDO::FETCH_COLUMN );
	}

	public function statementRowCount($statement) {
		return $statement->rowCount ();
	}

	public function inTransaction() {
		return $this->dbInstance->inTransaction ();
	}

	public function commit() {
		return $this->dbInstance->commit ();
	}

	public function rollBack() {
		return $this->dbInstance->rollBack ();
	}

	public function beginTransaction() {
		return $this->dbInstance->beginTransaction ();
	}

	public function savePoint($level) {
		$this->dbInstance->exec ( 'SAVEPOINT LEVEL' . $level );
	}

	public function releasePoint($level) {
		$this->dbInstance->exec ( 'RELEASE SAVEPOINT LEVEL' . $level );
	}

	public function rollbackPoint($level) {
		$this->dbInstance->exec ( 'ROLLBACK TO SAVEPOINT LEVEL' . $level );
	}

	public function nestable() {
		return isset ( self::$savepointsDrivers [$this->dbType] );
	}

	public function ping() {
		return ($this->dbInstance != null) && (1 === \intval ( $this->queryColumn ( 'SELECT 1', 0 ) ));
	}

	public function getPrimaryKeys($tableName) {
		$fieldkeys = array ();
		$recordset = $this->dbInstance->query ( "SHOW KEYS FROM `{$tableName}` WHERE Key_name = 'PRIMARY'" );
		$keys = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
		foreach ( $keys as $key ) {
			$fieldkeys [] = $key ['Column_name'];
		}
		return $fieldkeys;
	}

	public function getForeignKeys($tableName, $pkName, $dbName = null) {
		$recordset = $this->dbInstance->query ( "SELECT *
												FROM
												 information_schema.KEY_COLUMN_USAGE
												WHERE
												 REFERENCED_TABLE_NAME = '" . $tableName . "'
												 AND REFERENCED_COLUMN_NAME = '" . $pkName . "'
												 AND TABLE_SCHEMA = '" . $dbName . "';" );
		return $recordset->fetchAll ( \PDO::FETCH_ASSOC );
	}

	public function getFieldsInfos($tableName) {
		$fieldsInfos = array ();
		$recordset = $this->dbInstance->query ( "SHOW COLUMNS FROM `{$tableName}`" );
		$fields = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
		foreach ( $fields as $field ) {
			$fieldsInfos [$field ['Field']] = [ "Type" => $field ['Type'],"Nullable" => $field ["Null"] ];
		}
		return $fieldsInfos;
	}

	public function _optPrepareAndExecute($sql, array $values = null) {
		$statement = $this->_getStatement ( $sql );
		$result = false;
		if ($statement->execute ( $values )) {
			$result = $statement->fetchAll ( \PDO::FETCH_ASSOC );
		}
		$statement->closeCursor ();
		return $result;
	}
}

1		<?php
2
3		namespace Ubiquity\db\providers\pdo;
4
5		use Ubiquity\db\providers\AbstractDbWrapper;
6
7		/**
8		* Ubiquity\db\providers$PDOWrapper
9		* This class is part of Ubiquity
10		*
11		* @author jcheron <[email protected]>
12		* @version 1.0.0
13		* @property \PDO $dbInstance
14		*
15		*/
16		class PDOWrapper extends AbstractDbWrapper {
17		protected static $savepointsDrivers = [ 'pgsql' => true,'mysql' => true,'sqlite' => true ];
18		private static $quotes = [ 'mysql' => '`','sqlite' => '"','pgsql' => '"' ];
19		protected $transactionLevel = 0;
20		protected $dbType;
21
22	75	public function __construct($dbType = 'mysql') {
23	75	$this->quote = self::$quotes [$dbType] ?? '';
24	75	$this->dbType = $dbType;
25	75	}
26
27		public function fetchAllColumn($statement, array $values = null, string $column = null) {
28		$result = false;
29		if ($statement->execute ( $values )) {
30		$result = $statement->fetchAll ( \PDO::FETCH_COLUMN, $column );
31		}
32		$statement->closeCursor ();
33		return $result;
34		}
35
36	10	public function lastInsertId() {
37	10	return $this->dbInstance->lastInsertId ();
38		}
39
40	23	public function fetchAll($statement, array $values = null, $mode = null) {
41	23	$result = false;
42	23	if ($statement->execute ( $values )) {
43	23	$result = $statement->fetchAll ( $mode );
44		}
45	23	$statement->closeCursor ();
46	23	return $result;
47		}
48
49		public function fetchOne($statement, array $values = null, $mode = null) {
50		$result = false;
51		if ($statement->execute ( $values )) {
52		$result = $statement->fetch ( $mode );
53		}
54		$statement->closeCursor ();
55		return $result;
56		}
57
58	2	public static function getAvailableDrivers() {
59	2	return \PDO::getAvailableDrivers ();
60		}
61
62	7	public function prepareStatement(string $sql) {
63	7	return $this->dbInstance->prepare ( $sql );
64		}
65
66		public function fetchColumn($statement, array $values = null, int $columnNumber = null) {
67		if ($statement->execute ( $values )) {
68		return $statement->fetchColumn ( $columnNumber );
69		}
70		return false;
71		}
72
73	67	public function getStatement($sql) {
74	67	$st = $this->dbInstance->prepare ( $sql );
75	67	$st->setFetchMode ( \PDO::FETCH_ASSOC );
76	67	return $st;
77		}
78
79		public function execute($sql) {
80		return $this->dbInstance->exec ( $sql );
81		}
82
83	70	public function connect(string $dbType, $dbName, $serverName, string $port, string $user, string $password, array $options) {
84	70	$options [\PDO::ATTR_ERRMODE] = \PDO::ERRMODE_EXCEPTION;
85	70	$this->dbInstance = new \PDO ( $this->getDSN ( $serverName, $port, $dbName, $dbType ), $user, $password, $options );
86	70	}
87
88	70	public function getDSN(string $serverName, string $port, string $dbName, string $dbType = 'mysql') {
89	70	return $dbType . ':dbname=' . $dbName . ';host=' . $serverName . ';charset=UTF8;port=' . $port;
90		}
91
92		public function bindValueFromStatement($statement, $parameter, $value) {
93		return $statement->bindValue ( ":" . $parameter, $value );
94		}
95
96		public function query(string $sql) {
97		return $this->dbInstance->query ( $sql );
98		}
99
100		public function queryAll(string $sql, int $fetchStyle = null) {
101		return $this->dbInstance->query ( $sql )->fetchAll ( $fetchStyle );
102		}
103
104	5	public function queryColumn(string $sql, int $columnNumber = null) {
105	5	return $this->dbInstance->query ( $sql )->fetchColumn ( $columnNumber );
106		}
107
108		public function executeStatement($statement, array $values = null) {
109		return $statement->execute ( $values );
110		}
111
112	3	public function getTablesName() {
113	3	$query = $this->dbInstance->query ( 'SHOW TABLES' );
114	3	return $query->fetchAll ( \PDO::FETCH_COLUMN );
115		}
116
117		public function statementRowCount($statement) {
118		return $statement->rowCount ();
119		}
120
121		public function inTransaction() {
122		return $this->dbInstance->inTransaction ();
123		}
124
125	4	public function commit() {
126	4	return $this->dbInstance->commit ();
127		}
128
129	3	public function rollBack() {
130	3	return $this->dbInstance->rollBack ();
131		}
132
133	8	public function beginTransaction() {
134	8	return $this->dbInstance->beginTransaction ();
135		}
136
137	4	public function savePoint($level) {
138	4	$this->dbInstance->exec ( 'SAVEPOINT LEVEL' . $level );
139	4	}
140
141	2	public function releasePoint($level) {
142	2	$this->dbInstance->exec ( 'RELEASE SAVEPOINT LEVEL' . $level );
143	2	}
144
145	2	public function rollbackPoint($level) {
146	2	$this->dbInstance->exec ( 'ROLLBACK TO SAVEPOINT LEVEL' . $level );
147	2	}
148
149	4	public function nestable() {
150	4	return isset ( self::$savepointsDrivers [$this->dbType] );
151		}
152
153	2	public function ping() {
154	2	return ($this->dbInstance != null) && (1 === \intval ( $this->queryColumn ( 'SELECT 1', 0 ) ));
155		}
156
157	1	public function getPrimaryKeys($tableName) {
158	1	$fieldkeys = array ();
159	1	$recordset = $this->dbInstance->query ( "SHOW KEYS FROM `{$tableName}` WHERE Key_name = 'PRIMARY'" );
160	1	$keys = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
161	1	foreach ( $keys as $key ) {
162	1	$fieldkeys [] = $key ['Column_name'];
163		}
164	1	return $fieldkeys;
165		}
166
167	1	public function getForeignKeys($tableName, $pkName, $dbName = null) {
168	1	$recordset = $this->dbInstance->query ( "SELECT *
169		FROM
170		information_schema.KEY_COLUMN_USAGE
171		WHERE
172	1	REFERENCED_TABLE_NAME = '" . $tableName . "'
173	1	AND REFERENCED_COLUMN_NAME = '" . $pkName . "'
174	1	AND TABLE_SCHEMA = '" . $dbName . "';" );
175	1	return $recordset->fetchAll ( \PDO::FETCH_ASSOC );
176		}
177
178	1	public function getFieldsInfos($tableName) {
179	1	$fieldsInfos = array ();
180	1	$recordset = $this->dbInstance->query ( "SHOW COLUMNS FROM `{$tableName}`" );
181	1	$fields = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
182	1	foreach ( $fields as $field ) {
183	1	$fieldsInfos [$field ['Field']] = [ "Type" => $field ['Type'],"Nullable" => $field ["Null"] ];
184		}
185	1	return $fieldsInfos;
186		}
187
188	59	public function _optPrepareAndExecute($sql, array $values = null) {
189	59	$statement = $this->_getStatement ( $sql );
190	59	$result = false;
191	59	if ($statement->execute ( $values )) {
192	59	$result = $statement->fetchAll ( \PDO::FETCH_ASSOC );
193		}
194	59	$statement->closeCursor ();
195	59	return $result;
196		}
197		}

phpMv / ubiquity

Push — master ( 9e15fe...1d956f )

PDOWrapper::getPrimaryKeys() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like