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-6.0.42	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.41	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.39	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.38	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.35	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.37	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.36	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.35	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.34	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.33	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-3.0.32	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.32	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.32	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.31	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.31	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.30	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.30	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-3.0.29	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-4.0.29	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb
foreman_rh_cloud-5.0.29	db/migrate/20201007121540_setup_hits_count_cache.foreman_rh_cloud.rb