Clean up duplicate Installed packages

clean_installed_packages.rb

x = ::Katello::InstalledPackage.group(:nvra).having("count(nvra) > 1").pluck(:nvra)
y = {}
x.each do |multi_nvra|
  multi_nvra_in_packages = ::Katello::InstalledPackage.where(nvra: multi_nvra)
  multi_nvra_in_packages_count = multi_nvra_in_packages.count
  multi_nvra_in_packages_nvrea_count = multi_nvra_in_packages.pluck(:nvrea).uniq.count
  if(multi_nvra_in_packages_count != multi_nvra_in_packages_nvrea_count)
    multi_nvra_in_packages.each do |package|
      if y[package.nvrea]
        y[package.nvrea] << package.id
      else  
        y[package.nvrea] = [package.id]
      end
    end
  end
end
y.keys.each do |nvra|
  y.delete(nvra) if y[nvra].size == 1
end
 
y.keys.each do |nvra|
  id_to_keep = y[nvra][0]
  ids_to_delete = y[nvra].drop(1)
  Katello::HostInstalledPackage.where(installed_package_id: ids_to_delete).update_all(installed_package_id: id_to_keep)
  Katello::InstalledPackage.where(id: ids_to_delete).delete_all