Glitch-Shrike/db/migrate/20220309213005_fix_reblog_d...

21 lines
392 B
Ruby

# frozen_string_literal: true
class FixReblogDeletedAt < ActiveRecord::Migration[6.1]
disable_ddl_transaction!
def up
safety_assured do
execute <<~SQL.squish
UPDATE statuses s
SET deleted_at = r.deleted_at
FROM statuses r
WHERE
s.reblog_of_id = r.id
AND r.deleted_at IS NOT NULL
SQL
end
end
def down; end
end