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); }
/** * @group DBAL-42 */ public function testCreateTableColumnComments() { $table = new \Doctrine\DBAL\Schema\Table('test'); $table->addColumn('id', 'integer', array('comment' => 'This is a comment')); $table->setPrimaryKey(array('id')); $this->assertEquals($this->getCreateTableColumnCommentsSQL(), $this->_platform->getCreateTableSQL($table)); }
/** * @group DBAL-374 */ public function testQuotedColumnInIndexPropagation() { $this->markTestSkipped('requires big refactoring of Platforms'); $table = new Table('`quoted`'); $table->addColumn('`key`', 'string'); $table->addIndex(array('key')); $sql = $this->_platform->getCreateTableSQL($table); $this->assertEquals($this->getQuotedColumnInIndexSQL(), $sql); }