Revision ffd430c2
Added by Ori Rabin over 7 years ago
| db/migrate/20161205142618_delete_orphaned_smart_class_parameters.rb | ||
|---|---|---|
|
class DeleteOrphanedSmartClassParameters < ActiveRecord::Migration
|
||
|
def up
|
||
|
PuppetclassLookupKey.where("NOT EXISTS (SELECT * FROM environment_classes WHERE environment_classes.puppetclass_lookup_key_id = lookup_keys.id)").destroy_all
|
||
|
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
|
||
Also available in: Unified diff
fixes #17899 - Delete instead of destroy orphaned records