summaryrefslogtreecommitdiff
path: root/lib/gitlab/grafana_embed_usage_data.rb
diff options
context:
space:
mode:
Diffstat (limited to 'lib/gitlab/grafana_embed_usage_data.rb')
-rw-r--r--lib/gitlab/grafana_embed_usage_data.rb16
1 files changed, 16 insertions, 0 deletions
diff --git a/lib/gitlab/grafana_embed_usage_data.rb b/lib/gitlab/grafana_embed_usage_data.rb
new file mode 100644
index 00000000000..78a87623e1f
--- /dev/null
+++ b/lib/gitlab/grafana_embed_usage_data.rb
@@ -0,0 +1,16 @@
+# frozen_string_literal: true
+
+module Gitlab
+ class GrafanaEmbedUsageData
+ class << self
+ def issue_count
+ # rubocop:disable CodeReuse/ActiveRecord
+ Issue.joins('JOIN grafana_integrations USING (project_id)')
+ .where("issues.description LIKE '%' || grafana_integrations.grafana_url || '%'")
+ .where(grafana_integrations: { enabled: true })
+ .count
+ # rubocop:enable CodeReuse/ActiveRecord
+ end
+ end
+ end
+end