Class: Jobs::InitCategoryTagStats
- Defined in:
- app/jobs/onceoff/init_category_tag_stats.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 |
# File 'app/jobs/onceoff/init_category_tag_stats.rb', line 5 def execute_onceoff(args) DB.exec "DELETE FROM category_tag_stats" DB.exec <<~SQL INSERT INTO category_tag_stats (category_id, tag_id, topic_count) SELECT topics.category_id, tags.id, COUNT(topics.id) FROM tags INNER JOIN topic_tags ON tags.id = topic_tags.tag_id INNER JOIN topics ON topics.id = topic_tags.topic_id AND topics.deleted_at IS NULL AND topics.category_id IS NOT NULL GROUP BY tags.id, topics.category_id SQL end |