function DriverSpecificConnectionUnitTestBase::testOpenSelectQueryClose

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

File

core/tests/Drupal/KernelTests/Core/Database/DriverSpecificConnectionUnitTestBase.php, line 148

Class

DriverSpecificConnectionUnitTestBase

Tests management of database connections.

Namespace

Code

public function testOpenSelectQueryClose() : void {
  // 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($this->id);
}