Class: Jobs::FixPostsRead

Inherits:
Onceoff show all
Defined in:
app/jobs/onceoff/fix_posts_read.rb

Instance Method Summary collapse

Methods inherited from Onceoff

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

def execute_onceoff(args)
  # Skipping to the last post in a topic used to count all posts in the topic
  # as read in user stats. Cap the posts read count to 50 * topics_entered.

  sql = <<~SQL
UPDATE user_stats
   SET posts_read_count = topics_entered * 50
 WHERE user_id IN (
   SELECT us2.user_id
 FROM user_stats us2
WHERE us2.topics_entered > 0
  AND us2.posts_read_count / us2.topics_entered > 50
 )
  SQL

  DB.exec(sql)
end