function NonPublicSchemaTest::testPrimaryKey

@covers ::addPrimaryKey
@covers ::dropPrimaryKey

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

public function testPrimaryKey() : void {
  $this->testingFakeConnection
    ->schema()
    ->dropPrimaryKey('faking_table');
  $results = $this->testingFakeConnection
    ->query("SELECT * FROM pg_indexes WHERE schemaname = 'testing_fake'")
    ->fetchAll();
  $this->assertCount(0, $results);
  $this->testingFakeConnection
    ->schema()
    ->addPrimaryKey('faking_table', [
    'id',
  ]);
  $results = $this->testingFakeConnection
    ->query("SELECT * FROM pg_indexes WHERE schemaname = 'testing_fake'")
    ->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 (id)', $results[0]->indexdef);
  $find_primary_keys_columns = new \ReflectionMethod(get_class($this->testingFakeConnection
    ->schema()), 'findPrimaryKeyColumns');
  $results = $find_primary_keys_columns->invoke($this->testingFakeConnection
    ->schema(), 'faking_table');
  $this->assertCount(1, $results);
  $this->assertSame('id', $results[0]);
}