db/migrate/20240822121603_backfill_deactivates_at_in_user_blocks.rb

   1 # frozen_string_literal: true
   2
   3 class BackfillDeactivatesAtInUserBlocks < ActiveRecord::Migration[7.1]
   4   class UserBlock < ApplicationRecord; end
   5
   6   disable_ddl_transaction!
   7
   8   def up
   9     UserBlock.where(:needs_view => false, :deactivates_at => nil).in_batches do |relation|
  10       relation.update_all("deactivates_at = GREATEST(ends_at, updated_at)")
  11     end
  12   end
  13 end