public function testCreateTableWithNotAutoIncrementPrimaryKey() { $primaryKey = new PrimaryKey(); $primaryKey->disableAutoIncrement(); $table = new Table('foo'); $table->addConstraint($primaryKey); $this->getCreateTableCommand()->setTable($table)->execute(); $getTableCommand = new GetTableCommand(); $getTableCommand->setConnection($this->connection); $getTableCommand->setTableName('foo'); $tableInfo = $getTableCommand->execute(); $this->assertEquals('integer', $tableInfo->getColumn('foo_id')->getType()); }
public function testForeignKey() { $getTableCommand = new GetTableCommand(); $getTableCommand->setConnection($this->connection); $getTableCommand->setTableName('foo'); $table = $getTableCommand->execute(); foreach ($table->getConstraints() as $constraint) { if ($constraint instanceof ForeignKey) { $this->assertInstanceOf('Rentgen\\Database\\Constraint\\ForeignKey', $constraint); $this->assertEquals('foo_bar_fkey', $constraint->getName()); } } }