function NonPublicSchemaTest::testMerge

@covers \Drupal\Core\Database\Connection::merge

File

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

Class

NonPublicSchemaTest

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

Namespace

Code

public function testMerge() : void {
  $num_records_before = $this->testingFakeConnection
    ->query('SELECT COUNT(*) FROM {faking_table}')
    ->fetchField();
  $this->testingFakeConnection
    ->merge('faking_table')
    ->key('id', '789')
    ->fields([
    'test_field' => 343,
  ])
    ->execute();
  $num_records_after = $this->testingFakeConnection
    ->query('SELECT COUNT(*) FROM {faking_table}')
    ->fetchField();
  $this->assertEquals($num_records_before + 1, $num_records_after, 'Merge inserted properly.');
  $merge_results = $this->testingFakeConnection
    ->select('faking_table')
    ->fields('faking_table')
    ->condition('id', '789')
    ->execute()
    ->fetchAll();
  $this->assertSame('789', $merge_results[0]->id);
  $this->assertSame('343', $merge_results[0]->test_field);
}