function NonPublicSchemaTest::setUp

Overrides DriverSpecificKernelTestBase::setUp

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

protected function setUp() : void {
    parent::setUp();
    // Create a connection to the non-public schema.
    $info = Database::getConnectionInfo('default');
    $info['default']['schema'] = 'testing_fake';
    Database::getConnection()->query('CREATE SCHEMA IF NOT EXISTS testing_fake');
    Database::addConnectionInfo('default', 'testing_fake', $info['default']);
    $this->testingFakeConnection = Database::getConnection('testing_fake', 'default');
    $table_specification = [
        'description' => 'Schema table description may contain "quotes" and could be long—very long indeed.',
        'fields' => [
            'id' => [
                'type' => 'serial',
                'not null' => TRUE,
            ],
            'test_field' => [
                'type' => 'int',
                'not null' => TRUE,
            ],
        ],
        'primary key' => [
            'id',
        ],
    ];
    $this->testingFakeConnection
        ->schema()
        ->createTable('faking_table', $table_specification);
    $this->testingFakeConnection
        ->insert('faking_table')
        ->fields([
        'id' => '1',
        'test_field' => '123',
    ])
        ->execute();
    $this->testingFakeConnection
        ->insert('faking_table')
        ->fields([
        'id' => '2',
        'test_field' => '456',
    ])
        ->execute();
    $this->testingFakeConnection
        ->insert('faking_table')
        ->fields([
        'id' => '3',
        'test_field' => '789',
    ])
        ->execute();
}