Test the compatibility of transactions with DDL statements.

File

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

Class

DatabaseTransactionTestCase

Test transaction support, particularly nesting.

Code

function testTransactionWithDdlStatement() {
 // First, test that a commit works normally, even with DDL statements.
 $transaction = db_transaction ();
 $this->insertRow ('row');
 $this->executeDDLStatement ();
 unset($transaction);
 $this->assertRowPresent ('row');
 // Even in different order.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $this->executeDDLStatement ();
 $this->insertRow ('row');
 unset($transaction);
 $this->assertRowPresent ('row');
 // Even with stacking.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $transaction2 = db_transaction ();
 $this->executeDDLStatement ();
 unset($transaction2);
 $transaction3 = db_transaction ();
 $this->insertRow ('row');
 unset($transaction3);
 unset($transaction);
 $this->assertRowPresent ('row');
 // A transaction after a DDL statement should still work the same.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $transaction2 = db_transaction ();
 $this->executeDDLStatement ();
 unset($transaction2);
 $transaction3 = db_transaction ();
 $this->insertRow ('row');
 $transaction3->rollback ();
 unset($transaction3);
 unset($transaction);
 $this->assertRowAbsent ('row');
 // The behavior of a rollback depends on the type of database server.
 if (Database ::getConnection ()->supportsTransactionalDDL ()) {
 // For database servers that support transactional DDL, a rollback
 // of a transaction including DDL statements should be possible.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $this->insertRow ('row');
 $this->executeDDLStatement ();
 $transaction->rollback ();
 unset($transaction);
 $this->assertRowAbsent ('row');
 // Including with stacking.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $transaction2 = db_transaction ();
 $this->executeDDLStatement ();
 unset($transaction2);
 $transaction3 = db_transaction ();
 $this->insertRow ('row');
 unset($transaction3);
 $transaction->rollback ();
 unset($transaction);
 $this->assertRowAbsent ('row');
 }
 else {
 // For database servers that do not support transactional DDL,
 // the DDL statement should commit the transaction stack.
 $this->cleanUp ();
 $transaction = db_transaction ();
 $this->insertRow ('row');
 $this->executeDDLStatement ();
 set_error_handler (array(
 $this,
 'rollBackWithoutTransactionErrorHandler',
 ));
 try {
 // Rollback the outer transaction.
 $transaction->rollback ();
 // @see \DatabaseConnection_mysql::rollback()
 if (PHP_VERSION_ID >= 80000) {
 $this->fail ('Rolling back a transaction containing DDL should produce a warning.');
 }
 } catch (Exception $e) {
 $this->assertEqual ('Rollback attempted when there is no active transaction.', $e->getMessage());
 }
 restore_error_handler ();
 unset($transaction);
 $this->assertRowPresent ('row');
 }
}

---