Contents

class DeleteOrphanedSmartClassParameters < ActiveRecord::Migration[4.2]
  def up
    condition = 'NOT EXISTS (SELECT 1 FROM environment_classes WHERE environment_classes.puppetclass_lookup_key_id = lookup_keys.id)'
    LookupValue.joins(:lookup_key).where(condition).where("lookup_keys.type = 'PuppetclassLookupKey'").delete_all
    PuppetclassLookupKey.where(condition).delete_all
  end

  def down
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
foreman_puppet-1.0.5	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.4	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.3	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.2	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.1	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.0	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.0.rc.2	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-1.0.0.rc.1	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-0.1.0	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-0.0.2	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb
foreman_puppet-0.0.1	db/migrate_foreman/20161205142618_delete_orphaned_smart_class_parameters.rb