lib/gitlab/analytics/cycle_analytics/aggregated/stage_query_helpers.rb


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

# frozen_string_literal: true

module Gitlab
  module Analytics
    module CycleAnalytics
      module Aggregated
        module StageQueryHelpers
          def percentile_cont
            percentile_cont_ordering = Arel::Nodes::UnaryOperation.new(Arel::Nodes::SqlLiteral.new('ORDER BY'), duration)
            Arel::Nodes::NamedFunction.new(
              'percentile_cont(0.5) WITHIN GROUP',
              [percentile_cont_ordering]
            )
          end

          def duration
            if in_progress?
              Arel::Nodes::Subtraction.new(
                Arel::Nodes::NamedFunction.new('TO_TIMESTAMP', [Time.current.to_i]),
                query.model.arel_table[:start_event_timestamp]
              )
            else
              Arel::Nodes::Subtraction.new(
                query.model.arel_table[:end_event_timestamp],
                query.model.arel_table[:start_event_timestamp]
              )
            end
          end

          def median_duration_in_seconds
            Arel::Nodes::Extract.new(percentile_cont, :epoch)
          end

          def in_progress?
            params[:end_event_filter] == :in_progress
          end
        end
      end
    end
  end
end