Should reverse migrations work?

issues
1

Hello. :wave: I’m not sure if this is a bug or if I’m doing something wrong but I discovered the following migrations can’t be reversed:

ROM::SQL.migration do
  change do
    create_table :users do
      primary_key :id, :bigint
      column :email, :text, null: false
      column :name, :text, null: false
      column :created_at, :timestamp, null: false, default: Sequel.lit("(now() at time zone 'utc')")
      column :updated_at, :timestamp, null: false, default: Sequel.lit("(now() at time zone 'utc')")
    end
  end
end

I doing this by running hanami db rollback and seeing the following:

!!! => "database hemo_development rolled back to 20230112220941_create_users" FAILED

If you’d like to play with this locally, here’s my simple Hanami demo application which you can try for yourself.

2

@bkuhlmann I will see if we can reproduce the problem when working on the CLI.
Those commands aren’t officially out, and we expect them not to work correctly. Sorry.

3

OK, thanks. Mostly trying to figure out what I can shim together while I wait for the Hanami 2.1.0 release. :sweat_smile: