-
Notifications
You must be signed in to change notification settings - Fork 394
/
arel.rb
36 lines (32 loc) 路 1.12 KB
/
arel.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# See the Pagy documentation: https://ddnexus.github.io/pagy/docs/extras/arel
# frozen_string_literal: true
class Pagy # :nodoc:
# Better performance of grouped ActiveRecord collections
module ArelExtra
private
# Return Pagy object and paginated collection/results
def pagy_arel(collection, vars = {})
pagy = Pagy.new(pagy_arel_get_vars(collection, vars))
[pagy, pagy_get_items(collection, pagy)]
end
# Sub-method called only by #pagy_arel: here for easy customization of variables by overriding
def pagy_arel_get_vars(collection, vars)
pagy_set_items_from_params(vars) if defined?(ItemsExtra)
vars[:count] ||= pagy_arel_count(collection)
vars[:page] ||= pagy_get_page(vars)
vars
end
# Count using Arel when grouping
def pagy_arel_count(collection)
if collection.group_values.empty?
# COUNT(*)
collection.count(:all)
else
# COUNT(*) OVER ()
sql = Arel.star.count.over(Arel::Nodes::Grouping.new([]))
collection.unscope(:order).limit(1).pluck(sql).first.to_i
end
end
end
Backend.prepend ArelExtra
end