]> git.openstreetmap.org Git - rails.git/blob - db/migrate/20240822121603_backfill_deactivates_at_in_user_blocks.rb
Merge pull request #5932 from tomhughes/frozen-strings
[rails.git] / 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