Contents

class RemoveDuplicateServices < ActiveRecord::Migration[4.2]
  def change
    select_mgr = Mdm::Service.arel_table.project(
      Mdm::Service[:host_id],
      Mdm::Service[:proto],
      Mdm::Service[:port].count
    ).group(
      'host_id',
      'port',
      'proto'
    ).having(Mdm::Service[:port].count.gt(1))

    Mdm::Service.find_by_sql(select_mgr).each(&:destroy)

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

Version data entries

23 entries across 23 versions & 2 rubygems

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