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 21:49 UTC

Helper::getIdentifierQuoter() A

↳ Parent: Helper

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	14
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	6
nc	2
nop	1

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

rrelmy / rorm

Pull Request — master (#3)

Helper::getIdentifierQuoter() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like