File: subquery.rb

package info (click to toggle)
gitlab 17.6.5-19
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 629,368 kB
  • sloc: ruby: 1,915,304; javascript: 557,307; sql: 60,639; xml: 6,509; sh: 4,567; makefile: 1,239; python: 406
file content (24 lines) | stat: -rw-r--r-- 736 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# frozen_string_literal: true

# Distinguish between a top level query and a subselect.
#
# Retrieve column values when the relation has already been loaded, otherwise reselect the relation.
# Useful for preload query patterns where the typical Rails #preload does not fit. Such as:
#
# projects = Project.where(...)
# projects.load
# ...
# options[members] = ProjectMember.where(...).where(source_id: projects.select(:id))
module Subquery
  extend ActiveSupport::Concern

  class_methods do
    def subquery(*column_names, max_limit: 5_000)
      if current_scope.loaded? && current_scope.size <= max_limit
        current_scope.pluck(*column_names)
      else
        current_scope.reselect(*column_names)
      end
    end
  end
end