Project

General

Profile

Defect #38966 » 20240523085253_remove_orphaned_custom_value_attachments.rb

Go MAEDA, 2024-05-23 11:15

 
class RemoveOrphanedCustomValueAttachments < ActiveRecord::Migration[7.1]
def up
Attachment.where(container_type: 'CustomValue')
.where('NOT EXISTS (SELECT 1 FROM custom_values WHERE custom_values.id = attachments.container_id)')
.destroy_all
end

def down
# no-op
end
end
(3-3/4)