Elixir Ecto, failed change type to jsonb

Questions / Help
,
3

Long time passed since this, but I’ve just ran into the same problem and wanted to share some feedback for future reference. I’ve found a solution based in this similar post.
While @benwilson512 solution works, it won’t if the database contains existing data in the :reason field. It must be cased from the previous type to the new one.

Asuming the old type for :reason is :text, the migration should execute the following:

...

def change do
  execute(&execute_up/0, &execute_down/0)
end

def execute_up() do
  repo().query!(
    "ALTER table disbursements ALTER column reason TYPE jsonb USING (disbursements::jsonb);",
    [],
    # Just an option to log the execution
    log: :info
  )
end

def execute_down() do
  repo().query!(
    "ALTER table disbursements ALTER column reason TYPE text;",
    [],
    # Just an option to log the execution
    log: :info
  )
end

...
2 Likes