blob: 8a0ce61de74dc424960b9138fc56143265c73b89 (
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
|
# frozen_string_literal: true
require 'spec_helper'
RSpec.describe Gitlab::Usage::Metrics::Instrumentations::UniqueActiveUsersMetric do
let_it_be(:user1) { create(:user, last_activity_on: 1.day.ago) }
let_it_be(:user2) { create(:user, last_activity_on: 5.days.ago) }
let_it_be(:user3) { create(:user, last_activity_on: 50.days.ago) }
let_it_be(:user4) { create(:user) }
let_it_be(:user5) { create(:user, user_type: 1, last_activity_on: 5.days.ago ) } # support bot
let_it_be(:user6) { create(:user, state: 'blocked') }
context '28d' do
let(:start) { 30.days.ago.to_date.to_s }
let(:finish) { 2.days.ago.to_date.to_s }
let(:expected_value) { 1 }
let(:expected_query) do
"SELECT COUNT(\"users\".\"id\") FROM \"users\" WHERE (\"users\".\"state\" IN ('active')) AND " \
"(\"users\".\"user_type\" IS NULL OR \"users\".\"user_type\" IN (6, 4)) AND \"users\".\"last_activity_on\" " \
"BETWEEN '#{start}' AND '#{finish}'"
end
it_behaves_like 'a correct instrumented metric value and query', { time_frame: '28d' }
end
context 'all' do
let(:expected_value) { 4 }
it_behaves_like 'a correct instrumented metric value', { time_frame: 'all' }
end
end
|