public function ConnectionUnitTest::testOpenSelectQueryClose in Drupal 10

Same name and namespace in other branches

1. 8 core/tests/Drupal/KernelTests/Core/Database/ConnectionUnitTest.php \Drupal\KernelTests\Core\Database\ConnectionUnitTest::testOpenSelectQueryClose()
2. 9 core/tests/Drupal/KernelTests/Core/Database/ConnectionUnitTest.php \Drupal\KernelTests\Core\Database\ConnectionUnitTest::testOpenSelectQueryClose()

Tests Database::closeConnection() with a select query.

File

core/tests/Drupal/KernelTests/Core/Database/ConnectionUnitTest.php, line 211

Class

ConnectionUnitTest

Tests management of database connections.

Namespace

Drupal\KernelTests\Core\Database

Code

public function testOpenSelectQueryClose() {

  // Do not run this test for an SQLite database.
  $database_type = $this->connection
    ->databaseType();
  if ($database_type != 'mysql' && $database_type != 'pgsql') {
    $this
      ->markTestSkipped("This tests only runs on MySQL and PostgreSQL");
  }

  // Add and open a new connection.
  $this
    ->addConnection();
  $id = $this
    ->getConnectionId();
  Database::getConnection(static::TEST_TARGET_CONNECTION);

  // Verify that there is a new connection.
  $this
    ->assertConnection($id);

  // Create a table.
  $name = 'foo';
  Database::getConnection(static::TEST_TARGET_CONNECTION)
    ->schema()
    ->createTable($name, [
    'fields' => [
      'name' => [
        'type' => 'varchar',
        'length' => 255,
      ],
    ],
  ]);

  // Execute a query.
  Database::getConnection(static::TEST_TARGET_CONNECTION)
    ->select('foo', 'f')
    ->fields('f', [
    'name',
  ])
    ->execute()
    ->fetchAll();

  // Drop the table.
  Database::getConnection(static::TEST_TARGET_CONNECTION)
    ->schema()
    ->dropTable($name);

  // Close the connection.
  Database::closeConnection(static::TEST_TARGET_CONNECTION);

  // Wait 20ms to give the database engine sufficient time to react.
  usleep(20000);

  // Verify that we are back to the original connection count.
  $this
    ->assertNoConnection($id);
}