Class: Jobs::CorrectMissingDualstackUrls
- Defined in:
- app/jobs/onceoff/correct_missing_dualstack_urls.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 |
# File 'app/jobs/onceoff/correct_missing_dualstack_urls.rb', line 5 def execute_onceoff(args) # s3 now uses dualstack urls, keep them around correctly # in both uploads and optimized_image tables base_url = Discourse.store.absolute_base_url return if !base_url.match?(/s3\.dualstack/) old = base_url.sub("s3.dualstack.", "s3-") old_like = %"#{old}%" DB.exec(<<~SQL, from: old, to: base_url, old_like: old_like) UPDATE uploads SET url = replace(url, :from, :to) WHERE url ilike :old_like SQL DB.exec(<<~SQL, from: old, to: base_url, old_like: old_like) UPDATE optimized_images SET url = replace(url, :from, :to) WHERE url ilike :old_like SQL end |