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 51

Class

NextIdTest

Tests the sequences API.

Namespace

Code

public function testDbNextIdClosedConnection() : void {
    $this->expectDeprecation('Drupal\\Core\\Database\\Connection::nextId() is deprecated in drupal:10.2.0 and is removed from drupal:11.0.0. Modules should use instead the keyvalue storage for the last used id. See https://www.drupal.org/node/3349345');
    $this->expectDeprecation('Drupal\\mysql\\Driver\\Database\\mysql\\Connection::nextIdDelete() is deprecated in drupal:10.2.0 and is removed from drupal:11.0.0. Modules should use instead the keyvalue storage for the last used id. See https://www.drupal.org/node/3349345');
    // 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);
}