protected function SchemaTest::assertFieldCharacteristics

Asserts that a newly added field has the correct characteristics.

1 call to SchemaTest::assertFieldCharacteristics()
SchemaTest::assertFieldAdditionRemoval in drupal/core/modules/system/lib/Drupal/system/Tests/Database/SchemaTest.php
Asserts that a given field can be added and removed from a table.

File

drupal/core/modules/system/lib/Drupal/system/Tests/Database/SchemaTest.php, line 371
Contains Drupal\system\Tests\Database\SchemaTest.

Class

SchemaTest
Tests the Schema API.

Namespace

Drupal\system\Tests\Database

Code

protected function assertFieldCharacteristics($table_name, $field_name, $field_spec) {

  // 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 = db_select($table_name)
      ->fields($table_name, array(
      'serial_column',
    ))
      ->condition($field_name, $field_spec['initial'], '<>')
      ->countQuery()
      ->execute()
      ->fetchField();
    $this
      ->assertEqual($count, 0, 'Initial values 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 = db_insert($table_name)
      ->useDefaults(array(
      'serial_column',
    ))
      ->execute();
    $field_value = db_select($table_name)
      ->fields($table_name, array(
      $field_name,
    ))
      ->condition('serial_column', $id)
      ->execute()
      ->fetchField();
    $this
      ->assertEqual($field_value, $field_spec['default'], 'Default value registered.');
  }
  db_drop_field($table_name, $field_name);
}