function NonPublicSchemaTest::testTable

@covers ::renameTable
@covers ::tableExists
@covers ::findTables
@covers ::dropTable

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

public function testTable() : void {
  $this->testingFakeConnection
    ->schema()
    ->renameTable('faking_table', 'new_faking_table');
  $tables = $this->testingFakeConnection
    ->schema()
    ->findTables('%');
  $result = $this->testingFakeConnection
    ->query("SELECT * FROM information_schema.tables WHERE table_schema = 'testing_fake'")
    ->fetchAll();
  $this->assertFalse($this->testingFakeConnection
    ->schema()
    ->tableExists('faking_table'));
  $this->assertTrue($this->testingFakeConnection
    ->schema()
    ->tableExists('new_faking_table'));
  $this->assertEquals($this->testingFakeConnection
    ->getPrefix() . 'new_faking_table', $result[0]->table_name);
  $this->assertEquals('testing_fake', $result[0]->table_schema);
  sort($tables);
  $this->assertEquals([
    'new_faking_table',
  ], $tables);
  $this->testingFakeConnection
    ->schema()
    ->dropTable('new_faking_table');
  $this->assertFalse($this->testingFakeConnection
    ->schema()
    ->tableExists('new_faking_table'));
  $this->assertCount(0, $this->testingFakeConnection
    ->query("SELECT * FROM information_schema.tables WHERE table_schema = 'testing_fake'")
    ->fetchAll());
}