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());
}