Rorm\Helper

Complexity

Total Complexity

12

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	isMySQL()	0	4	1
A	isSQLite()	0	4	1
C	quote()	0	25	8
A	getIdentifierQuoter()	0	14	2

<?php
/**
 * @author Rémy M. Böhler <code@rrelmy.ch>
 */
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) . '"';
        };
    }
}