public function testGetColumns()
{
$table = new \Phinx\Db\Table('t', array(), $this->adapter);
$table->addColumn('column1', 'string')->addColumn('column2', 'integer')->addColumn('column3', 'biginteger')->addColumn('column4', 'text')->addColumn('column5', 'float')->addColumn('column6', 'decimal')->addColumn('column7', 'time')->addColumn('column8', 'timestamp')->addColumn('column9', 'date')->addColumn('column10', 'boolean')->addColumn('column11', 'datetime')->addColumn('column12', 'binary')->addColumn('column13', 'string', array('limit' => 10));
$pendingColumns = $table->getPendingColumns();
$table->save();
$columns = $this->adapter->getColumns('t');
$this->assertCount(count($pendingColumns) + 1, $columns);
for ($i = 0; $i++; $i < count($pendingColumns)) {
$this->assertEquals($pendingColumns[$i], $columns[$i + 1]);
}
}
public function testAddEnumColumn()
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn('enum_column'));
$table->addColumn('enum_column', 'enum', array('values' => array('one', 'two')))->save();
$rows = $this->adapter->fetchAll('SHOW COLUMNS FROM table1');
$this->assertEquals("enum('one','two')", $rows[1]['Type']);
}
