protected function SchemaTestCase::assertFieldCharacteristics in Drupal 7

Assert that a newly added field has the correct characteristics.

1 call to SchemaTestCase::assertFieldCharacteristics()

SchemaTestCase::assertFieldAdditionRemoval in modules/simpletest/tests/schema.test

Assert that a given field can be added and removed from a table.

File

modules/simpletest/tests/schema.test, line 355

Tests for the Database Schema API.

Class

SchemaTestCase

Unit tests for the Schema API.

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);
}