Yiisoft\Db\Sqlite\Transaction

Complexity

Total Complexity

1

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	setTransactionIsolationLevel()	0	7	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite;

use Throwable;
use Yiisoft\Db\Driver\Pdo\AbstractPdoTransaction;
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 AbstractPdoTransaction
{
    /**
     * 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 https://www.sqlite.org/pragma.html#pragma_read_uncommitted
     */
    protected function setTransactionIsolationLevel(string $level): void
    {
        match ($level) {
            self::SERIALIZABLE => $this->db->createCommand('PRAGMA read_uncommitted = False;')->execute(),
            self::READ_UNCOMMITTED => $this->db->createCommand('PRAGMA read_uncommitted = True;')->execute(),
            default => throw new NotSupportedException(
                self::class . ' only supports transaction isolation levels READ UNCOMMITTED and SERIALIZABLE.'
            ),
        };
    }
}