Contents

# 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)
      vars[:count] ||= pagy_arel_count(collection)
      pagy(collection, **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).pick(sql).to_i
      end
    end
  end
  Backend.prepend ArelExtra
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
pagy-9.3.3	lib/pagy/extras/arel.rb
pagy-9.3.2	lib/pagy/extras/arel.rb
pagy-9.3.1	lib/pagy/extras/arel.rb
pagy-9.3.0	lib/pagy/extras/arel.rb
pagy-9.2.2	lib/pagy/extras/arel.rb
pagy-9.2.1	lib/pagy/extras/arel.rb
pagy-9.2.0	lib/pagy/extras/arel.rb
pagy-9.1.1	lib/pagy/extras/arel.rb
pagy-9.1.0	lib/pagy/extras/arel.rb
pagy-9.0.9	lib/pagy/extras/arel.rb
pagy-9.0.8	lib/pagy/extras/arel.rb
pagy-9.0.7	lib/pagy/extras/arel.rb
pagy-9.0.6	lib/pagy/extras/arel.rb