function InvalidDataTest::testInsertDuplicateData

Tests aborting of traditional SQL database systems with invalid data.

File

core/tests/Drupal/KernelTests/Core/Database/InvalidDataTest.php, line 19

Class

InvalidDataTest

Tests handling of some invalid data.

Namespace

Code

public function testInsertDuplicateData() : void {
    // Try to insert multiple records where at least one has bad data.
    $this->expectException(IntegrityConstraintViolationException::class);
    try {
        $this->connection
            ->insert('test')
            ->fields([
            'name',
            'age',
            'job',
        ])
            ->values([
            'name' => 'Elvis',
            'age' => 63,
            'job' => 'Singer',
        ])
            ->values([
            // Duplicate value 'John' on unique field 'name'.
'name' => 'John',
            'age' => 17,
            'job' => 'Consultant',
        ])
            ->values([
            'name' => 'Frank',
            'age' => 75,
            'job' => 'Singer',
        ])
            ->execute();
        $this->fail('Insert succeeded when it should not have.');
    } catch (IntegrityConstraintViolationException $e) {
        // Ensure the whole transaction is rolled back when a duplicate key
        // insert occurs.
        $this->assertFalse($this->connection
            ->select('test')
            ->fields('test', [
            'name',
            'age',
        ])
            ->condition('age', [
            63,
            17,
            75,
        ], 'IN')
            ->execute()
            ->fetchObject());
        throw $e;
    }
}