Contents

class RemoveDuplicateServices2 < ActiveRecord::Migration
  def change
    duplicate_keys = Mdm::Service.count(group: [:host_id, :port, :proto]).select { |k,v| v >1 }.keys
    duplicate_keys.each do |keys|
      duplicate_services = Mdm::Service.where(host_id: keys[0], port: keys[1], proto: keys[2]).order(:created_at)
      duplicate_services.pop
      duplicate_services.each(&:destroy)
    end

    add_index :services, [:host_id, :port, :proto], unique: true
  end
end

Version data entries

31 entries across 31 versions & 1 rubygems

Version	Path
metasploit_data_models-1.2.11	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.10	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.9	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.8	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.7	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.6	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.5	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.4	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.3	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.2	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-0.24.5	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-0.24.4	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.1	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.2.0	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.1.0	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.0.1	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-1.0.0	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-0.24.3	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-0.24.2	db/migrate/20150212214222_remove_duplicate_services2.rb
metasploit_data_models-0.24.1.pre.rspec.pre.3.pre.1	db/migrate/20150212214222_remove_duplicate_services2.rb