CommandPDO::insertEx() - Code Metrics - Inspection of "Rework all tests." - yiisoft/db-mssql - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#126)

by Wilmer

created 2022-11-20 18:48 UTC

CommandPDO::insertEx() A

↳ Parent: CommandPDO

Complexity

Conditions	2
Paths	2

Size

Total Lines	12
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	7
CRAP Score	2

Importance

Changes

Metric	Value
cc	2
eloc	6
nc	2
nop	2
dl	0
loc	12
ccs	7
cts	7
cp	1
crap	2
rs	10
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mssql;

use PDOException;
use Yiisoft\Db\Driver\PDO\CommandPDO as AbstractCommandPDO;
use Yiisoft\Db\Exception\ConvertException;
use Yiisoft\Db\QueryBuilder\QueryBuilderInterface;

use function is_array;

final class CommandPDO extends AbstractCommandPDO
{
    /**
     * @inheritDoc
     */
    public function insertEx(string $table, array $columns): bool|array
    {
        $params = [];
        $sql = $this->queryBuilder()->insertEx($table, $columns, $params);

        $this->setSql($sql)->bindValues($params);
        $this->prepare(false);

        /** @psalm-var array|bool $result */
        $result = $this->queryOne();

        return is_array($result) ? $result : false;
    }

    public function queryBuilder(): QueryBuilderInterface
    {
        return $this->db->getQueryBuilder();
    }

    protected function internalExecute(string|null $rawSql): void
    {
        $attempt = 0;

        while (true) {
            try {
                if (
                    ++$attempt === 1
                    && $this->isolationLevel !== null
                    && $this->db->getTransaction() === null
                ) {
                    $this->db->transaction(
                        fn (string $rawSql) => $this->internalExecute($rawSql),
                        $this->isolationLevel
                    );
                } else {
                    $this->pdoStatement?->execute();
                }
                break;
            } catch (PDOException $e) {
                $rawSql = $rawSql ?: $this->getRawSql();
                $e = (new ConvertException($e, $rawSql))->run();

                if ($this->retryHandler === null || !($this->retryHandler)($e, $attempt)) {
                    throw $e;
                }
            }
        }
    }
}


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

yiisoft / db-mssql

Pull Request — master (#126)

CommandPDO::insertEx() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like