function NonPublicSchemaTest::testInsert

@covers \Drupal\Core\Database\Connection::insert
@covers \Drupal\Core\Database\Connection::select

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

public function testInsert() : void {
  $num_records_before = $this->testingFakeConnection
    ->query('SELECT COUNT(*) FROM {faking_table}')
    ->fetchField();
  $this->testingFakeConnection
    ->insert('faking_table')
    ->fields([
    'id' => '123',
    'test_field' => '55',
  ])
    ->execute();
  // Testing that the insert is correct.
  $results = $this->testingFakeConnection
    ->select('faking_table')
    ->fields('faking_table')
    ->condition('id', '123')
    ->execute()
    ->fetchAll();
  $this->assertIsArray($results);
  $num_records_after = $this->testingFakeConnection
    ->query('SELECT COUNT(*) FROM {faking_table}')
    ->fetchField();
  $this->assertEquals($num_records_before + 1, $num_records_after, 'Merge inserted properly.');
  $this->assertSame('123', $results[0]->id);
  $this->assertSame('55', $results[0]->test_field);
}