/db/migrate/20160307120453_remove_hostgroups_count_from_puppetclasses.rb - Foreman

| Branch: | Tag: | Revision:

foreman/db/migrate/20160307120453_remove_hostgroups_count_from_puppetclasses.rb @ 672e0467

       class RemoveHostgroupsCountFromPuppetclasses < ActiveRecord::Migration[4.2]
         def up
           remove_column :puppetclasses, :hostgroups_count
         end
         def down
           add_column :puppetclasses, :hostgroups_count, :integer, :default => 0
           execute 'UPDATE puppetclasses SET hostgroups_count = (SELECT COUNT(*) FROM hostgroup_classes WHERE hostgroup_classes.puppetclass_id = puppetclasses.id)'
         end
       end

(306-306/407)