Contents

class RemoveDeletedPolicy < ActiveRecord::Migration
  def up
    ForemanOpenscap::AssetPolicy.all.collect(&:policy_id).uniq.each do |policy_id|
      execute("DELETE FROM foreman_openscap_asset_policies WHERE policy_id = '#{policy_id}';") if ForemanOpenscap::Policy.unscoped.find_by(id: policy_id).nil?
    end
  end

  def down
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
foreman_openscap-0.7.13	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.8.6	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.8.5	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.7.12	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.8.4	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.7.11	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.7.10	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-0.8.3	db/migrate/20160830113437_remove_deleted_policy.rb