function TransactionTest::testTransactionRollBackSupported

Tests transaction rollback on a database that supports transactions.

If the active connection does not support transactions, this test does nothing.

File

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

Class

TransactionTest

Tests the transaction abstraction system.

Namespace

Code

public function testTransactionRollBackSupported() {
    // This test won't work right if transactions are not supported.
    if (!$this->connection
        ->supportsTransactions()) {
        $this->markTestSkipped("The '{$this->connection->driver()}' database driver does not support transactions.");
    }
    try {
        // Create two nested transactions. Roll back from the inner one.
        $this->transactionOuterLayer('B', TRUE);
        // Neither of the rows we inserted in the two transaction layers
        // should be present in the tables post-rollback.
        $saved_age = $this->connection
            ->query('SELECT age FROM {test} WHERE name = :name', [
            ':name' => 'DavidB',
        ])
            ->fetchField();
        $this->assertNotIdentical($saved_age, '24', 'Cannot retrieve DavidB row after commit.');
        $saved_age = $this->connection
            ->query('SELECT age FROM {test} WHERE name = :name', [
            ':name' => 'DanielB',
        ])
            ->fetchField();
        $this->assertNotIdentical($saved_age, '19', 'Cannot retrieve DanielB row after commit.');
    } catch (\Exception $e) {
        $this->fail($e->getMessage());
    }
}