Yiisoft\Db\Tests\Support\DbHelper

Complexity

Total Complexity

1

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	replaceQuotes()	0	8	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Tests\Support;

use function preg_replace;
use function str_replace;

final class DbHelper
{
    /**
     * Adjust dbms specific escaping.
     *
     * @param string $sql string SQL statement to adjust.
     * @param string $drivername string DBMS name.
     *
     * @return mixed
     */
    public static function replaceQuotes(string $sql, string $drivername): string
    {
        return match ($drivername) {
            'mysql', 'sqlite' => str_replace(['[[', ']]'], '`', $sql),
            'oci' => str_replace(['[[', ']]'], '"', $sql),
            'pgsql' => str_replace(['\\[', '\\]'], ['[', ']'], preg_replace('/(\[\[)|((?<!(\[))]])/', '"', $sql)),
            'sqlsrv' => str_replace(['[[', ']]'], ['[', ']'], $sql),
            default => $sql,
        };
    }
}