db/migrate/20241022095140_remove_orphaned_custom_value_attachments.rb


1
2
3
4
5
6
7
8
9
10
11

class RemoveOrphanedCustomValueAttachments < ActiveRecord::Migration[7.2]
  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