/**
* setUp
* @see PHPUnit_Framework_TestCase::setUp()
*/
protected function setUp()
{
Migration::run(Migration::create("migration1", function (Migration $m) {
$m->table("sample_table", function ($table) {
$table->id();
$table->varchar("title", 25);
$table->text("content");
$table->timesptamps();
});
}));
}
function setUp()
{
$tableName = $this->tableName;
Migration::run(Migration::create("sample_table2", function (Migration $m) use($tableName) {
$m->table($tableName, function ($table) {
$table->id();
$table->varchar("title", 25);
$table->text("content");
$table->timesptamps();
});
}));
}
/**
* setUp
* @see PHPUnit_Framework_TestCase::setUp()
*/
protected function setUp()
{
Migration::run(Migration::create("migration1", function (Migration $m) {
$m->table("sample_table_simple_crud", function (Table $table) {
$table->id();
$table->integer("user_id")->notnull();
$table->varchar("title", 25);
$table->text("content");
$table->timesptamps();
});
}));
}
function testModifyTable()
{
$createTestTable = Migration::create("migration1", function (Migration $m) {
$m->table("sample_table", function ($table) {
$table->id();
$table->varchar("title", 25);
$table->text("content");
$table->timesptamps();
});
});
$modifyTable = Migration::create("migration2", function (Migration $m) {
$m->table("sample_table", function ($table) {
$table->text("fugafuga");
});
});
//テーブル作成
Migration::run([$createTestTable, $modifyTable]);
$columns = $this->getColumns("sample_table");
$this->assertArrayHasKey("id", $columns);
$this->assertArrayHasKey("title", $columns);
$this->assertArrayHasKey("content", $columns);
$this->assertArrayHasKey("fugafuga", $columns);
$this->assertArrayHasKey("created_at", $columns);
$this->assertArrayHasKey("updated_at", $columns);
//カラムの削除
$createTestTable = Migration::create("migration1", function (Migration $m) {
$m->table("drop_column_table", function ($table) {
$table->id();
$table->varchar("title", 25);
$table->text("content");
$table->timesptamps();
});
});
$deleteColumn = Migration::create("migration3", function (Migration $m) {
$m->table("sample_table", function (Table $table) {
$table->dropColumn("fugafuga");
});
});
Migration::run($createTestTable);
Migration::run($deleteColumn);
$columns = $this->getColumns("sample_table");
$this->assertArrayNotHasKey("fugafuga", $columns, "カラムの削除に失敗");
}
