Redmine

  before_destroy :delete_workflow_rules

  # Deletes workflow rules that refer to this custom field

  def delete_workflow_rules

    WorkflowPermission.where(:field_name => id.to_s).delete_all

  end

class DeleteOrphanedWorkflowRulesOfCustomFields < ActiveRecord::Migration[8.1]

  def up

    field_names = WorkflowPermission.where.not(field_name: nil).distinct.pluck(:field_name)

    custom_field_ids = field_names.grep(/\A\d+\z/).map(&:to_i)

    orphaned_ids = custom_field_ids - CustomField.where(id: custom_field_ids).pluck(:id)

    if orphaned_ids.any?

      WorkflowPermission.where(field_name: orphaned_ids.map(&:to_s)).delete_all

    end

  end

  def down

    # no-op

  end

end

  def test_destroy_should_delete_workflow_rules

    field = IssueCustomField.create!(:name => 'Field', :field_format => 'string')

    WorkflowPermission.create!(:role_id => 1, :tracker_id => 1, :old_status_id => 1, :field_name => field.id.to_s, :rule => 'required')

    assert_equal 1, WorkflowPermission.where(:field_name => field.id.to_s).count

    field.destroy

    assert_equal 0, WorkflowPermission.where(:field_name => field.id.to_s).count

  end