SqliteDriverMetas::getForeignKeys() - Code Metrics - Inspection of "Add sqlite pdo driver" - phpMv/ubiquity - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Pull Request — master (#100)

unknown

created 2020-02-13 19:03 UTC

SqliteDriverMetas::getForeignKeys() A

↳ Parent: SqliteDriverMetas

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	2
c	1
b	0
f	0
dl	0
loc	3
rs	10
cc	1
nc	1
nop	3

<?php

namespace Ubiquity\db\providers\pdo\drivers;

/**
 * Ubiquity\db\providers\pdo\drivers$SqliteDriverMetas
 * This class is part of Ubiquity
 *
 * @author
 * @version 1.0.0
 *
 */
class SqliteDriverMetas extends AbstractDriverMetaDatas {

	public function getForeignKeys($tableName, $pkName, $dbName = null): array {
		$recordset = $this->dbInstance->query ( "SELECT \"TABLE\" as TABLE_NAME , \"to\" as COLUMN_NAME , \"from\" as REFERENCED_TABLE_SCHEMA FROM pragma_foreign_key_list('".$tableName."') WHERE \"to\"='".$pkName."';");
		return $recordset->fetchAll ( \PDO::FETCH_ASSOC );
	}

	public function getTablesName(): array {
		$query = $this->dbInstance->query ( 'SELECT name FROM sqlite_master WHERE type=\'table\';'  );
		return $query->fetchAll ( \PDO::FETCH_COLUMN );
	}

	public function getPrimaryKeys($tableName): array {
		$fieldkeys = array ();
		$recordset = $this->dbInstance->query ( "PRAGMA TABLE_INFO(".$table_name.");" );

		$keys = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
		foreach ( $keys as $key ) {
            if ($key['pk']==1) {
                $fieldkeys[] = $key['name'];
            }			
		}
		return $fieldkeys;
	}

	public function getFieldsInfos($tableName): array {
		$fieldsInfos = array ();
		$recordset = $this->dbInstance->query (  "PRAGMA TABLE_INFO(".$table_name.");" );

		$fields = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
		foreach ( $fields as $field ) {
			$fieldsInfos [$field ['name']] = [ "Type" => $field ['type'],"Nullable" => $field ["notnull"] ];
		}
		return $fieldsInfos;
	}
}



1			<?php
2
3			namespace Ubiquity\db\providers\pdo\drivers;
4
5			/**
6			* Ubiquity\db\providers\pdo\drivers$SqliteDriverMetas
7			* This class is part of Ubiquity
8			*
9			* @author
10			* @version 1.0.0
11			*
12			*/
13			class SqliteDriverMetas extends AbstractDriverMetaDatas {
14
15			public function getForeignKeys($tableName, $pkName, $dbName = null): array {
16			$recordset = $this->dbInstance->query ( "SELECT \"TABLE\" as TABLE_NAME , \"to\" as COLUMN_NAME , \"from\" as REFERENCED_TABLE_SCHEMA FROM pragma_foreign_key_list('".$tableName."') WHERE \"to\"='".$pkName."';");
17			return $recordset->fetchAll ( \PDO::FETCH_ASSOC );
18			}
19
20			public function getTablesName(): array {
21			$query = $this->dbInstance->query ( 'SELECT name FROM sqlite_master WHERE type=\'table\';' );
22			return $query->fetchAll ( \PDO::FETCH_COLUMN );
23			}
24
25			public function getPrimaryKeys($tableName): array {
26			$fieldkeys = array ();
27			$recordset = $this->dbInstance->query ( "PRAGMA TABLE_INFO(".$table_name.");" );
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-02-13 19:20 UTC by Report Bug Copy Issue Report The variable `$table_name` does not exist. Did you maybe mean `$tableName`? Loading history...
28			$keys = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
29			foreach ( $keys as $key ) {
30			if ($key['pk']==1) {
31			$fieldkeys[] = $key['name'];
32			}
33			}
34			return $fieldkeys;
35			}
36
37			public function getFieldsInfos($tableName): array {
38			$fieldsInfos = array ();
39			$recordset = $this->dbInstance->query ( "PRAGMA TABLE_INFO(".$table_name.");" );
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-02-13 19:20 UTC by Report Bug Copy Issue Report The variable `$table_name` does not exist. Did you maybe mean `$tableName`? Loading history...
40			$fields = $recordset->fetchAll ( \PDO::FETCH_ASSOC );
41			foreach ( $fields as $field ) {
42			$fieldsInfos [$field ['name']] = [ "Type" => $field ['type'],"Nullable" => $field ["notnull"] ];
43			}
44			return $fieldsInfos;
45			}
46			}
47
48

phpMv / ubiquity

Pull Request — master (#100)

SqliteDriverMetas::getForeignKeys() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like