Passed
Pull Request — master (#380)
by Wilmer
04:10 queued 01:20
created

DbHelper::replaceQuotes()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 6

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 6
c 1
b 0
f 0
nc 1
nop 2
dl 0
loc 8
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Yiisoft\Db\Tests\Support;
6
7
final class DbHelper
8
{
9
    /**
10
     * Adjust dbms specific escaping.
11
     *
12
     * @param string $sql string SQL statement to adjust.
13
     * @param string $drivername string DBMS name.
14
     *
15
     * @return mixed
16
     */
17
    public static function replaceQuotes(string $sql, string $drivername): string
18
    {
19
        return match ($drivername) {
20
            'mysql', 'sqlite' => str_replace(['[[', ']]'], '`', $sql),
21
            'oci' => str_replace(['[[', ']]'], '"', $sql),
22
            'pgsql' => str_replace(['\\[', '\\]'], ['[', ']'], preg_replace('/(\[\[)|((?<!(\[))]])/', '"', $sql)),
23
            'sqlsrv' => str_replace(['[[', ']]'], ['[', ']'], $sql),
24
            default => $sql,
25
        };
26
    }
27
}
28