DBUtils::countResults() - Code Metrics - Inspection of "Load DATA For Insert and Update working for sqlser..." - edyan/neuralyzer - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( dd9cb8...6d15c1 )

by Emmanuel

created 2018-05-12 21:11 UTC

DBUtils::countResults() A

↳ Parent: DBUtils

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	4
CRAP Score	1

Importance

Changes

Metric	Value
dl	0
loc	7
ccs	4
cts	4
cp	1
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	4
nc	1
nop	1
crap	1

<?php
/**
 * neuralyzer : Data Anonymization Library and CLI Tool
 *
 * PHP Version 7.1
 *
 * @author Emmanuel Dyan
 * @author Rémi Sauvat
 * @copyright 2018 Emmanuel Dyan
 *
 * @package edyan/neuralyzer
 *
 * @license GNU General Public License v2.0
 *
 * @link https://github.com/edyan/neuralyzer
 */

namespace Edyan\Neuralyzer\Utils;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Query\QueryBuilder;
use Edyan\Neuralyzer\Exception\NeuralizerException;

/**
 * A few generic methods to help interacting with DB
 */
class DBUtils
{
    /**
     * Doctrine DBAL Connection
     * @var Connection
     */
    private $conn;

    /**
     * Set the connection (dependency)
     * @param Connection $conn
     */
    public function __construct(Connection $conn)
    {
        $this->conn = $conn;
    }


    /**
     * Do a simple count for a table
     * @param  string $table
     * @return int
     */
    public function countResults(string $table): int
    {
        $queryBuilder = $this->conn->createQueryBuilder();
        $rows = $queryBuilder->select('COUNT(1)')->from($table)->execute();

        return (int)$rows->fetch(\Doctrine\DBAL\FetchMode::NUMERIC)[0];
    }


    /**
     * Identify the primary key for a table
     * @param  string $table
     * @return string Field's name
     */
    public function getPrimaryKey(string $table): string
    {
        $schema = $this->conn->getSchemaManager();
        $tableDetails = $schema->listTableDetails($table);
        if ($tableDetails->hasPrimaryKey() === false) {
            throw new NeuralizerException("Can't find a primary key for '{$table}'");
        }

        return $tableDetails->getPrimaryKey()->getColumns()[0];
    }


    /**
     * Retrieve columns list for a table with type and length
     * @param  string $table
     * @return array $cols
     */
    public function getTableCols(string $table): array
    {
        $schema = $this->conn->getSchemaManager();
        $tableCols = $schema->listTableColumns($table);
        $cols = [];
        foreach ($tableCols as $col) {
            $cols[$col->getName()] = [
                'length' => $col->getLength(),
                'type'   => $col->getType(),
                'unsigned' => $col->getUnsigned(),
            ];
        }

        return $cols;
    }


    /**
     * To debug, build the final SQL (can be approximative)
     * @param  QueryBuilder $queryBuilder
     * @return string
     */
    public function getRawSQL(QueryBuilder $queryBuilder)
    {
        $sql = $queryBuilder->getSQL();
        foreach ($queryBuilder->getParameters() as $parameter => $value) {
            $sql = str_replace($parameter, "'$value'", $sql);
        }

        return $sql;
    }


    public function assertTableExists(string $table)
    {
        $schema = $this->conn->getSchemaManager();
        if ($schema->tablesExist($table) === false) {
function acceptsInteger($int) { }

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

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
            throw new NeuralizerException("Table $table does not exist");
        }
    }


    /**
     * Build the condition by casting the value if needed
     *
     * @param  string $field
     * @return string
     */
    public function getCondition(string $field, array $fieldConf): string
    {
        $type = strtolower($fieldConf['type']);
        $unsigned = $fieldConf['unsigned'];

        $integerCast = $this->getIntegerCast($unsigned);

        $condition = "(CASE $field WHEN NULL THEN NULL ELSE :$field END)";

        $typeToCast = [
            'date'     => 'DATE',
            'datetime' => 'DATE',
            'time'     => 'TIME',
            'smallint' => $integerCast,
            'integer'  => $integerCast,
            'bigint'   => $integerCast,
            'float'    => 'DECIMAL',
            'decimal'  => 'DECIMAL',
        ];

        // No cast required
        if (!array_key_exists($type, $typeToCast)) {
            return $condition;
        }

        return "CAST($condition AS {$typeToCast[$type]})";
    }


    /**
     * Get the right CAST for an INTEGER
     *
     * @param  string $field
/**
 * @param array $germany
 * @param array $island
 * @param array $italy
 */
function finale($germany, $island) {
    return "2:1";
}
     * @return string
     */
    private function getIntegerCast(bool $unsigned): string
    {
        $driver = $this->conn->getDriver();
        if (strpos($driver->getName(), 'mysql')) {
            return $unsigned === true ? 'UNSIGNED' : 'SIGNED';
        }

        return 'INTEGER';
    }
}


