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
|
# frozen_string_literal: true
module SshKeys
class ExpiredNotificationWorker
include ApplicationWorker
data_consistency :always
include CronjobQueue
feature_category :compliance_management
idempotent!
BATCH_SIZE = 500
# rubocop: disable CodeReuse/ActiveRecord
def perform
order = Gitlab::Pagination::Keyset::Order.build(
[
Gitlab::Pagination::Keyset::ColumnOrderDefinition.new(
attribute_name: 'expires_at_utc',
order_expression: Arel.sql("date(expires_at AT TIME ZONE 'UTC')").asc,
nullable: :not_nullable,
add_to_projections: true
),
Gitlab::Pagination::Keyset::ColumnOrderDefinition.new(
attribute_name: 'id',
order_expression: Key.arel_table[:id].asc
)
])
scope = Key.expired_today_and_not_notified.order(order)
iterator = Gitlab::Pagination::Keyset::Iterator.new(scope: scope, use_union_optimization: true)
iterator.each_batch(of: BATCH_SIZE) do |relation|
users = User.where(id: relation.map(&:user_id)) # Keyset pagination will load the rows
users.each do |user|
with_context(user: user) do
Keys::ExpiryNotificationService.new(user, { keys: user.expired_today_and_unnotified_keys, expiring_soon: false }).execute
end
end
end
end
# rubocop: enable CodeReuse/ActiveRecord
end
end
|
