TransactionPDO::setTransactionIsolationLevel() - Code Metrics - Inspection of "3d872570ee04c6a9567ffbdae2908ba68681d367" - yiisoft/db-sqlite - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — master (3d8725)

by Wilmer

created 2022-12-20 10:39 UTC

TransactionPDO::setTransactionIsolationLevel() A

↳ Parent: TransactionPDO

Complexity

Conditions	3
Paths	3

Size

Total Lines	12
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	9
CRAP Score	3

Importance

Changes

Metric	Value
eloc	10
c	0
b	0
f	0
dl	0
loc	12
ccs	9
cts	9
cp	1
rs	9.9332
cc	3
nc	3
nop	1
crap	3

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite;

use Throwable;
use Yiisoft\Db\Driver\PDO\TransactionPDO as AbstractTransactionPDO;
use Yiisoft\Db\Exception\Exception;
use Yiisoft\Db\Exception\InvalidConfigException;
use Yiisoft\Db\Exception\NotSupportedException;
use Yiisoft\Db\Transaction\TransactionInterface;

final class TransactionPDO extends AbstractTransactionPDO
{
    /**
     * Sets the isolation level of the current transaction.
     *
     * @param string $level The transaction isolation level to use for this transaction. This can be either
     * {@see TransactionInterface::READ_UNCOMMITTED} or {@see TransactionInterface::SERIALIZABLE}.
     *
     * @throws Exception|InvalidConfigException|NotSupportedException|Throwable when unsupported isolation levels are
     * used. SQLite only supports SERIALIZABLE and READ UNCOMMITTED.
     *
     * {@see http://www.sqlite.org/pragma.html#pragma_read_uncommitted}
     */
    protected function setTransactionIsolationLevel(string $level): void
    {
        switch ($level) {
            case self::SERIALIZABLE:
                $this->db->createCommand('PRAGMA read_uncommitted = False;')->execute();
                break;
            case self::READ_UNCOMMITTED:
                $this->db->createCommand('PRAGMA read_uncommitted = True;')->execute();
                break;
            default:
                throw new NotSupportedException(
                    self::class . ' only supports transaction isolation levels READ UNCOMMITTED and SERIALIZABLE.'
                );
        }
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Yiisoft\Db\Sqlite;
6
7		use Throwable;
8		use Yiisoft\Db\Driver\PDO\TransactionPDO as AbstractTransactionPDO;
9		use Yiisoft\Db\Exception\Exception;
10		use Yiisoft\Db\Exception\InvalidConfigException;
11		use Yiisoft\Db\Exception\NotSupportedException;
12		use Yiisoft\Db\Transaction\TransactionInterface;
13
14		final class TransactionPDO extends AbstractTransactionPDO
15		{
16		/**
17		* Sets the isolation level of the current transaction.
18		*
19		* @param string $level The transaction isolation level to use for this transaction. This can be either
20		* {@see TransactionInterface::READ_UNCOMMITTED} or {@see TransactionInterface::SERIALIZABLE}.
21		*
22		* @throws Exception\|InvalidConfigException\|NotSupportedException\|Throwable when unsupported isolation levels are
23		* used. SQLite only supports SERIALIZABLE and READ UNCOMMITTED.
24		*
25		* {@see http://www.sqlite.org/pragma.html#pragma_read_uncommitted}
26		*/
27	4	protected function setTransactionIsolationLevel(string $level): void
28		{
29		switch ($level) {
30	4	case self::SERIALIZABLE:
31	1	$this->db->createCommand('PRAGMA read_uncommitted = False;')->execute();
32	1	break;
33	4	case self::READ_UNCOMMITTED:
34	3	$this->db->createCommand('PRAGMA read_uncommitted = True;')->execute();
35	3	break;
36		default:
37	1	throw new NotSupportedException(
38	1	self::class . ' only supports transaction isolation levels READ UNCOMMITTED and SERIALIZABLE.'
39	1	);
40		}
41		}
42		}
43

yiisoft / db-sqlite

Branch — master (3d8725)

TransactionPDO::setTransactionIsolationLevel() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like