CommandPDO::insertEx() - Code Metrics - Inspection of "Check and fix all todo in code" - yiisoft/db-pgsql - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — dev (#133)

by Def

created 2022-06-16 18:28 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\Pgsql;

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

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);

        /** @var mixed */
        $queryOne = $this->queryOne();

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

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

    public function schema(): SchemaInterface
    {
        return $this->db->getSchema();
    }

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

yiisoft / db-pgsql

Pull Request — dev (#133)

CommandPDO::insertEx() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like