function TransactionTest::testRollbackAfterDdlStatementForNonTransactionalDdlDatabase

Tests rollback after a DDL statement when no transactional DDL supported.

File

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

Class

TransactionTest

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

Namespace

Code

public function testRollbackAfterDdlStatementForNonTransactionalDdlDatabase() : void {
    if ($this->connection
        ->supportsTransactionalDDL()) {
        $this->markTestSkipped('This test only works for database that do not support transactional DDL.');
    }
    // For database servers that do not support transactional DDL,
    // the DDL statement should commit the transaction stack.
    $this->cleanUp();
    $transaction = $this->createRootTransaction('', FALSE);
    $reflectionMethod = new \ReflectionMethod(get_class($this->connection
        ->transactionManager()), 'getConnectionTransactionState');
    $this->assertSame(1, $this->connection
        ->transactionManager()
        ->stackDepth());
    $this->assertEquals(ClientConnectionTransactionState::Active, $reflectionMethod->invoke($this->connection
        ->transactionManager()));
    $this->insertRow('row');
    $this->executeDDLStatement();
    $this->assertSame(0, $this->connection
        ->transactionManager()
        ->stackDepth());
    $this->assertEquals(ClientConnectionTransactionState::Voided, $reflectionMethod->invoke($this->connection
        ->transactionManager()));
    // Try to rollback the root transaction. Since the DDL already committed
    // it, it should fail.
    set_error_handler(static function (int $errno, string $errstr) : bool {
        throw new \ErrorException($errstr);
    });
    try {
        $transaction->rollBack();
    } catch (\ErrorException $e) {
        $this->assertSame('Transaction::rollBack() failed because of a prior execution of a DDL statement.', $e->getMessage());
    } finally {
        restore_error_handler();
    }
    try {
        $transaction->commitOrRelease();
        $this->fail('TransactionOutOfOrderException was expected, but did not throw.');
    } catch (TransactionOutOfOrderException) {
        // Just continue, the attempted rollback made the overall state to
        // ClientConnectionTransactionState::RollbackFailed.
    }
    $manager = $this->connection
        ->transactionManager();
    $this->assertSame(0, $manager->stackDepth());
    $reflectedTransactionState = new \ReflectionMethod($manager, 'getConnectionTransactionState');
    $this->assertSame(ClientConnectionTransactionState::RollbackFailed, $reflectedTransactionState->invoke($manager));
    $this->assertRowPresent('row');
}