function NonPublicSchemaTest::testIndex

@covers ::addIndex @covers ::indexExists @covers ::dropIndex

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

public function testIndex() : void {
    $this->testingFakeConnection
        ->schema()
        ->addIndex('faking_table', 'test_field', [
        'test_field',
    ], []);
    $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__idx',
    ])
        ->fetchAll();
    $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()
        ->dropIndex('faking_table', 'test_field');
    $this->assertFalse($this->testingFakeConnection
        ->schema()
        ->indexExists('faking_table', 'test_field'));
}