function SchemaTestCase::testUnsignedColumns

Tests creating unsigned columns and data integrity thereof.

File

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

Class

SchemaTestCase

Unit tests for the Schema API.

Code

function testUnsignedColumns() {
    // First create the table with just a serial column.
    $table_name = 'unsigned_table';
    $table_spec = array(
        'fields' => array(
            'serial_column' => array(
                'type' => 'serial',
                'unsigned' => TRUE,
                'not null' => TRUE,
            ),
        ),
        'primary key' => array(
            'serial_column',
        ),
    );
    $ret = array();
    db_create_table($table_name, $table_spec);
    // Now set up columns for the other types.
    $types = array(
        'int',
        'float',
        'numeric',
    );
    foreach ($types as $type) {
        $column_spec = array(
            'type' => $type,
            'unsigned' => TRUE,
        );
        if ($type == 'numeric') {
            $column_spec += array(
                'precision' => 10,
                'scale' => 0,
            );
        }
        $column_name = $type . '_column';
        $table_spec['fields'][$column_name] = $column_spec;
        db_add_field($table_name, $column_name, $column_spec);
    }
    // Finally, check each column and try to insert invalid values into them.
    foreach ($table_spec['fields'] as $column_name => $column_spec) {
        $this->assertTrue(db_field_exists($table_name, $column_name), format_string('Unsigned @type column was created.', array(
            '@type' => $column_spec['type'],
        )));
        $this->assertFalse($this->tryUnsignedInsert($table_name, $column_name), format_string('Unsigned @type column rejected a negative value.', array(
            '@type' => $column_spec['type'],
        )));
    }
}