function TransactionTest::testCommitAfterDdl

Tests commit does not fail when committing after DDL.

In core, SQLite and PostgreSql databases support transactional DDL, MySql does not.

File

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

Class

TransactionTest

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

Namespace

Code

public function testCommitAfterDdl() : void {
  $transaction = $this->createRootTransaction();
  $savepoint = $this->createFirstSavepointTransaction();
  $this->executeDDLStatement();
  $this->assertRowPresent('David');
  $this->assertRowPresent('Roger');
  if ($this->connection
    ->supportsTransactionalDDL()) {
    $this->assertTrue($this->connection
      ->inTransaction());
    $this->assertSame(2, $this->connection
      ->transactionManager()
      ->stackDepth());
  }
  else {
    $this->assertFalse($this->connection
      ->inTransaction());
  }
  $this->assertRowPresent('David');
  $this->assertRowPresent('Roger');
  if ($this->connection
    ->supportsTransactionalDDL()) {
    $savepoint->commitOrRelease();
    $this->assertTrue($this->connection
      ->inTransaction());
    $this->assertSame(1, $this->connection
      ->transactionManager()
      ->stackDepth());
  }
  else {
    set_error_handler(static function (int $errno, string $errstr) : bool {
      throw new \ErrorException($errstr);
    });
    try {
      $savepoint->commitOrRelease();
    } catch (\ErrorException $e) {
      $this->assertSame('Transaction::commitOrRelease() was not processed because a prior execution of a DDL statement already committed the transaction.', $e->getMessage());
    } finally {
      restore_error_handler();
    }
    $this->assertFalse($this->connection
      ->inTransaction());
  }
  if ($this->connection
    ->supportsTransactionalDDL()) {
    $transaction->commitOrRelease();
  }
  else {
    set_error_handler(static function (int $errno, string $errstr) : bool {
      throw new \ErrorException($errstr);
    });
    try {
      $transaction->commitOrRelease();
    } catch (\ErrorException $e) {
      $this->assertSame('Transaction::commitOrRelease() was not processed because a prior execution of a DDL statement already committed the transaction.', $e->getMessage());
    } finally {
      restore_error_handler();
    }
  }
  $this->assertRowPresent('David');
  $this->assertRowPresent('Roger');
  $this->assertFalse($this->connection
    ->inTransaction());
}