Sha256: 845faf155bcbb2ead031e76bcbfda5a1266687c7881230efc39a1be2607a0355

Contents?: true

Size: 1.12 KB

Versions: 15

Compression:

Stored size: 1.12 KB

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 = {})
      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

Version data entries

15 entries across 15 versions & 1 rubygems

Version Path
pagy-8.6.3 lib/pagy/extras/arel.rb
pagy-8.6.2 lib/pagy/extras/arel.rb
pagy-8.6.1 lib/pagy/extras/arel.rb
pagy-8.6.0 lib/pagy/extras/arel.rb
pagy-8.5.0 lib/pagy/extras/arel.rb
pagy-8.4.5 lib/pagy/extras/arel.rb
pagy-8.4.4 lib/pagy/extras/arel.rb
pagy-8.4.3 lib/pagy/extras/arel.rb
pagy-8.4.2 lib/pagy/extras/arel.rb
pagy-8.4.1 lib/pagy/extras/arel.rb
pagy-8.4.0 lib/pagy/extras/arel.rb
pagy-8.3.0 lib/pagy/extras/arel.rb
pagy-8.2.2 lib/pagy/extras/arel.rb
pagy-8.2.1 lib/pagy/extras/arel.rb
pagy-8.2.0 lib/pagy/extras/arel.rb