/db/migrate/20161205142618_delete_orphaned_smart_class_parameters.rb - Foreman

| Branch: | Tag: | Revision:

foreman/db/migrate/20161205142618_delete_orphaned_smart_class_parameters.rb @ ffd430c2

       class DeleteOrphanedSmartClassParameters < ActiveRecord::Migration
         def up
           LookupValue.joins(:lookup_key).where("NOT EXISTS (SELECT * FROM environment_classes WHERE environment_classes.puppetclass_lookup_key_id = lookup_keys.id) AND lookup_keys.type = 'PuppetclassLookupKey'").delete_all
           PuppetclassLookupKey.where("NOT EXISTS (SELECT * FROM environment_classes WHERE environment_classes.puppetclass_lookup_key_id = lookup_keys.id)").delete_all
         end
         def down
         end
       end

(338-338/341)