function DriverSpecificSchemaTestBase::assertFieldCharacteristics

Asserts that a newly added field has the correct characteristics.

@internal

File

core/tests/Drupal/KernelTests/Core/Database/DriverSpecificSchemaTestBase.php, line 509

Class

DriverSpecificSchemaTestBase

Tests table creation and modification via the schema API.

Namespace

Code

protected function assertFieldCharacteristics(string $table_name, string $field_name, array $field_spec) : void {
  // Check that the initial value has been registered.
  if (isset($field_spec['initial'])) {
    // There should be no row with a value different then $field_spec['initial'].
    $count = $this->connection
      ->select($table_name)
      ->fields($table_name, [
      'serial_column',
    ])
      ->condition($field_name, $field_spec['initial'], '<>')
      ->countQuery()
      ->execute()
      ->fetchField();
    $this->assertEquals(0, $count, 'Initial values filled out.');
  }
  // Check that the initial value from another field has been registered.
  if (isset($field_spec['initial_from_field']) && !isset($field_spec['initial'])) {
    // There should be no row with a value different than
    // $field_spec['initial_from_field'].
    $count = $this->connection
      ->select($table_name)
      ->fields($table_name, [
      'serial_column',
    ])
      ->where("[{$table_name}].[{$field_spec['initial_from_field']}] <> [{$table_name}].[{$field_name}]")
      ->countQuery()
      ->execute()
      ->fetchField();
    $this->assertEquals(0, $count, 'Initial values from another field filled out.');
  }
  elseif (isset($field_spec['initial_from_field']) && isset($field_spec['initial'])) {
    // There should be no row with a value different than '100'.
    $count = $this->connection
      ->select($table_name)
      ->fields($table_name, [
      'serial_column',
    ])
      ->condition($field_name, 100, '<>')
      ->countQuery()
      ->execute()
      ->fetchField();
    $this->assertEquals(0, $count, 'Initial values from another field or a default value filled out.');
  }
  // Check that the default value has been registered.
  if (isset($field_spec['default'])) {
    // Try inserting a row, and check the resulting value of the new column.
    $id = $this->connection
      ->insert($table_name)
      ->useDefaults([
      'serial_column',
    ])
      ->execute();
    $field_value = $this->connection
      ->select($table_name)
      ->fields($table_name, [
      $field_name,
    ])
      ->condition('serial_column', $id)
      ->execute()
      ->fetchField();
    $this->assertEquals($field_spec['default'], $field_value, 'Default value registered.');
  }
}