Contents

class RemoveDeletedPolicy < ActiveRecord::Migration[4.2]
  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

76 entries across 76 versions & 1 rubygems

Version	Path
foreman_openscap-10.2.1	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.2.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.5	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.1.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.0.3	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.0.2	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.0.1	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-10.0.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.4	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.3	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.2	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.1	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-9.0.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-8.0.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-7.1.1	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-7.1.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-7.0.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-6.0.0	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-5.2.3	db/migrate/20160830113437_remove_deleted_policy.rb
foreman_openscap-5.2.2	db/migrate/20160830113437_remove_deleted_policy.rb