Transaction::setTransactionIsolationLevel() - Code Metrics - Inspection of "Better naming classes with `PDO` - part 1." - yiisoft/db-sqlite - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#245)

by Alexander

created 2023-04-05 17:41 UTC

Transaction::setTransactionIsolationLevel() A

↳ Parent: Transaction

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
dl	0
loc	12
ccs	9
cts	9
cp	1
rs	9.9332
c	0
b	0
f	0
cc	3
nc	3
nop	1
crap	3

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite;

use Throwable;
use Yiisoft\Db\Driver\PDO\AbstractTransactionPDO;
use Yiisoft\Db\Exception\Exception;
use Yiisoft\Db\Exception\InvalidConfigException;
use Yiisoft\Db\Exception\NotSupportedException;

/**
 * Implements the SQLite Server specific transaction.
 */
final class Transaction extends AbstractTransactionPDO
{
    /**
     * Sets the isolation level of the current transaction.
     *
     * @param string $level The transaction isolation level to use for this transaction.
     *
     * @see \Yiisoft\Db\Transaction\TransactionInterface::READ_UNCOMMITTED
     * @see \Yiisoft\Db\Transaction\TransactionInterface::SERIALIZABLE
     *
     * @throws Exception
     * @throws InvalidConfigException
     * @throws NotSupportedException
     * @throws Throwable When unsupported isolation levels are used. SQLite only supports `SERIALIZABLE`
     * and `READ UNCOMMITTED`.
     *
     * @link 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\AbstractTransactionPDO;
9		use Yiisoft\Db\Exception\Exception;
10		use Yiisoft\Db\Exception\InvalidConfigException;
11		use Yiisoft\Db\Exception\NotSupportedException;
12
13		/**
14		* Implements the SQLite Server specific transaction.
15		*/
16		final class Transaction extends AbstractTransactionPDO
17		{
18		/**
19		* Sets the isolation level of the current transaction.
20		*
21		* @param string $level The transaction isolation level to use for this transaction.
22		*
23		* @see \Yiisoft\Db\Transaction\TransactionInterface::READ_UNCOMMITTED
24		* @see \Yiisoft\Db\Transaction\TransactionInterface::SERIALIZABLE
25		*
26		* @throws Exception
27		* @throws InvalidConfigException
28		* @throws NotSupportedException
29		* @throws Throwable When unsupported isolation levels are used. SQLite only supports `SERIALIZABLE`
30		* and `READ UNCOMMITTED`.
31		*
32		* @link http://www.sqlite.org/pragma.html#pragma_read_uncommitted
33		*/
34	4	protected function setTransactionIsolationLevel(string $level): void
35		{
36		switch ($level) {
37	4	case self::SERIALIZABLE:
38	1	$this->db->createCommand('PRAGMA read_uncommitted = False;')->execute();
39	1	break;
40	4	case self::READ_UNCOMMITTED:
41	3	$this->db->createCommand('PRAGMA read_uncommitted = True;')->execute();
42	3	break;
43		default:
44	1	throw new NotSupportedException(
45	1	self::class . ' only supports transaction isolation levels READ UNCOMMITTED and SERIALIZABLE.'
46	1	);
47		}
48		}
49		}
50

yiisoft / db-sqlite

Pull Request — master (#245)

Transaction::setTransactionIsolationLevel() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like