function ConnectionUnitTest::testOpenQueryPrefetchClose

Tests Database::closeConnection() with a query and custom prefetch method.

File

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

Class

ConnectionUnitTest

Tests management of database connections.

Namespace

Code

public function testOpenQueryPrefetchClose() {
    // Only run this test for the 'mysql' driver.
    $driver = $this->connection
        ->driver();
    if ($driver !== 'mysql') {
        $this->markTestSkipped("MySql tests can not run for driver '{$driver}'.");
    }
    // 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);
    // Execute a query.
    Database::getConnection(static::TEST_TARGET_CONNECTION)->query('SHOW TABLES')
        ->fetchCol();
    // 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);
}