3 namespace Drupal\Tests\system\Functional\Entity\Update;
5 use Drupal\FunctionalTests\Update\UpdatePathTestBase;
8 * Tests that a newly-added index is properly created during database updates.
12 class SqlContentEntityStorageSchemaIndexTest extends UpdatePathTestBase {
17 protected function setDatabaseDumpFiles() {
18 $this->databaseDumpFiles = [
19 __DIR__ . '/../../../../fixtures/update/drupal-8.bare.standard.php.gz',
24 * Tests entity and field schema database updates and execution order.
26 public function testIndex() {
27 // The initial Drupal 8 database dump before any updates does not include
28 // the entity ID in the entity field data table indices that were added in
29 // https://www.drupal.org/node/2261669.
30 $this->assertTrue(db_index_exists('node_field_data', 'node__default_langcode'), 'Index node__default_langcode exists prior to running updates.');
31 $this->assertFalse(db_index_exists('node_field_data', 'node__id__default_langcode__langcode'), 'Index node__id__default_langcode__langcode does not exist prior to running updates.');
32 $this->assertFalse(db_index_exists('users_field_data', 'user__id__default_langcode__langcode'), 'Index users__id__default_langcode__langcode does not exist prior to running updates.');
34 // Running database updates should update the entity schemata to add the
35 // indices from https://www.drupal.org/node/2261669.
37 $this->assertFalse(db_index_exists('node_field_data', 'node__default_langcode'), 'Index node__default_langcode properly removed.');
38 $this->assertTrue(db_index_exists('node_field_data', 'node__id__default_langcode__langcode'), 'Index node__id__default_langcode__langcode properly created on the node_field_data table.');
39 $this->assertTrue(db_index_exists('users_field_data', 'user__id__default_langcode__langcode'), 'Index users__id__default_langcode__langcode properly created on the user_field_data table.');