Passed
Pull Request — master (#126)
by Wilmer
25:49 queued 21:45
created

CommandPDO   A

Complexity

Total Complexity 12

Size/Duplication

Total Lines 49
Duplicated Lines 0 %

Test Coverage

Coverage 87.5%

Importance

Changes 0
Metric Value
eloc 25
dl 0
loc 49
ccs 21
cts 24
cp 0.875
rs 10
c 0
b 0
f 0
wmc 12

3 Methods

Rating   Name   Duplication   Size   Complexity  
B internalExecute() 0 25 9
A queryBuilder() 0 3 1
A insertEx() 0 12 2
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Yiisoft\Db\Mssql;
6
7
use PDOException;
8
use Yiisoft\Db\Driver\PDO\CommandPDO as AbstractCommandPDO;
9
use Yiisoft\Db\Exception\ConvertException;
10
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;
11
12
use function is_array;
13
14
final class CommandPDO extends AbstractCommandPDO
15
{
16
    /**
17
     * @inheritDoc
18
     */
19 6
    public function insertEx(string $table, array $columns): bool|array
20
    {
21 6
        $params = [];
22 6
        $sql = $this->queryBuilder()->insertEx($table, $columns, $params);
23
24 6
        $this->setSql($sql)->bindValues($params);
25 6
        $this->prepare(false);
26
27
        /** @psalm-var array|bool $result */
28 6
        $result = $this->queryOne();
29
30 6
        return is_array($result) ? $result : false;
31
    }
32
33 236
    public function queryBuilder(): QueryBuilderInterface
34
    {
35 236
        return $this->db->getQueryBuilder();
36
    }
37
38 199
    protected function internalExecute(string|null $rawSql): void
39
    {
40 199
        $attempt = 0;
41
42 199
        while (true) {
43
            try {
44
                if (
45
                    ++$attempt === 1
46 199
                    && $this->isolationLevel !== null
47 199
                    && $this->db->getTransaction() === null
48
                ) {
49
                    $this->db->transaction(
50
                        fn (string $rawSql) => $this->internalExecute($rawSql),
51
                        $this->isolationLevel
52
                    );
53
                } else {
54 199
                    $this->pdoStatement?->execute();
55
                }
56 198
                break;
57 10
            } catch (PDOException $e) {
58 10
                $rawSql = $rawSql ?: $this->getRawSql();
59 10
                $e = (new ConvertException($e, $rawSql))->run();
60
61 10
                if ($this->retryHandler === null || !($this->retryHandler)($e, $attempt)) {
62 10
                    throw $e;
63
                }
64
            }
65
        }
66
    }
67
}
68