Contents

# frozen_string_literal: true

require "n1_loader/active_record"

require_relative 'context/setup_database'

class User < ActiveRecord::Base
  has_many :payments

  n1_optimized :payments_total do |users|
    total_per_user = Payment.group(:user_id).where(user: users).sum(:amount).tap { |h| h.default = 0 }

    users.each do |user|
      total = total_per_user[user.id]
      fulfill(user, total)
    end
  end
end

class Payment < ActiveRecord::Base
  belongs_to :user

  validates :amount, presence: true
end

fill_database

# Has N+1
p User.all.map { |user| user.payments.sum(&:amount) }
# Has no N+1 but we load too many data that we don't need
p User.all.includes(:payments).map { |user| user.payments.sum(&:amount) }
# Has no N+1 and calculation is the most efficient
p User.all.includes(:payments_total).map(&:payments_total)

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
n1_loader-1.7.2	examples/active_record_integration.rb
n1_loader-1.7.1	examples/active_record_integration.rb
n1_loader-1.7.0	examples/active_record_integration.rb
n1_loader-1.6.6	examples/active_record_integration.rb
n1_loader-1.6.5	examples/active_record_integration.rb
n1_loader-1.6.4	examples/active_record_integration.rb
n1_loader-1.6.3	examples/active_record_integration.rb
n1_loader-1.6.2	examples/active_record_integration.rb
n1_loader-1.6.1	examples/active_record_integration.rb
n1_loader-1.6.0	examples/active_record_integration.rb
n1_loader-1.5.1	examples/active_record_integration.rb
n1_loader-1.5.0	examples/active_record_integration.rb
n1_loader-1.4.4	examples/active_record_integration.rb