function DriverSpecificTransactionTestBase::testReleaseIntermediateSavepoint

Tests releasing a savepoint before last is safe.

File

core/tests/Drupal/KernelTests/Core/Database/DriverSpecificTransactionTestBase.php, line 674

Class

DriverSpecificTransactionTestBase

Tests the transaction abstraction system.

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.
  $savepoint3 = $this->connection
    ->startTransaction();
  $this->assertSame(4, $this->connection
    ->transactionManager()
    ->stackDepth());
  // Starts a savepoint transaction. Corresponds to 'SAVEPOINT savepoint_4'
  // on the database.
  $savepoint4 = $this->connection
    ->startTransaction();
  $this->assertSame(5, $this->connection
    ->transactionManager()
    ->stackDepth());
  $this->insertRow('row');
  // Commit a savepoint transaction. Corresponds to 'RELEASE SAVEPOINT
  // savepoint_2' on the database.
  unset($savepoint2);
  // 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.
  unset($savepoint1);
  unset($transaction);
  $this->assertFalse($this->connection
    ->inTransaction());
  $this->assertRowPresent('row');
}