public function TransactionTest::testCommittedTransaction in Drupal 9

Same name and namespace in other branches

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

Tests a committed transaction.

The behavior of this test should be identical for connections that support transactions and those that do not.

File

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

Class

TransactionTest

Tests the transaction abstraction system.

Namespace

Drupal\KernelTests\Core\Database

Code

public 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 = $this->connection
      ->query('SELECT [age] FROM {test} WHERE [name] = :name', [
      ':name' => 'DavidA',
    ])
      ->fetchField();
    $this
      ->assertSame('24', $saved_age, 'Can retrieve DavidA row after commit.');
    $saved_age = $this->connection
      ->query('SELECT [age] FROM {test} WHERE [name] = :name', [
      ':name' => 'DanielA',
    ])
      ->fetchField();
    $this
      ->assertSame('19', $saved_age, 'Can retrieve DanielA row after commit.');
  } catch (\Exception $e) {
    $this
      ->fail($e
      ->getMessage());
  }
}