function DriverSpecificTransactionTestBase::testTransactionWithDdlStatement

Tests the compatibility of transactions with DDL statements.

File

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

Class

DriverSpecificTransactionTestBase

Tests the transaction abstraction system.

Namespace

Code

public function testTransactionWithDdlStatement() : void {
  // First, test that a commit works normally, even with DDL statements.
  $transaction = $this->createRootTransaction('', FALSE);
  $this->insertRow('row');
  $this->executeDDLStatement();
  unset($transaction);
  $this->assertRowPresent('row');
  // Even in different order.
  $this->cleanUp();
  $transaction = $this->createRootTransaction('', FALSE);
  $this->executeDDLStatement();
  $this->insertRow('row');
  unset($transaction);
  $this->assertRowPresent('row');
  // Even with stacking.
  $this->cleanUp();
  $transaction = $this->createRootTransaction('', FALSE);
  $transaction2 = $this->createFirstSavepointTransaction('', FALSE);
  $this->executeDDLStatement();
  unset($transaction2);
  $transaction3 = $this->connection
    ->startTransaction();
  $this->insertRow('row');
  unset($transaction3);
  unset($transaction);
  $this->assertRowPresent('row');
  // A transaction after a DDL statement should still work the same.
  $this->cleanUp();
  $transaction = $this->createRootTransaction('', FALSE);
  $transaction2 = $this->createFirstSavepointTransaction('', FALSE);
  $this->executeDDLStatement();
  unset($transaction2);
  $transaction3 = $this->connection
    ->startTransaction();
  $this->insertRow('row');
  $transaction3->rollBack();
  unset($transaction3);
  unset($transaction);
  $this->assertRowAbsent('row');
  // The behavior of a rollback depends on the type of database server.
  if ($this->connection
    ->supportsTransactionalDDL()) {
    // For database servers that support transactional DDL, a rollback
    // of a transaction including DDL statements should be possible.
    $this->cleanUp();
    $transaction = $this->createRootTransaction('', FALSE);
    $this->insertRow('row');
    $this->executeDDLStatement();
    $transaction->rollBack();
    unset($transaction);
    $this->assertRowAbsent('row');
    // Including with stacking.
    $this->cleanUp();
    $transaction = $this->createRootTransaction('', FALSE);
    $transaction2 = $this->createFirstSavepointTransaction('', FALSE);
    $this->executeDDLStatement();
    unset($transaction2);
    $transaction3 = $this->connection
      ->startTransaction();
    $this->insertRow('row');
    unset($transaction3);
    $transaction->rollBack();
    unset($transaction);
    $this->assertRowAbsent('row');
  }
}