1 files changed, 33 insertions, 0 deletions
diff --git a/spec/lib/gitlab/usage/metrics/instrumentations/count_projects_metric_spec.rb b/spec/lib/gitlab/usage/metrics/instrumentations/count_projects_metric_spec.rb
new file mode 100644
index 00000000000..28185fb9df4
--- /dev/null
+++ b/spec/lib/gitlab/usage/metrics/instrumentations/count_projects_metric_spec.rb
@@ -0,0 +1,33 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+
+RSpec.describe Gitlab::Usage::Metrics::Instrumentations::CountProjectsMetric, feature_category: :service_ping do
+  before_all do
+    create :project, created_at: 2.months.ago
+    create :project, created_at: 21.days.ago
+    create :project, created_at: 7.days.ago
+  end
+
+  context "with all time frame" do
+    let(:expected_value) { 3 }
+    let(:expected_query) do
+      'SELECT COUNT("projects"."id") FROM "projects"'
+    end
+
+    it_behaves_like 'a correct instrumented metric value and query', { time_frame: 'all' }
+  end
+
+  context "with 28d time frame" do
+    let(:expected_value) { 2 }
+    let(:start) { 30.days.ago.to_fs(:db) }
+    let(:finish) { 2.days.ago.to_fs(:db) }
+    let(:expected_query) do
+      'SELECT COUNT("projects"."id") FROM "projects" ' \
+        'WHERE "projects"."created_at" ' \
+        "BETWEEN '#{start}' AND '#{finish}'"
+    end
+
+    it_behaves_like 'a correct instrumented metric value and query', { time_frame: '28d' }
+  end
+end