Class: Jobs::FixPostsRead
- Defined in:
- app/jobs/onceoff/fix_posts_read.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 |
# 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 |