function SchemaTestCase::testSchemaAddField

Test adding columns to an existing table.

File

core/modules/simpletest/tests/schema.test, line 198

Tests for the Database Schema API.

Class

SchemaTestCase

Unit tests for the Schema API.

Code

function testSchemaAddField() {
  // Test varchar types.
  foreach (array(1, 32, 128, 256, 512) as $length) {
    $base_field_spec = array(
      'type' => 'varchar',
      'length' => $length,
    );
    $variations = array(
      array('not null' => FALSE),
      array('not null' => FALSE, 'default' => '7'),
      array('not null' => TRUE, 'initial' => 'd'),
      array('not null' => TRUE, 'initial' => 'd', 'default' => '7'),
    );

    foreach ($variations as $variation) {
      $field_spec = $variation + $base_field_spec;
      $this->assertFieldAdditionRemoval($field_spec);
    }
  }

  // Test int and float types.
  foreach (array('int', 'float') as $type) {
    foreach (array('tiny', 'small', 'medium', 'normal', 'big') as $size) {
      $base_field_spec = array(
        'type' => $type,
        'size' => $size,
      );
      $variations = array(
        array('not null' => FALSE),
        array('not null' => FALSE, 'default' => 7),
        array('not null' => TRUE, 'initial' => 1),
        array('not null' => TRUE, 'initial' => 1, 'default' => 7),
      );

      foreach ($variations as $variation) {
        $field_spec = $variation + $base_field_spec;
        $this->assertFieldAdditionRemoval($field_spec);
      }
    }
  }

  // Test numeric types.
  foreach (array(1, 5, 10, 40, 65) as $precision) {
    foreach (array(0, 2, 10, 30) as $scale) {
      if ($precision <= $scale) {
        // Precision must be smaller than scale.
        continue;
      }

      $base_field_spec = array(
        'type' => 'numeric',
        'scale' => $scale,
        'precision' => $precision,
      );
      $variations = array(
        array('not null' => FALSE),
        array('not null' => FALSE, 'default' => 7),
        array('not null' => TRUE, 'initial' => 1),
        array('not null' => TRUE, 'initial' => 1, 'default' => 7),
      );

      foreach ($variations as $variation) {
        $field_spec = $variation + $base_field_spec;
        $this->assertFieldAdditionRemoval($field_spec);
      }
    }
  }
}