# frozen_string_literal: true

require 'benchmark/ips'

project = Project.find(1)

Benchmark.ips do |bench|
  bench.report('Redmine 5.1.0') do
    project.reload
    users =
      project.members.preload(:principal).select do |m|
        m.principal.present? &&
         (m.mail_notification? || m.principal.mail_notification == 'all')
      end
    users.collect {|m| m.principal}
  end

  # The last version before `preload(:principal)` was added in r15518
  bench.report('Redmine 3.2.6') do
    project.reload
    project.members.select {|m| m.principal.present? && (m.mail_notification? || m.principal.mail_notification == 'all')}.collect {|m| m.principal}
  end

#  bench.report('has_many_through') do
#    project.reload
#    project.users.where('members.mail_notification = ? OR users.mail_notification = ?', true, 'all').to_a
#  end

  bench.report('#23328#note-8') do
    project.reload
    subquery =
      project.members.select(:user_id)
      .where.associated(:principal)
      .where('members.mail_notification = ? OR users.mail_notification = ?', true, 'all')
    User.where(id: subquery).to_a
  end

  bench.report('#23328#note-2') do
    project.reload
    project.members.eager_load(:principal).find_each()
      .select {|m| m.principal.present? && (m.mail_notification? || m.principal.mail_notification == 'all')}
      .collect {|m| m.principal}
  end

  bench.compare!
end