/**
* @dataProvider providerArrayType
*/
public function testAddColumnArrayType($column_name, $column_type)
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn($column_name));
$table->addColumn($column_name, $column_type)->save();
$this->assertTrue($table->hasColumn($column_name));
}
public function testAddColumn()
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn('email'));
$table->addColumn('email', 'string')->save();
$this->assertTrue($table->hasColumn('email'));
$table->addColumn('realname', 'string', array('after' => 'id'))->save();
$rows = $this->adapter->fetchAll('SHOW COLUMNS FROM table1');
$this->assertEquals('realname', $rows[1]['Field']);
}
public function testAddColumn()
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn('email'));
$table->addColumn('email', 'string')->save();
$this->assertTrue($table->hasColumn('email'));
}
public function testAddColumn()
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn('email'));
$table->addColumn('email', 'string')->save();
$this->assertTrue($table->hasColumn('email'));
// In SQLite it is not possible to dictate order of added columns.
// $table->addColumn('realname', 'string', array('after' => 'id'))
// ->save();
// $this->assertEquals('realname', $rows[1]['Field']);
}
public function testHasColumnReservedName()
{
$tableQuoted = new \Phinx\Db\Table('group', array(), $this->adapter);
$tableQuoted->addColumn('value', 'string')->save();
$this->assertFalse($tableQuoted->hasColumn('column2'));
$this->assertTrue($tableQuoted->hasColumn('value'));
}
public function testAddStringColumnWithSignedEqualsFalse()
{
$table = new \Phinx\Db\Table('table1', array(), $this->adapter);
$table->save();
$this->assertFalse($table->hasColumn('user_id'));
$table->addColumn('user_id', 'string', array('signed' => false))->save();
$rows = $this->adapter->fetchAll('SHOW COLUMNS FROM table1');
$this->assertEquals('varchar(255)', $rows[1]['Type']);
}
