summaryrefslogtreecommitdiff
path: root/db/post_migrate/20200217225719_schedule_migrate_security_scans.rb
blob: 7ef204ed9de40c80d5703dad222a1904507247d8 (plain)
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 ScheduleMigrateSecurityScans < ActiveRecord::Migration[5.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false
  INTERVAL = 2.minutes.to_i
  BATCH_SIZE = 10_000
  MIGRATION = 'MigrateSecurityScans'.freeze

  disable_ddl_transaction!

  class JobArtifact < ActiveRecord::Base
    include ::EachBatch

    self.table_name = 'ci_job_artifacts'

    scope :security_reports, -> { where('file_type BETWEEN 5 and 8') }
  end

  def up
    queue_background_migration_jobs_by_range_at_intervals(JobArtifact.security_reports,
                                                          MIGRATION,
                                                          INTERVAL,
                                                          batch_size: BATCH_SIZE)
  end

  def down
    # intentionally blank
  end
end