Class: Jobs::FixPostSearchDataAfterDefaultLocaleRename

Inherits:
Onceoff
  • Object
show all
Defined in:
app/jobs/onceoff/fix_post_search_data_after_default_locale_rename.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
 
# File 'app/jobs/onceoff/fix_post_search_data_after_default_locale_rename.rb', line 5

def execute_onceoff(args)
  return if SearchIndexer::POST_INDEX_VERSION != 4

  sql = <<~SQL
    UPDATE post_search_data
       SET locale = 'en'
     WHERE post_id IN (
            SELECT post_id
              FROM post_search_data
             WHERE locale = 'en_US'
             LIMIT 100000
         )
  SQL

  loop { break if DB.exec(sql) == 0 }
end