function NextIdTest::testDbNextIdClosedConnection

Tests that sequences table clear up works when a connection is closed.

See also

\Drupal\mysql\Driver\Database\mysql\Connection::__destruct()

File

core/modules/mysql/tests/src/Kernel/mysql/NextIdTest.php, line 35

Class

NextIdTest

Tests the sequences API.

Namespace

Code

public function testDbNextIdClosedConnection() {
    // Create an additional connection to test closing the connection.
    $connection_info = Database::getConnectionInfo();
    Database::addConnectionInfo('default', 'next_id', $connection_info['default']);
    // Get a few IDs to ensure there the clean up needs to run and there is more
    // than one row.
    Database::getConnection('next_id')->nextId();
    Database::getConnection('next_id')->nextId();
    // At this point the sequences table should contain unnecessary rows.
    $count = $this->connection
        ->select('sequences')
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertGreaterThan(1, $count);
    // Close the connection.
    Database::closeConnection('next_id');
    // Test that \Drupal\mysql\Driver\Database\mysql\Connection::__destruct()
    // successfully trims the sequences table if the connection is closed.
    $count = $this->connection
        ->select('sequences')
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(1, $count);
}