function SqlContentEntityStorageRevisionDataCleanupTest::testRevisionDataCleanup

Tests that stale rows in the revision data table are deleted.

See also

system_update_8404()

File

core/modules/system/tests/src/Functional/Update/SqlContentEntityStorageRevisionDataCleanupTest.php, line 33

Class

SqlContentEntityStorageRevisionDataCleanupTest

Tests cleaning up revision data tables.

Namespace

Code

public function testRevisionDataCleanup() : void {
  // Ensure the test data exists.
  $connection = \Drupal::database();
  // There are 104 rows, 101 rows to delete plus the original 3 valid rows.
  $result = $connection->query('SELECT nid, vid, langcode FROM {node_field_revision} WHERE nid = :nid', [
    ':nid' => 8,
  ])
    ->fetchAll();
  $this->assertCount(104, $result);
  $this->runUpdates();
  // Ensure the correct rows were deleted and only those.
  $result = $connection->query('SELECT nid, vid FROM {node_field_revision} WHERE nid = :nid AND vid = :vid ORDER BY nid, vid, langcode DESC', [
    ':nid' => 8,
    ':vid' => 8,
  ])
    ->fetchAll();
  $this->assertEmpty($result);
  $result = $connection->query('SELECT nid, vid FROM {node_field_revision} WHERE nid = :nid AND vid = :vid ORDER BY nid, vid, langcode DESC', [
    ':nid' => 8,
    ':vid' => 9,
  ])
    ->fetchAll();
  $this->assertEquals($result, [
    (object) [
      'nid' => '8',
      'vid' => '9',
    ],
  ]);
  // Revision 10 has two translations, ensure both records still exist.
  $result = $connection->query('SELECT nid, vid, langcode FROM {node_field_revision} WHERE nid = :nid AND vid = :vid ORDER BY nid, vid, langcode DESC', [
    ':nid' => 8,
    ':vid' => 10,
  ])
    ->fetchAll();
  Assert::assertEquals($result, [
    (object) [
      'nid' => '8',
      'vid' => '10',
      'langcode' => 'es',
    ],
    (object) [
      'nid' => '8',
      'vid' => '10',
      'langcode' => 'en',
    ],
  ]);
  // There should be only 3 rows left.
  $result = $connection->query('SELECT nid, vid, langcode FROM {node_field_revision} WHERE nid = :nid', [
    ':nid' => 8,
  ])
    ->fetchAll();
  $this->assertCount(3, $result);
}