Contents

class RemoveArfReportsWithoutPolicy < ActiveRecord::Migration
  def up
    User.as_anonymous_admin do
      ids_to_keep = ForemanOpenscap::ArfReport.unscoped.all.joins(:policy_arf_report).pluck(:id)
      ForemanOpenscap::ArfReport.unscoped.where.not(:id => ids_to_keep).find_in_batches do |batch|
        batch.map(&:destroy!)
      end
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
foreman_openscap-0.8.5	db/migrate/20171011134112_remove_arf_reports_without_policy.rb
foreman_openscap-0.7.12	db/migrate/20171011134112_remove_arf_reports_without_policy.rb