Contents

class SetupHitsCountCache < ActiveRecord::Migration[5.0]
  def up
    ActiveRecord::Base.connection.execute <<-SQL.squish
    UPDATE insights_facets
    SET hits_count = (SELECT count(1)
                              FROM insights_hits
                              WHERE insights_hits.host_id = insights_facets.host_id)
    SQL
  end
end

Version data entries

105 entries across 105 versions & 1 rubygems

Version	Path
foreman_rh_cloud-7.0.47	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.50	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.49	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.48	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.47	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-8.0.46	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-6.0.45	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.46	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.45	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-7.0.46	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.44	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-7.0.45	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-6.0.44	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.43	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.36	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-3.0.33	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-6.0.42.2	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-6.0.42.1	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-6.0.43	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.42	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb