summaryrefslogtreecommitdiff
path: root/lib/gitlab/analytics/cycle_analytics/stage_events/code_stage_start.rb
blob: 8e87245e62b7bbd51abe07ccc58ead519a998e31 (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
# frozen_string_literal: true

module Gitlab
  module Analytics
    module CycleAnalytics
      module StageEvents
        class CodeStageStart < StageEvent
          def self.name
            s_("CycleAnalyticsEvent|Issue first mentioned in a commit")
          end

          def self.identifier
            :code_stage_start
          end

          def object_type
            MergeRequest
          end

          def column_list
            [
              issue_metrics_table[:first_mentioned_in_commit_at],
              mr_metrics_table[:first_commit_at]
            ]
          end

          # rubocop: disable CodeReuse/ActiveRecord
          def apply_query_customization(query)
            query
              .joins(merge_requests_closing_issues_join)
              .joins(issue_metrics_join)
              .joins(mr_metrics_join)
          end
          # rubocop: enable CodeReuse/ActiveRecord

          def issue_metrics_join
            mr_closing_issues_table
              .join(issue_metrics_table, Arel::Nodes::OuterJoin)
              .on(mr_closing_issues_table[:issue_id].eq(issue_metrics_table[:issue_id]))
              .join_sources
          end

          def merge_requests_closing_issues_join
            mr_table
              .join(mr_closing_issues_table, Arel::Nodes::OuterJoin)
              .on(mr_table[:id].eq(mr_closing_issues_table[:merge_request_id]))
              .join_sources
          end

          def mr_metrics_join
            mr_metrics_table
              .join(mr_metrics_table, Arel::Nodes::OuterJoin)
              .on(mr_metrics_table[:merge_request_id].eq(mr_table[:id]))
              .join_sources
          end
        end
      end
    end
  end
end