function ForumIndexUpdateTest::testUpdatePath

Tests the update path to add the new primary key.

File

core/modules/forum/tests/src/Functional/ForumIndexUpdateTest.php, line 29

Class

ForumIndexUpdateTest

Tests addition of the forum_index primary key.

Namespace

Code

public function testUpdatePath() : void {
    // Set the batch size to 1 to validate the sandbox logic in the update hook.
    $settings = Settings::getInstance() ? Settings::getAll() : [];
    $settings['entity_update_batch_size'] = 1;
    new Settings($settings);
    $schema = \Drupal::database()->schema();
    // We can't reliably call ::indexExists for each database driver as sqlite
    // doesn't have named indexes for primary keys like mysql (PRIMARY) and
    // pgsql (pkey).
    $find_primary_key_columns = new \ReflectionMethod(get_class($schema), 'findPrimaryKeyColumns');
    $columns = $find_primary_key_columns->invoke($schema, 'forum_index');
    $this->assertEmpty($columns);
    $count = \Drupal::database()->select('forum_index')
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(9, $count);
    $duplicates = \Drupal::database()->select('forum_index')
        ->condition('nid', 1)
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(2, $duplicates);
    $duplicates = \Drupal::database()->select('forum_index')
        ->condition('nid', 2)
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(3, $duplicates);
    $this->runUpdates();
    $this->assertEquals([
        'nid',
        'tid',
    ], $find_primary_key_columns->invoke($schema, 'forum_index'));
    $count = \Drupal::database()->select('forum_index')
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(6, $count);
    $duplicates = \Drupal::database()->select('forum_index')
        ->condition('nid', 1)
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(1, $duplicates);
    $duplicates = \Drupal::database()->select('forum_index')
        ->condition('nid', 2)
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(1, $duplicates);
    // This entry is associated with two terms so two records should remain.
    $duplicates = \Drupal::database()->select('forum_index')
        ->condition('nid', 4)
        ->countQuery()
        ->execute()
        ->fetchField();
    $this->assertEquals(2, $duplicates);
    $entry = \Drupal::database()->select('forum_index', 'f')
        ->fields('f')
        ->condition('nid', 5)
        ->execute()
        ->fetchAssoc();
    $this->assertEquals([
        'nid' => 5,
        'title' => 'AFL',
        'tid' => 5,
        'sticky' => 0,
        'created' => 1695264369,
        'last_comment_timestamp' => 1695264403,
        'comment_count' => 1,
    ], $entry);
}