summaryrefslogtreecommitdiff
path: root/lib/gitlab/analytics/cycle_analytics/base_query_builder.rb
blob: 9ea20a4d6a4406a4de6bffa9edd54db042d2b416 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
# frozen_string_literal: true

module Gitlab
  module Analytics
    module CycleAnalytics
      class BaseQueryBuilder
        include Gitlab::CycleAnalytics::MetricsTables

        delegate :subject_class, to: :stage

        # rubocop: disable CodeReuse/ActiveRecord

        def initialize(stage:, params: {})
          @stage = stage
          @params = params
        end

        def build
          query = subject_class
          query = filter_by_parent_model(query)
          query = filter_by_time_range(query)
          query = stage.start_event.apply_query_customization(query)
          query = stage.end_event.apply_query_customization(query)
          query.where(duration_condition)
        end

        private

        attr_reader :stage, :params

        def duration_condition
          stage.end_event.timestamp_projection.gteq(stage.start_event.timestamp_projection)
        end

        def filter_by_parent_model(query)
          if parent_class.eql?(Project)
            if subject_class.eql?(Issue)
              query.where(project_id: stage.parent_id)
            elsif subject_class.eql?(MergeRequest)
              query.where(target_project_id: stage.parent_id)
            else
              raise ArgumentError, "unknown subject_class: #{subject_class}"
            end
          else
            raise ArgumentError, "unknown parent_class: #{parent_class}"
          end
        end

        def filter_by_time_range(query)
          from = params.fetch(:from, 30.days.ago)
          to = params[:to]

          query = query.where(subject_table[:created_at].gteq(from))
          query = query.where(subject_table[:created_at].lteq(to)) if to
          query
        end

        def subject_table
          subject_class.arel_table
        end

        def parent_class
          stage.parent.class
        end

        # rubocop: enable CodeReuse/ActiveRecord
      end
    end
  end
end

Gitlab::Analytics::CycleAnalytics::BaseQueryBuilder.prepend_if_ee('EE::Gitlab::Analytics::CycleAnalytics::BaseQueryBuilder')