Penggunaan Yii2 Migration

by

Referensi: http://www.yiiframework.com/doc-2.0/guide-db-migrations.html

Buka terminal, masuk ke root folder project:

Ceritanya mau bikin table pegawai

  1. ketik: yii migrate/create create_pegawai_table -> akan menggenerate skeleton code di folder migrations (m160928_024257_create_pegawai_table.php)
  2. edit file: m160928_024257_create_pegawai_table.php (Referensi: http://www.yiiframework.com/doc-2.0/yii-db-schemabuildertrait.html)
    misal: 
    $this->createTable('pegawai', [
    'id' => $this->primaryKey(),
    'name' => $this->string(64)->notNull(),
    'type' => $this->integer()->notNull()->defaultValue(10),
    'description' => $this->text(),
    'rule_name' => $this->string(64),
    'data' => $this->text(),
    'created_at' => $this->datetime()->notNull(),
    'updated_at' => $this->datetime(),
]);
  3. ketik: yii migrate -> eksekusi migrate ke versi terakhir
  4. revert migration: yii migrate/down
    default Yii2, down berarti drop table
  5. misal ada perubahan pada migration file, untuk update, bisa yii migrate/down dulu, baru kemudian yii migrate lagi
  6. CMIIW

Leave a Comment