public function testGenerateTableWithMultiColumnUniqueIndex()
{
$table = new \Doctrine\DBAL\Schema\Table('test');
$table->addColumn('foo', 'string', array('notnull' => false, 'length' => 255));
$table->addColumn('bar', 'string', array('notnull' => false, 'length' => 255));
$table->addUniqueIndex(array("foo", "bar"));
$sql = $this->_platform->getCreateTableSQL($table);
$this->assertEquals($this->getGenerateTableWithMultiColumnUniqueIndexSql(), $sql);
}
public function testLoadMetadataFromDatabaseDetail()
{
if (!$this->_em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) {
$this->markTestSkipped('Platform does not support foreign keys.');
}
$table = new \Doctrine\DBAL\Schema\Table("dbdriver_foo");
$table->addColumn('id', 'integer', array('unsigned' => true));
$table->setPrimaryKey(array('id'));
$table->addColumn('column_unsigned', 'integer', array('unsigned' => true));
$table->addColumn('column_comment', 'string', array('comment' => 'test_comment'));
$table->addColumn('column_default', 'string', array('default' => 'test_default'));
$table->addColumn('column_decimal', 'decimal', array('precision' => 4, 'scale' => 3));
$table->addColumn('column_index1', 'string');
$table->addColumn('column_index2', 'string');
$table->addIndex(array('column_index1', 'column_index2'), 'index1');
$table->addColumn('column_unique_index1', 'string');
$table->addColumn('column_unique_index2', 'string');
$table->addUniqueIndex(array('column_unique_index1', 'column_unique_index2'), 'unique_index1');
$this->_sm->dropAndCreateTable($table);
$metadatas = $this->extractClassMetadata(array("DbdriverFoo"));
$this->assertArrayHasKey('DbdriverFoo', $metadatas);
$metadata = $metadatas['DbdriverFoo'];
$this->assertArrayHasKey('id', $metadata->fieldMappings);
$this->assertEquals('id', $metadata->fieldMappings['id']['fieldName']);
$this->assertEquals('id', strtolower($metadata->fieldMappings['id']['columnName']));
$this->assertEquals('integer', (string) $metadata->fieldMappings['id']['type']);
// FIXME: Condition here is fugly.
// NOTE: PostgreSQL and SQL SERVER do not support UNSIGNED integer
if (!$this->_em->getConnection()->getDatabasePlatform() instanceof PostgreSqlPlatform and !$this->_em->getConnection()->getDatabasePlatform() instanceof SQLServerPlatform) {
$this->assertArrayHasKey('columnUnsigned', $metadata->fieldMappings);
$this->assertTrue($metadata->fieldMappings['columnUnsigned']['options']['unsigned']);
}
$this->assertArrayHasKey('columnComment', $metadata->fieldMappings);
$this->assertEquals('test_comment', $metadata->fieldMappings['columnComment']['options']['comment']);
$this->assertArrayHasKey('columnDefault', $metadata->fieldMappings);
$this->assertEquals('test_default', $metadata->fieldMappings['columnDefault']['options']['default']);
$this->assertArrayHasKey('columnDecimal', $metadata->fieldMappings);
$this->assertEquals(4, $metadata->fieldMappings['columnDecimal']['precision']);
$this->assertEquals(3, $metadata->fieldMappings['columnDecimal']['scale']);
$this->assertTrue(!empty($metadata->table['indexes']['index1']['columns']));
$this->assertEquals(array('column_index1', 'column_index2'), $metadata->table['indexes']['index1']['columns']);
$this->assertTrue(!empty($metadata->table['uniqueConstraints']['unique_index1']['columns']));
$this->assertEquals(array('column_unique_index1', 'column_unique_index2'), $metadata->table['uniqueConstraints']['unique_index1']['columns']);
}
