Class: Gitlab::BackgroundMigration::BackfillPartitionedTable

Inherits:
BatchedMigrationJob show all
Defined in:
lib/gitlab/background_migration/backfill_partitioned_table.rb

Overview

Background migration to generically copy data from the given table into its corresponding partitioned table

Constant Summary

Constants inherited from BatchedMigrationJob

Gitlab::BackgroundMigration::BatchedMigrationJob::DEFAULT_FEATURE_CATEGORY

Constants included from Database::DynamicModelHelpers

Database::DynamicModelHelpers::BATCH_SIZE

Instance Method Summary collapse

Methods inherited from BatchedMigrationJob

#batch_metrics, feature_category, #filter_batch, generic_instance, #initialize, job_arguments, job_arguments_count, operation_name, scope_to

Methods included from Database::DynamicModelHelpers

#define_batchable_model, #each_batch, #each_batch_range

Constructor Details

This class inherits a constructor from Gitlab::BackgroundMigration::BatchedMigrationJob

Instance Method Details

#perform ⇒ Object 



11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/gitlab/background_migration/backfill_partitioned_table.rb', line 11

def perform
  validate_paritition_table!

  bulk_copy = Gitlab::Database::PartitioningMigrationHelpers::BulkCopy.new(
    batch_table,
    partitioned_table,
    batch_column,
    connection: connection
  )

  each_sub_batch do |relation|
    sub_start_id, sub_stop_id = relation.pick(Arel.sql("MIN(#{batch_column}), MAX(#{batch_column})"))
    bulk_copy.copy_between(sub_start_id, sub_stop_id)
  end
end