function NonPublicSchemaTest::testUniqueKey

@covers ::addUniqueKey @covers ::indexExists @covers ::dropUniqueKey

File

core/modules/pgsql/tests/src/Kernel/pgsql/NonPublicSchemaTest.php, line 293

Class

NonPublicSchemaTest

Tests schema API for non-public schema for the PostgreSQL driver.

Namespace

Code

public function testUniqueKey() : void {
    $this->testingFakeConnection
        ->schema()
        ->addUniqueKey('faking_table', 'test_field', [
        'test_field',
    ]);
    // This should work, but currently indexExist() only searches for keys that end with idx.
    // @todo remove comments when: https://www.drupal.org/project/drupal/issues/3325358 is committed.
    // $this->assertTrue($this->testingFakeConnection->schema()->indexExists('faking_table', 'test_field'));
    $results = $this->testingFakeConnection
        ->query("SELECT * FROM pg_indexes WHERE indexname = :indexname", [
        ':indexname' => $this->testingFakeConnection
            ->getPrefix() . 'faking_table__test_field__key',
    ])
        ->fetchAll();
    // Check the unique key columns.
    $this->assertCount(1, $results);
    $this->assertSame('testing_fake', $results[0]->schemaname);
    $this->assertSame($this->testingFakeConnection
        ->getPrefix() . 'faking_table', $results[0]->tablename);
    $this->assertStringContainsString('USING btree (test_field)', $results[0]->indexdef);
    $this->testingFakeConnection
        ->schema()
        ->dropUniqueKey('faking_table', 'test_field');
    // This function will not work due to a the fact that indexExist() does not search for keys without idx tag.
    // @todo remove comments when: https://www.drupal.org/project/drupal/issues/3325358 is committed.
    // $this->assertFalse($this->testingFakeConnection->schema()->indexExists('faking_table', 'test_field'));
}