Migrations & Seeds

Flowra membungkus Knex migrations dan seeds melalui CLI yang membaca orm.cli.config.js.

Buat migration

flowra db:migrate:make create_users_table

Secara default, migration disimpan di app/Database/Migrations.

Jalankan migrations

flowra db:migrate:latest

Rollback

flowra db:rollback
flowra db:rollback --all

Status migration

flowra db:status

Seeds

Buat seed:

flowra db:seed:make seed_users

Jalankan seed:

flowra db:seed:run

Contoh migration

app/Database/Migrations/20251025213153_create_table_users.js

exports.up = function(knex) {
  return knex.schema.createTable('users', function(table) {
    table.increments('id').primary();
    table.string('username').notNullable().unique();
    table.string('email').notNullable().unique();
    table.string('password').notNullable();
    table.timestamp('createdAt').nullable();
    table.timestamp('updatedAt').nullable();
    table.timestamp('deletedAt').nullable();
  });
};

exports.down = function(knex) {
  return knex.schema.dropTableIfExists('users');
};

Alias koneksi

Gunakan --env <alias> pada command migration dan seed untuk menargetkan konfigurasi database tertentu.