Tests a committed transaction.
The behavior of this test should be identical for connections that support transactions and those that do not.
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());
}
}