Class: Jobs::CorrectMissingDualstackUrls

Inherits:
Onceoff
  • Object
show all
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