Helper::quote() - 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 19:35 UTC

Helper::quote() C

↳ Parent: Helper

Complexity

Conditions	8
Paths	8

Size

Total Lines	25
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	12
CRAP Score	8

Importance

Changes

Metric	Value
dl	0
loc	25
c	0
b	0
f	0
ccs	12
cts	12
cp	1
rs	5.3846
cc	8
eloc	12
nc	8
nop	2
crap	8

<?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)
    {
        if (is_bool($value)) {
            /**
             * MySQL has true and false literals
             * SQLite does not support boolean type nor literals
             */
            if ($this->isMySQL($dbh)) {
                return $value ? 'TRUE' : 'FALSE';
            }

            return $value ? 1 : 0;
        }
        if ($value === null) {
            return 'NULL';
        }
        if (is_int($value)) {
            return (int)$value;
        }
        if (is_float($value)) {
            return (float)$value;
        }

        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	2	public function isMySQL(\PDO $dbh): bool
12		{
13	2	return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'mysql';
14		}
15
16	2	public function isSQLite(\PDO $dbh): bool
17		{
18	2	return $dbh->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'sqlite';
19		}
20
21	3	public function quote(\PDO $dbh, $value)
22		{
23	3	if (is_bool($value)) {
24		/**
25		* MySQL has true and false literals
26		* SQLite does not support boolean type nor literals
27		*/
28	2	if ($this->isMySQL($dbh)) {
29	1	return $value ? 'TRUE' : 'FALSE';
30		}
31
32	1	return $value ? 1 : 0;
33		}
34	1	if ($value === null) {
35	1	return 'NULL';
36		}
37	1	if (is_int($value)) {
38	1	return (int)$value;
39		}
40	1	if (is_float($value)) {
41	1	return (float)$value;
42		}
43
44	1	return $dbh->quote($value);
45		}
46
47		/**
48		* Method to quote identifiers
49		* Please make sure you keep the quoter as long you are needing it.
50		*/
51	8	public function getIdentifierQuoter(\PDO $dbh): callable
52		{
53	8	if ($this->isMySQL($dbh)) {
54		// mysql mode
55	4	return function ($identifier) {
56	4	return '`' . str_replace('`', '``', $identifier) . '`';
57	4	};
58		}
59
60		// standard sql mode
61	4	return function ($identifier) {
62	4	return '"' . str_replace('"', '""', $identifier) . '"';
63	4	};
64		}
65		}
66

rrelmy / rorm

Pull Request — master (#3)

Helper::quote() C

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like