function InsertTest::testInsertIntegrityViolation

Tests insertion integrity violation with no default value for a column.

File

core/tests/Drupal/KernelTests/Core/Database/InsertTest.php, line 218

Class

InsertTest

Tests the insert builder.

Namespace

Code

public function testInsertIntegrityViolation() : void {
  // Remove the default from the 'age' column, so that inserting a record
  // without its value specified will lead to integrity failure.
  $this->connection
    ->schema()
    ->changeField('test', 'age', 'age', [
    'description' => "The person's age",
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => TRUE,
  ]);
  // Try inserting a record that misses the value for the 'age' column,
  // should raise an IntegrityConstraintViolationException.
  $this->expectException(IntegrityConstraintViolationException::class);
  $this->connection
    ->insert('test')
    ->fields([
    'name',
  ])
    ->values([
    'name' => 'Elvis',
  ])
    ->execute();
}