File: 20241022095140_remove_orphaned_custom_value_attachments.rb

package info (click to toggle)
redmine 6.0.6%2Bds-5
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 20,104 kB
  • sloc: ruby: 116,318; javascript: 12,885; sh: 460; perl: 303; python: 166; makefile: 30
file content (11 lines) | stat: -rw-r--r-- 317 bytes parent folder | download | duplicates (3)
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