Class: Gitlab::BackgroundMigration::CreateMissingNugetSymbolFiles

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

Defined Under Namespace

Modules: Packages

Constant Summary collapse

NUGET_PACKAGE_TYPE =
4
INSTALLABLE_STATUSES =
[0, 1].freeze

Constants inherited from BatchedMigrationJob

BatchedMigrationJob::DEFAULT_FEATURE_CATEGORY, BatchedMigrationJob::MINIMUM_PAUSE_MS

Constants included from Database::DynamicModelHelpers

Database::DynamicModelHelpers::BATCH_SIZE

Instance Method Summary collapse

Methods inherited from BatchedMigrationJob

#batch_metrics, cursor, cursor?, cursor_columns, feature_category, #filter_batch, generic_instance, health_context_tables, #initialize, job_arguments, job_arguments_count, operation_name, scope_to, tables_to_check_for_vacuum

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

#performObject



26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# File 'lib/gitlab/background_migration/create_missing_nuget_symbol_files.rb', line 26

def perform
  each_sub_batch do |sub_batch|
    subquery = Packages::Nuget::Symbol
                 .select(1)
                 .where('packages_nuget_symbols.package_id = packages_packages.id')

    sub_batch
      .joins('INNER JOIN packages_package_files ON packages_package_files.package_id = packages_packages.id')
      .where(status: INSTALLABLE_STATUSES)
      .select('packages_package_files.id')
      .where('NOT EXISTS (?)', subquery)
      .find_each.with_index do |entry, index|
      ::Packages::Nuget::CreateSymbolsWorker.perform_in((1 * index).seconds, entry.id)
    end
  end
end