class NextIdTest

Same name in this branch
  1. 9 core/tests/Drupal/KernelTests/Core/Database/NextIdTest.php \Drupal\KernelTests\Core\Database\NextIdTest
Same name and namespace in other branches
  1. 10 core/modules/mysql/tests/src/Kernel/mysql/NextIdTest.php \Drupal\Tests\mysql\Kernel\mysql\NextIdTest
  2. 10 core/tests/Drupal/KernelTests/Core/Database/NextIdTest.php \Drupal\KernelTests\Core\Database\NextIdTest
  3. 8.9.x core/tests/Drupal/KernelTests/Core/Database/NextIdTest.php \Drupal\KernelTests\Core\Database\NextIdTest

Tests the sequences API.

@group Database

Hierarchy

Expanded class hierarchy of NextIdTest

File

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

Namespace

Drupal\Tests\mysql\Kernel\mysql
View source
class NextIdTest extends DriverSpecificDatabaseTestBase {
  
  /**
   * The modules to enable.
   *
   * @var array
   */
  protected static $modules = [
    'database_test',
    'system',
  ];
  
  /**
   * {@inheritdoc}
   */
  protected function setUp() : void {
    parent::setUp();
    $this->installSchema('system', 'sequences');
  }
  
  /**
   * Tests that sequences table clear up works when a connection is closed.
   *
   * @see \Drupal\mysql\Driver\Database\mysql\Connection::__destruct()
   */
  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);
  }

}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.