Xhgui\Db\PdoWrapper

Complexity

Total Complexity

4

Size/Duplication

Total Lines	44
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	create()	0	16	1
A	quoteIdentifier()	0	4	1
A	getQuoteIdentifier()	0	16	2

<?php

namespace Xhgui\Db;

use PDO;
use PDOException;

class PdoWrapper extends PDO
{
    /** @var string */
    private $quoteIdentifier;

    public static function create(array $options): self
    {
        $pdoOptions = [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        ];
        $pdo = new self(
            $options['dsn'],
            $options['user'],
            $options['pass'],
            $pdoOptions
        );

        $pdo->quoteIdentifier = self::getQuoteIdentifier($options['dsn']);

        return $pdo;
    }

    public function quoteIdentifier(string $identifier)
    {
        return sprintf('%c%s%c', $this->quoteIdentifier, $identifier, $this->quoteIdentifier);
    }

    private static function getQuoteIdentifier(string $dsn): string
    {
        $adapter = explode(':', $dsn, 2)[0];
        $identifierMap = [
            'mysql' => '`',
            'pgsql' => '"',
            'sqlite' => '"',
        ];
        $quoteIdentifier = $identifierMap[$adapter] ?? null;

        if ($quoteIdentifier === null) {
            throw new PdoException("Unsupported adapter '$adapter' to detect quote identifier");
        }

        return $quoteIdentifier;
    }
}