function SchemaTest::testUnsignedColumns in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/system/src/Tests/Database/SchemaTest.php \Drupal\system\Tests\Database\SchemaTest::testUnsignedColumns()
Tests creating unsigned columns and data integrity thereof.
File
- core/
modules/ system/ src/ Tests/ Database/ SchemaTest.php, line 423 - Contains \Drupal\system\Tests\Database\SchemaTest.
Class
- SchemaTest
- Tests table creation and modification via the schema API.
Namespace
Drupal\system\Tests\DatabaseCode
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',
),
);
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'],
)));
}
}