summaryrefslogtreecommitdiff
path: root/lib/gitlab/cycle_analytics/query_config.rb
blob: d077a3e1a1410a463133ca3d106d2011da99509c (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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
module Gitlab
  module CycleAnalytics
    class QueryConfig
      include MetricsFetcher

      def self.get(*args)
        new(*args).get
      end

      def initialize(stage)
        @stage = stage
      end

      def get
        public_send(@stage).freeze if self.respond_to?(@stage)
      end

      def issue
        {
          start_time_attrs: issue_table[:created_at],
          end_time_attrs: [issue_metrics_table[:first_associated_with_milestone_at],
                           issue_metrics_table[:first_added_to_board_at]],
          projections: [issue_table[:title],
                        issue_table[:iid],
                        issue_table[:id],
                        issue_table[:created_at],
                        issue_table[:author_id]]
        }
      end

      def plan
        {
          start_time_attrs: issue_metrics_table[:first_associated_with_milestone_at],
          end_time_attrs: [issue_metrics_table[:first_added_to_board_at],
                           issue_metrics_table[:first_mentioned_in_commit_at]],
          projections: [mr_diff_table[:st_commits].as('commits')]
        }
      end

      def code
        {
          start_time_attrs: issue_metrics_table[:first_mentioned_in_commit_at],
          end_time_attrs: mr_table[:created_at],
          projections: [mr_table[:title],
                        mr_table[:iid],
                        mr_table[:id],
                        mr_table[:created_at],
                        mr_table[:state],
                        mr_table[:author_id]],
          order: mr_table[:created_at]
        }
      end

      def test
        {
          start_time_attrs: mr_metrics_table[:latest_build_started_at],
          end_time_attrs: mr_metrics_table[:latest_build_finished_at],
          projections: [build_table[:id]],
          order: build_table[:created_at]
        }
      end

      def review
        {
          start_time_attrs: mr_table[:created_at],
          end_time_attrs: mr_metrics_table[:merged_at],
          projections: [mr_table[:title],
                        mr_table[:iid],
                        mr_table[:id],
                        mr_table[:created_at].as('opened_at'),
                        mr_table[:state],
                        mr_table[:author_id]]
        }
      end

      def staging
        {
          start_time_attrs: mr_metrics_table[:merged_at],
          end_time_attrs: mr_metrics_table[:first_deployed_to_production_at],
          projections: [build_table[:id]],
          order: build_table[:created_at]
        }
      end

      def production
        {
          start_time_attrs: issue_table[:created_at],
          end_time_attrs: mr_metrics_table[:first_deployed_to_production_at],
          projections: [issue_table[:title],
                        issue_table[:iid],
                        issue_table[:id],
                        issue_table[:created_at],
                        issue_table[:author_id]]
        }
      end
    end
  end
end