File: 20210801211024_remove_orphaned_user_custom_values.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 (12 lines) | stat: -rw-r--r-- 373 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
class RemoveOrphanedUserCustomValues < ActiveRecord::Migration[6.1]
  def up
    user_custom_field_ids = CustomField.where(field_format: 'user').ids
    if user_custom_field_ids.any?
      user_ids = Principal.ids
      CustomValue.
        where(custom_field_id: user_custom_field_ids).
        where.not(value: [nil, ''] + user_ids).
        delete_all
    end
  end
end