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);
}