ankane / hightop Goto Github PK

# frozen_string_literal: true
# hightop.rb

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  # Activate the gem you are reporting the issue against.
  gem "activerecord", "6.0.3"
  gem "sqlite3"
  gem "hightop", "0.2.2"
end

require "active_record"

# This connection will do for database-independent bug reports.
ActiveRecord::Base.establish_connection(adapter: "sqlite3", database: ":memory:")

ActiveRecord::Schema.define do
  create_table :posts, force: true do |t|
    t.timestamps null: false
    t.integer :visits
    t.string :visitor_token
  end
end

class Post < ActiveRecord::Base
end

(1..10).each { |visits| Post.create(visits: visits, visitor_token: SecureRandom.hex) }

Post.where('created_at > ?', 90.days.ago)
    .top(:visits, distinct: :visitor_token)

[24] pry(main)> Recognition.top(:sender_company_id, 10)
   (144.6ms)  SELECT  COUNT(*) AS count_all, sender_company_id AS sender_company_id FROM `recognitions`  WHERE `recognitions`.`deleted_at` IS NULL AND (sender_company_id IS NOT NULL) GROUP BY `recognitions`.`sender_company_id`  ORDER BY recognitions.created_at DESC, recognitions.id DESC, count_all DESC, sender_company_id LIMIT 10
=> {8132=>1, 4379=>2, 8126=>3, 1665=>1, 8122=>1, 7760=>11, 5305=>1, 8105=>3, 8104=>2, 6417=>1}

[25] pry(main)> Recognition.top(:sender_company_id, min: 1000)
   (148.7ms)  SELECT COUNT(*) AS count_all, sender_company_id AS sender_company_id FROM `recognitions`  WHERE `recognitions`.`deleted_at` IS NULL AND (sender_company_id IS NOT NULL) GROUP BY `recognitions`.`sender_company_id` HAVING COUNT(*) >= 1000  ORDER BY recognitions.created_at DESC, recognitions.id DESC, count_all DESC, sender_company_id
=> {3552=>3775,
 3744=>1952,
 5790=>4211,
 4415=>10285,
 3724=>1032,
 1591=>13545,
 3000=>2289,
 2967=>2385,
 2308=>1320,
 2146=>23427,
 1936=>1899,
 1512=>2494,
 323=>1506,
 1=>9577}