Contents

class AddCounterCachesToHosts < ActiveRecord::Migration[4.2]

  def self.up
    add_column :hosts, :note_count, :integer, :default => 0
    add_column :hosts, :vuln_count, :integer, :default => 0
    add_column :hosts, :service_count, :integer, :default => 0
  
    Mdm::Host.reset_column_information
    Mdm::Host.all.each do |h|
      Mdm::Host.reset_counters h.id, :notes
      Mdm::Host.reset_counters h.id, :vulns
      Mdm::Host.reset_counters h.id, :services
    end
  end

  def self.down
    remove_column :hosts, :note_count
    remove_column :hosts, :vuln_count
    remove_column :hosts, :service_count
  end
end

Version data entries

23 entries across 23 versions & 2 rubygems

Version	Path
metasploit_data_models-6.0.6	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
wg-metasploit_data_models-4.1.4.02	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.5	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.4	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.3	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.2	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.1	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-6.0.0	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.6	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.5	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.4	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.3	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.2	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.1	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-5.0.0	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-4.1.4	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-4.1.3	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-4.1.2	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-4.1.1	db/migrate/20120601152442_add_counter_caches_to_hosts.rb
metasploit_data_models-4.1.0	db/migrate/20120601152442_add_counter_caches_to_hosts.rb