paginable.rb 1.2 KB

1234567891011121314151617181920212223242526272829303132
  1. # frozen_string_literal: true
  2. module Paginable
  3. extend ActiveSupport::Concern
  4. included do
  5. scope :paginate_by_max_id, lambda { |limit, max_id = nil, since_id = nil|
  6. query = order(arel_table[:id].desc).limit(limit)
  7. query = query.where(arel_table[:id].lt(max_id)) if max_id.present?
  8. query = query.where(arel_table[:id].gt(since_id)) if since_id.present?
  9. query
  10. }
  11. # Differs from :paginate_by_max_id in that it gives the results immediately following min_id,
  12. # whereas since_id gives the items with largest id, but with since_id as a cutoff.
  13. # Results will be in ascending order by id.
  14. scope :paginate_by_min_id, lambda { |limit, min_id = nil, max_id = nil|
  15. query = reorder(arel_table[:id]).limit(limit)
  16. query = query.where(arel_table[:id].gt(min_id)) if min_id.present?
  17. query = query.where(arel_table[:id].lt(max_id)) if max_id.present?
  18. query
  19. }
  20. def self.to_a_paginated_by_id(limit, options = {})
  21. if options[:min_id].present?
  22. paginate_by_min_id(limit, options[:min_id], options[:max_id]).reverse
  23. else
  24. paginate_by_max_id(limit, options[:max_id], options[:since_id]).to_a
  25. end
  26. end
  27. end
  28. end