function TransactionTest::testReleaseIntermediateSavepoint

Tests releasing a savepoint before last is safe.

File

core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php, line 937

Class

TransactionTest

Tests the transactions, using the explicit ::commitOrRelease method.

Namespace

Code

public function testReleaseIntermediateSavepoint() : void {
    $transaction = $this->createRootTransaction();
    $savepoint1 = $this->createFirstSavepointTransaction('', FALSE);
    // Starts a savepoint transaction. Corresponds to 'SAVEPOINT savepoint_2'
    // on the database.
    $savepoint2 = $this->connection
        ->startTransaction();
    $this->assertSame(3, $this->connection
        ->transactionManager()
        ->stackDepth());
    // Starts a savepoint transaction. Corresponds to 'SAVEPOINT savepoint_3'
    // on the database.
    // phpcs:ignore DrupalPractice.CodeAnalysis.VariableAnalysis
    $savepoint3 = $this->connection
        ->startTransaction();
    $this->assertSame(4, $this->connection
        ->transactionManager()
        ->stackDepth());
    // Starts a savepoint transaction. Corresponds to 'SAVEPOINT savepoint_4'
    // on the database.
    // phpcs:ignore DrupalPractice.CodeAnalysis.VariableAnalysis
    $savepoint4 = $this->connection
        ->startTransaction();
    $this->assertSame(5, $this->connection
        ->transactionManager()
        ->stackDepth());
    $this->insertRow('row');
    // Release savepoint transaction. Corresponds to 'RELEASE SAVEPOINT
    // savepoint_2' on the database.
    $savepoint2->commitOrRelease();
    // Since we have committed an intermediate savepoint Transaction object,
    // the savepoints created later have been dropped by the database already.
    $this->assertSame(2, $this->connection
        ->transactionManager()
        ->stackDepth());
    $this->assertRowPresent('row');
    // Commit the remaining Transaction objects. The client transaction is
    // eventually committed.
    $savepoint1->commitOrRelease();
    $transaction->commitOrRelease();
    $this->assertFalse($this->connection
        ->inTransaction());
    $this->assertRowPresent('row');
}