function FieldSqlStorageTest::testFieldUpdateIndexesWithData

Test adding and removing indexes while data is present.

File

core/tests/Drupal/KernelTests/Core/Entity/FieldSqlStorageTest.php, line 388

Class

FieldSqlStorageTest

Tests Field SQL Storage .

Namespace

Code

public function testFieldUpdateIndexesWithData() {
    // Create a decimal field.
    $field_name = 'testfield';
    $entity_type = 'entity_test_rev';
    $field_storage = FieldStorageConfig::create([
        'field_name' => $field_name,
        'entity_type' => $entity_type,
        'type' => 'text',
    ]);
    $field_storage->save();
    $field = FieldConfig::create([
        'field_storage' => $field_storage,
        'bundle' => $entity_type,
    ]);
    $field->save();
    $tables = [
        $this->tableMapping
            ->getDedicatedDataTableName($field_storage),
        $this->tableMapping
            ->getDedicatedRevisionTableName($field_storage),
    ];
    // Verify the indexes we will create do not exist yet.
    foreach ($tables as $table) {
        $this->assertFalse(Database::getConnection()->schema()
            ->indexExists($table, 'value'), t("No index named value exists in @table", [
            '@table' => $table,
        ]));
        $this->assertFalse(Database::getConnection()->schema()
            ->indexExists($table, 'value_format'), t("No index named value_format exists in @table", [
            '@table' => $table,
        ]));
    }
    // Add data so the table cannot be dropped.
    $entity = $this->container
        ->get('entity_type.manager')
        ->getStorage($entity_type)
        ->create([
        'id' => 1,
        'revision_id' => 1,
    ]);
    $entity->{$field_name}->value = 'field data';
    $entity->enforceIsNew();
    $entity->save();
    // Add an index.
    $field_storage->setIndexes([
        'value' => [
            [
                'value',
                255,
            ],
        ],
    ]);
    $field_storage->save();
    foreach ($tables as $table) {
        $this->assertTrue(Database::getConnection()->schema()
            ->indexExists($table, "{$field_name}_value"), t("Index on value created in @table", [
            '@table' => $table,
        ]));
    }
    // Add a different index, removing the existing custom one.
    $field_storage->setIndexes([
        'value_format' => [
            [
                'value',
                127,
            ],
            [
                'format',
                127,
            ],
        ],
    ]);
    $field_storage->save();
    foreach ($tables as $table) {
        $this->assertTrue(Database::getConnection()->schema()
            ->indexExists($table, "{$field_name}_value_format"), t("Index on value_format created in @table", [
            '@table' => $table,
        ]));
        $this->assertFalse(Database::getConnection()->schema()
            ->indexExists($table, "{$field_name}_value"), t("Index on value removed in @table", [
            '@table' => $table,
        ]));
    }
    // Verify that the tables were not dropped in the process.
    $entity = $this->container
        ->get('entity_type.manager')
        ->getStorage($entity_type)
        ->load(1);
    $this->assertEqual($entity->{$field_name}->value, 'field data', t("Index changes performed without dropping the tables"));
}