1		<?php
2		/**
3		* neuralyzer : Data Anonymization Library and CLI Tool
4		*
5		* PHP Version 7.1
6		*
7		* @author Emmanuel Dyan
8		* @author Rémi Sauvat
9		* @copyright 2018 Emmanuel Dyan
10		*
11		* @package edyan/neuralyzer
12		*
13		* @license GNU General Public License v2.0
14		*
15		* @link https://github.com/edyan/neuralyzer
16		*/
17
18		namespace Edyan\Neuralyzer\Utils;
19
20		use Doctrine\DBAL\Connection;
21		use Doctrine\DBAL\Query\QueryBuilder;
22		use Edyan\Neuralyzer\Exception\NeuralizerException;
23
24		/**
25		* A few generic methods to help interacting with DB
26		*/
27		class DBUtils
28		{
29		/**
30		* Doctrine DBAL Connection
31		* @var Connection
32		*/
33		private $conn;
34
35		/**
36		* Set the connection (dependency)
37		* @param Connection $conn
38		*/
39	10	public function __construct(Connection $conn)
40		{
41	10	$this->conn = $conn;
42	10	}
43
44
45		/**
46		* Do a simple count for a table
47		* @param string $table
48		* @return int
49		*/
50	3	public function countResults(string $table): int
51		{
52	3	$queryBuilder = $this->conn->createQueryBuilder();
53	3	$rows = $queryBuilder->select('COUNT(1)')->from($table)->execute();
54
55	3	return (int)$rows->fetch(\Doctrine\DBAL\FetchMode::NUMERIC)[0];
56		}
57
58
59		/**
60		* Identify the primary key for a table
61		* @param string $table
62		* @return string Field's name
63		*/
64	8	public function getPrimaryKey(string $table): string
65		{
66	8	$schema = $this->conn->getSchemaManager();
67	8	$tableDetails = $schema->listTableDetails($table);
68	8	if ($tableDetails->hasPrimaryKey() === false) {
69	1	throw new NeuralizerException("Can't find a primary key for '{$table}'");
70		}
71
72	7	return $tableDetails->getPrimaryKey()->getColumns()[0];
73		}
74
75
76		/**
77		* Retrieve columns list for a table with type and length
78		* @param string $table
79		* @return array $cols
80		*/
81	7	public function getTableCols(string $table): array
82		{
83	7	$schema = $this->conn->getSchemaManager();
84	7	$tableCols = $schema->listTableColumns($table);
85	7	$cols = [];
86	7	foreach ($tableCols as $col) {
87	7	$cols[$col->getName()] = [
88	7	'length' => $col->getLength(),
89	7	'type' => $col->getType(),
90	7	'unsigned' => $col->getUnsigned(),
91		];
92		}
93
94	7	return $cols;
95		}
96
97
98		/**
99		* To debug, build the final SQL (can be approximative)
100		* @param QueryBuilder $queryBuilder
101		* @return string
102		*/
103	3	public function getRawSQL(QueryBuilder $queryBuilder)
104		{
105	3	$sql = $queryBuilder->getSQL();
106	3	foreach ($queryBuilder->getParameters() as $parameter => $value) {
107	3	$sql = str_replace($parameter, "'$value'", $sql);
108		}
109
110	3	return $sql;
111		}
112
113
114	9	public function assertTableExists(string $table)
115		{
116	9	$schema = $this->conn->getSchemaManager();
117	9	if ($schema->tablesExist($table) === false) {
		0 ignored issues – show Documentation introduced 2018-03-18 20:08 UTC by Report Bug Copy Issue Report `$table` is of type `string`, but the function expects a `array`. 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...
118	1	throw new NeuralizerException("Table $table does not exist");
119		}
120	8	}
121
122
123		/**
124		* Build the condition by casting the value if needed
125		*
126		* @param string $field
127		* @return string
128		*/
129	3	public function getCondition(string $field, array $fieldConf): string
130		{
131	3	$type = strtolower($fieldConf['type']);
132	3	$unsigned = $fieldConf['unsigned'];
133
134	3	$integerCast = $this->getIntegerCast($unsigned);
135
136	3	$condition = "(CASE $field WHEN NULL THEN NULL ELSE :$field END)";
137
138		$typeToCast = [
139	3	'date' => 'DATE',
140	3	'datetime' => 'DATE',
141	3	'time' => 'TIME',
142	3	'smallint' => $integerCast,
143	3	'integer' => $integerCast,
144	3	'bigint' => $integerCast,
145	3	'float' => 'DECIMAL',
146	3	'decimal' => 'DECIMAL',
147		];
148
149		// No cast required
150	3	if (!array_key_exists($type, $typeToCast)) {
151	3	return $condition;
152		}
153
154	3	return "CAST($condition AS {$typeToCast[$type]})";
155		}
156
157
158		/**
159		* Get the right CAST for an INTEGER
160		*
161		* @param string $field
		0 ignored issues – show Bug introduced 2018-05-12 21:16 UTC by Report Bug Copy Issue Report There is no parameter named `$field`. Was it maybe removed? This check looks for PHPDoc comments describing methods or function parameters that do not exist on the corresponding method or function. Consider the following example. The parameter `$italy` is not defined by the method `finale(...)`. /** * @param array $germany * @param array $island * @param array $italy */ function finale($germany, $island) { return "2:1"; } The most likely cause is that the parameter was removed, but the annotation was not. Loading history...
162		* @return string
163		*/
164	3	private function getIntegerCast(bool $unsigned): string
165		{
166	3	$driver = $this->conn->getDriver();
167	3	if (strpos($driver->getName(), 'mysql')) {
168	3	return $unsigned === true ? 'UNSIGNED' : 'SIGNED';
169		}
170
171		return 'INTEGER';
172		}
173		}
174

edyan / neuralyzer

Push — master ( dd9cb8...6d15c1 )

DBUtils::countResults() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like