public function SqlServerSchemaTest::testPrimaryKeyHandling in Drupal driver for SQL Server and SQL Azure 7.2
Same name and namespace in other branches
- 7.3 tests/sqlsrv.schema.test \SqlServerSchemaTest::testPrimaryKeyHandling()
- 7 tests/sqlsrv.schema.test \SqlServerSchemaTest::testPrimaryKeyHandling()
Test adding / removing / readding a primary key to a table.
File
- tests/
sqlsrv.schema.test, line 19 - Support tests for SQL Server.
Class
- SqlServerSchemaTest
- @file Support tests for SQL Server.
Code
public function testPrimaryKeyHandling() {
$table_spec = array(
'fields' => array(
'id' => array(
'type' => 'int',
'not null' => TRUE,
),
),
);
db_create_table('test_table', $table_spec);
$this
->assertTrue(db_table_exists('test_table'), t('Creating a table without a primary key works.'));
db_add_primary_key('test_table', array(
'id',
));
$this
->pass(t('Adding a primary key should work when the table has no data.'));
// Try adding a row.
db_insert('test_table')
->fields(array(
'id' => 1,
))
->execute();
// The second row with the same value should conflict.
try {
db_insert('test_table')
->fields(array(
'id' => 1,
))
->execute();
$this
->fail(t('Duplicate values in the table should not be allowed when the primary key is there.'));
} catch (Exception $e) {
}
// Drop the primary key and retry.
db_drop_primary_key('test_table');
$this
->pass(t('Removing a primary key should work.'));
db_insert('test_table')
->fields(array(
'id' => 1,
))
->execute();
$this
->pass(t('Adding a duplicate row should work without the primary key.'));
try {
db_add_primary_key('test_table', array(
'id',
));
$this
->fail(t('Trying to add a primary key should fail with duplicate rows in the table.'));
} catch (Exception $e) {
}
}