summaryrefslogtreecommitdiff
path: root/lib/gitlab/cycle_analytics/query_config.rb
blob: bd8ddf8a638dabf2c4c270c753f75c98dffaa668 (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
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],
                        user_table[:name].as('author_name'),
                        user_table[:username].as('author_username'),
                        user_table[:id].as('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],
                        user_table[:name].as('author_name'),
                        user_table[:username].as('author_username'),
                        user_table[:id].as('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: mr_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[:created_at],
                        user_table[:name],
                        user_table[:email]]
        }
      end

      def staging
        { start_time_attrs: mr_metrics_table[:merged_at],
          end_time_attrs: mr_metrics_table[:first_deployed_to_production_at],
          projections: [mr_metrics_table[:ci_commit_id]]
        }
      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[:created_at],
                        user_table[:name],
                        user_table[:email]]
        }
      end
    end
  end
end