Helper::getIdentifierQuoter() - Code Metrics - Inspection of "Prepare Version 1.0" - rrelmy/rorm - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#3)

by Rémy

created 2017-10-08 22:35 UTC

Helper::getIdentifierQuoter() A

↳ Parent: Helper

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	2

Importance

Changes

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

<?php
/**
 * @author Rémy M. Böhler <[email protected]>
 */
declare(strict_types=1);

namespace Rorm;

class Helper
{
    public function isMySQL(\PDO $dbh): bool
    {
        return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'mysql';
    }

    public function isSQLite(\PDO $dbh): bool
    {
        return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'sqlite';
    }

    public function quote(\PDO $dbh, $value)
    {
        switch (true) {
            case is_bool($value):
                if ($this->isMySQL($dbh)) {
                    return $value ? 'TRUE' : 'FALSE';
                }
                return $value ? 1 : 0;
            case $value === null:
                return 'NULL';
            case is_int($value):
                return (int)$value;
            case is_float($value):
                return (float)$value;
            default:
                return $dbh->quote($value);
        }
    }

    /**
     * Method to quote identifiers
     * Please make sure you keep the quoter as long you are needing it.
     */
    public function getIdentifierQuoter(\PDO $dbh): callable
    {
        if ($this->isMySQL($dbh)) {
            // mysql mode
            return function ($identifier) {
                return '`' . str_replace('`', '``', $identifier) . '`';
            };
        }

        // standard sql mode
        return function ($identifier) {
            return '"' . str_replace('"', '""', $identifier) . '"';
        };
    }
}


1		<?php
2		/**
3		* @author Rémy M. Böhler <[email protected]>
4		*/
5		declare(strict_types=1);
6
7		namespace Rorm;
8
9		class Helper
10		{
11	4	public function isMySQL(\PDO $dbh): bool
12		{
13	4	return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'mysql';
14		}
15
16	4	public function isSQLite(\PDO $dbh): bool
17		{
18	4	return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'sqlite';
19		}
20
21	6	public function quote(\PDO $dbh, $value)
22		{
23		switch (true) {
24	6	case is_bool($value):
25	4	if ($this->isMySQL($dbh)) {
26	2	return $value ? 'TRUE' : 'FALSE';
27		}
28	2	return $value ? 1 : 0;
29	2	case $value === null:
30	2	return 'NULL';
31	2	case is_int($value):
32	2	return (int)$value;
33	2	case is_float($value):
34	2	return (float)$value;
35		default:
36	2	return $dbh->quote($value);
37		}
38		}
39
40		/**
41		* Method to quote identifiers
42		* Please make sure you keep the quoter as long you are needing it.
43		*/
44	16	public function getIdentifierQuoter(\PDO $dbh): callable
45		{
46	16	if ($this->isMySQL($dbh)) {
47		// mysql mode
48	8	return function ($identifier) {
49	8	return '`' . str_replace('`', '``', $identifier) . '`';
50	8	};
51		}
52
53		// standard sql mode
54	8	return function ($identifier) {
55	8	return '"' . str_replace('"', '""', $identifier) . '"';
56	8	};
57		}
58		}
59

rrelmy / rorm

Pull Request — master (#3)

Helper::getIdentifierQuoter() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like