function DatabaseTransactionTestCase::testTransactionWithDdlStatement in Drupal 7

Test the compatibility of transactions with DDL statements.

File

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

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');
  }
}