Contents

class AddUniqueToInsightsFacet < ActiveRecord::Migration[5.2]
  def change
    # Remove duplicate records
    InsightsFacet.where.not(id: InsightsFacet.select('max(id)').group(:host_id)).delete_all

    # remove old index
    remove_index :insights_facets, [:host_id]
    # add unique constraint
    add_index :insights_facets, [:host_id], unique: true
  end
end

Version data entries

84 entries across 84 versions & 1 rubygems

Version	Path
foreman_rh_cloud-11.1.0	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-10.0.3	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-11.0.3	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.59	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-11.0.2	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-11.0.1	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-11.0.0	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.58	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-10.0.2	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.57	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-10.0.1	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.56	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.55	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.54	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.53	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.52	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.52	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-9.0.51	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.51	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb
foreman_rh_cloud-7.0.48	db/migrate/20210307000001_add_unique_to_insights_facet.foreman_rh_cloud.rb