summaryrefslogtreecommitdiff
path: root/lib/gitlab/usage_data_queries.rb
blob: 0d15475eebbe99ded7a7dcf77388ae5f4055a364 (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
# frozen_string_literal: true

module Gitlab
  # This class is used by the `gitlab:usage_data:dump_sql` rake tasks to output SQL instead of running it.
  # See https://gitlab.com/gitlab-org/gitlab/-/merge_requests/41091
  class UsageDataQueries < UsageData
    class << self
      def with_metadata
        yield
      end

      def add_metric(metric, time_frame: 'none', options: {})
        metric_class = "Gitlab::Usage::Metrics::Instrumentations::#{metric}".constantize

        metric_class.new(time_frame: time_frame, options: options).instrumentation
      end

      def count(relation, column = nil, *args, **kwargs)
        Gitlab::Usage::Metrics::Query.for(:count, relation, column)
      end

      def distinct_count(relation, column = nil, *args, **kwargs)
        Gitlab::Usage::Metrics::Query.for(:distinct_count, relation, column)
      end

      def sum(relation, column, *args, **kwargs)
        Gitlab::Usage::Metrics::Query.for(:sum, relation, column)
      end

      # rubocop: disable CodeReuse/ActiveRecord
      def histogram(relation, column, buckets:, bucket_size: buckets.size)
        Gitlab::Usage::Metrics::Query.for(:histogram, relation, column, buckets: buckets, bucket_size: bucket_size)
      end
      # rubocop: enable CodeReuse/ActiveRecord

      # For estimated distinct count use exact query instead of hll
      # buckets query, because it can't be used to obtain estimations without
      # supplementary ruby code present in Gitlab::Database::PostgresHll::BatchDistinctCounter
      def estimate_batch_distinct_count(relation, column = nil, *args, **kwargs)
        Gitlab::Usage::Metrics::Query.for(:estimate_batch_distinct_count, relation, column)
      end

      def add(*args)
        'SELECT ' + args.map { |arg| "(#{arg})" }.join(' + ')
      end

      def maximum_id(model, column = nil)
        # no-op: shadowing super for performance reasons
      end

      def minimum_id(model, column = nil)
        # no-op: shadowing super for performance reasons
      end

      def alt_usage_data(value = nil, fallback: FALLBACK, &block)
        if block
          { alt_usage_data_block: "non-SQL usage data block" }
        else
          { alt_usage_data_value: value }
        end
      end

      def redis_usage_data(counter = nil, &block)
        if block
          { redis_usage_data_block: "non-SQL usage data block" }
        elsif counter.present?
          { redis_usage_data_counter: counter.to_s }
        end
      end

      def jira_integration_data
        {
          projects_jira_server_active: 0,
          projects_jira_cloud_active: 0
        }
      end

      def topology_usage_data
        {
          duration_s: 0,
          failures: []
        }
      end

      # rubocop: disable CodeReuse/ActiveRecord
      def sent_in_product_marketing_email_count(sent_emails, track, series)
        count(Users::InProductMarketingEmail.where(track: track, series: series))
      end

      def clicked_in_product_marketing_email_count(clicked_emails, track, series)
        count(Users::InProductMarketingEmail.where(track: track, series: series).where.not(cta_clicked_at: nil))
      end
      # rubocop: enable CodeReuse/ActiveRecord
    end
  end
end