Class: Jobs::FixPrimaryEmailsForStagedUsers

Inherits:
Onceoff
  • Object
show all
Defined in:
app/jobs/onceoff/fix_primary_emails_for_staged_users.rb

Instance Method Summary collapse

Methods inherited from Onceoff

enqueue_all, #execute, inherited, name_for, onceoff_job_klasses, #running_key_name

Methods inherited from Base

acquire_cluster_concurrency_lock!, clear_cluster_concurrency_lock!, cluster_concurrency, cluster_concurrency_redis_key, delayed_perform, #error_context, #execute, get_cluster_concurrency, #last_db_duration, #log, #perform, #perform_immediately

Instance Method Details

#execute_onceoff(args) ⇒ Object 



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
 
# File 'app/jobs/onceoff/fix_primary_emails_for_staged_users.rb', line 5

def execute_onceoff(args)
  users = User.where(active: false, staged: true).joins(:email_tokens)
  acting_user = Discourse.system_user
  destroyer = UserDestroyer.new(acting_user)

  users
    .group("email_tokens.email")
    .having("COUNT(email_tokens.email) > 1")
    .count
    .each_key do |email|
      query = users.where("email_tokens.email = ?", email).order(id: :asc)

      original_user = query.first

      query
        .offset(1)
        .each do |user|
          user.posts.each { |post| post.set_owner(original_user, acting_user) }
          destroyer.destroy(user, context: I18n.t("user.destroy_reasons.fixed_primary_email"))
        end
    end

  DB.exec <<~SQL
  INSERT INTO user_emails (
    user_id,
    email,
    "primary",
    created_at,
    updated_at
  ) SELECT DISTINCT
    users.id,
    email_tokens.email,
    TRUE,
    users.created_at,
    users.updated_at
  FROM users
  LEFT JOIN user_emails ON user_emails.user_id = users.id
  LEFT JOIN email_tokens ON email_tokens.user_id = users.id
  WHERE staged
  AND NOT active
  AND user_emails.id IS NULL
  SQL
end