Rails 6 migrations to upgrade SQLite booleans from t/f to 1/0

convert_sqlite_booleans.rb

class ConvertSqliteBooleans < ActiveRecord::Migration[6.0]
  BOOLEANS = [
    [ 'table_name',    'column_name' ],
    [ 'table_name',    'column_name' ],
  ]

  def up
    BOOLEANS.each do |table, column|
      execute "UPDATE #{table} SET #{column} = 1 WHERE #{column} = 't';"
      execute "UPDATE #{table} SET #{column} = 0 WHERE #{column} = 'f' OR #{column} IS NULL;"
    end
  end

  def down
    BOOLEANS.each do |table, column|
      execute "UPDATE #{table} SET #{column} = 't' WHERE #{column} = 1;"
      execute "UPDATE #{table} SET #{column} = 'f' WHERE #{column} = 0;"
    end
  end
end