yiisoft / db-sqlite

src/Transaction.php

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite;

use Throwable;
use Yiisoft\Db\Driver\Pdo\AbstractPdoTransaction;

The type Yiisoft\Db\Driver\Pdo\AbstractPdoTransaction was not found. Maybe you did not declare it correctly or list all dependencies?

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 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.'
                );
        }
    }
}