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

Test Failed

Pull Request — master (#245)

by Wilmer

created 2023-04-05 10:57 UTC

PdoTransaction::setTransactionIsolationLevel() A

↳ Parent: PdoTransaction

Complexity

Conditions	3
Paths	3

Size

Total Lines	12
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	10
dl	0
loc	12
rs	9.9332
c	0
b	0
f	0
cc	3
nc	3
nop	1

<?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 PdoTransaction 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 PdoTransaction 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			protected function setTransactionIsolationLevel(string $level): void
35			{
36			switch ($level) {
37			case self::SERIALIZABLE:
38			$this->db->createCommand('PRAGMA read_uncommitted = False;')->execute();
39			break;
40			case self::READ_UNCOMMITTED:
41			$this->db->createCommand('PRAGMA read_uncommitted = True;')->execute();
42			break;
43			default:
44			throw new NotSupportedException(
45			self::class . ' only supports transaction isolation levels READ UNCOMMITTED and SERIALIZABLE.'
46			);
47			}
48			}
49			}
50

yiisoft / db-sqlite

Pull Request — master (#245)

PdoTransaction::setTransactionIsolationLevel() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like