function DatabaseTransactionTestCase::testCommittedTransaction

Test committed transaction.

The behavior of this test should be identical for connections that support transactions and those that do not.

File

modules/simpletest/tests/database_test.test, line 3897

Class

DatabaseTransactionTestCase

Test transaction support, particularly nesting.

Code

function testCommittedTransaction() {
    try {
        // Create two nested transactions. The changes should be committed.
        $this->transactionOuterLayer('A');
        // Because we committed, both of the inserted rows should be present.
        $saved_age = db_query('SELECT age FROM {test} WHERE name = :name', array(
            ':name' => 'DavidA',
        ))->fetchField();
        $this->assertIdentical($saved_age, '24', 'Can retrieve DavidA row after commit.');
        $saved_age = db_query('SELECT age FROM {test} WHERE name = :name', array(
            ':name' => 'DanielA',
        ))->fetchField();
        $this->assertIdentical($saved_age, '19', 'Can retrieve DanielA row after commit.');
    } catch (Exception $e) {
        $this->fail($e->getMessage());
    }
}