function SchemaTest::assertFieldCharacteristics

Asserts that a newly added field has the correct characteristics.

File

core/tests/Drupal/KernelTests/Core/Database/SchemaTest.php, line 741

Class

SchemaTest

Tests table creation and modification via the schema API.

Namespace

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 = $this->connection
            ->select($table_name)
            ->fields($table_name, [
            'serial_column',
        ])
            ->condition($field_name, $field_spec['initial'], '<>')
            ->countQuery()
            ->execute()
            ->fetchField();
        $this->assertEqual($count, 0, '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->assertEqual($count, 0, '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->assertEqual($count, 0, '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->assertEqual($field_value, $field_spec['default'], 'Default value registered.');
    }
}