function MergeTest::testMergeUpdateExpression

Tests a native merge combining literal updates and expressions.

File

core/modules/pgsql/tests/src/Kernel/pgsql/MergeTest.php, line 112

Class

MergeTest

Tests the native MERGE implementation of the PostgreSQL driver.

Namespace

Code

public function testMergeUpdateExpression() : void {
  $result = $this->connection
    ->merge('test_people')
    ->key('job', 'Speaker')
    ->fields([
    'name' => 'Tiffany',
  ])
    ->insertFields([
    'age' => 31,
  ])
    ->expression('age', '[age] + :age', [
    ':age' => 4,
  ])
    ->execute();
  $this->assertSame(Merge::STATUS_UPDATE, $result);
  $person = $this->connection
    ->query('SELECT * FROM {test_people} WHERE [job] = :job', [
    ':job' => 'Speaker',
  ])
    ->fetch();
  $this->assertEquals('Tiffany', $person->name);
  $this->assertEquals(34, $person->age);
}