function DatabaseTransactionTestCase::testTransactionRollBackSupported

7.x database_test.test DatabaseTransactionTestCase::testTransactionRollBackSupported()

Test transaction rollback on a database that supports transactions.

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

File

drupal/modules/simpletest/tests/database_test.test, line 3455

Class

DatabaseTransactionTestCase
Test transaction support, particularly nesting.

Code

function testTransactionRollBackSupported() {
  // This test won't work right if transactions are not supported.
  if (!Database::getConnection()->supportsTransactions()) {
    return;
  }
  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 = db_query('SELECT age FROM {test} WHERE name = :name', array(':name' => 'DavidB'))->fetchField();
    $this->assertNotIdentical($saved_age, '24', 'Cannot retrieve DavidB row after commit.');
    $saved_age = db_query('SELECT age FROM {test} WHERE name = :name', array(':name' => 'DanielB'))->fetchField();
    $this->assertNotIdentical($saved_age, '19', 'Cannot retrieve DanielB row after commit.');
  }
  catch (Exception $e) {
    $this->fail($e->getMessage());
  }
}