public function TransactionTest::testTransactionRollBackSupported in Drupal 8

Same name and namespace in other branches

1. 9 core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php \Drupal\KernelTests\Core\Database\TransactionTest::testTransactionRollBackSupported()
2. 10 core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php \Drupal\KernelTests\Core\Database\TransactionTest::testTransactionRollBackSupported()

Tests transaction rollback on a database that supports transactions.

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

File

core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php, line 146

Class

TransactionTest

Tests the transaction abstraction system.

Namespace

Drupal\KernelTests\Core\Database

Code

public function testTransactionRollBackSupported() {

  // This test won't work right if transactions are not supported.
  if (!$this->connection
    ->supportsTransactions()) {
    $this
      ->markTestSkipped("The '{$this->connection->driver()}' database driver does not support transactions.");
  }
  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 = $this->connection
      ->query('SELECT age FROM {test} WHERE name = :name', [
      ':name' => 'DavidB',
    ])
      ->fetchField();
    $this
      ->assertNotIdentical($saved_age, '24', 'Cannot retrieve DavidB row after commit.');
    $saved_age = $this->connection
      ->query('SELECT age FROM {test} WHERE name = :name', [
      ':name' => 'DanielB',
    ])
      ->fetchField();
    $this
      ->assertNotIdentical($saved_age, '19', 'Cannot retrieve DanielB row after commit.');
  } catch (\Exception $e) {
    $this
      ->fail($e
      ->getMessage());
  }
}