doc-rails-smart-segment

lib-forest_liana-collections-product.rb

# /lib/forest_liana/collections/product.rb
class Forest::Product
  include ForestLiana::Collection

  collection :Product

  segment 'Bestsellers' do
    products = ActiveRecord::Base.connection.execute("""
      SELECT products.id, COUNT(orders.*)
      FROM products
      JOIN orders ON orders.product_id = products.id
      GROUP BY products.id
      ORDER BY count DESC
      LIMIT 10;
    """).to_a

    { id: products.map { |p| p['id'] } }
  end
end