db/post_migrate/20190724091326_schedule_productivity_analytics_backfill.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

# frozen_string_literal: true

class ScheduleProductivityAnalyticsBackfill < ActiveRecord::Migration[5.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  BATCH_SIZE = 10_000
  INTERVAL = 3.minutes
  MIGRATION = 'Gitlab::BackgroundMigration::RecalculateProductivityAnalytics'.freeze

  disable_ddl_transaction!

  def up
    return unless Gitlab.ee?

    metrics_model = Class.new(ActiveRecord::Base) do
      self.table_name = 'merge_request_metrics'

      include ::EachBatch
    end

    scope = metrics_model.where("merged_at >= ?", 3.months.ago)

    queue_background_migration_jobs_by_range_at_intervals(scope, MIGRATION, INTERVAL, batch_size: BATCH_SIZE)
  end

  def down
    # no-op
  end
end