db/migrate/20230327123333_backfill_product_analytics_data_collector_host.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

# frozen_string_literal: true

class BackfillProductAnalyticsDataCollectorHost < Gitlab::Database::Migration[2.1]
  restrict_gitlab_migration gitlab_schema: :gitlab_main

  def up
    # fills product_analytics_data_collector_host by replacing jitsu_host subdomain with collector
    regex = "'://(.+?\\.)'"
    replace_with = "'://collector.'"
    execute <<~SQL
      UPDATE application_settings
      SET product_analytics_data_collector_host = regexp_replace(jitsu_host, #{regex}, #{replace_with}, 'g')
      WHERE jitsu_host IS NOT NULL AND product_analytics_data_collector_host IS NULL
    SQL
  end

  def down
    #   noop
  end
end