Class: Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForOneMemberNoRepoProjects
- Inherits:
-
BatchedMigrationJob
- Object
- BatchedMigrationJob
- Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForOneMemberNoRepoProjects
- Defined in:
- lib/gitlab/background_migration/disable_legacy_open_source_license_for_one_member_no_repo_projects.rb
Overview
Set ‘project_settings.legacy_open_source_license_available` to false for public projects with 1 member and no repo
Defined Under Namespace
Classes: ProjectSetting
Constant Summary collapse
- PUBLIC =
20
Constants inherited from BatchedMigrationJob
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
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
# File 'lib/gitlab/background_migration/disable_legacy_open_source_license_for_one_member_no_repo_projects.rb', line 17 def perform each_sub_batch( batching_scope: ->(relation) { relation.where(visibility_level: PUBLIC) } ) do |sub_batch| one_member_no_repo_projects = sub_batch .joins('LEFT OUTER JOIN project_statistics ON project_statistics.project_id = projects.id') .joins('LEFT OUTER JOIN project_settings ON project_settings.project_id = projects.id') .joins('LEFT OUTER JOIN project_authorizations ON project_authorizations.project_id = projects.id') .where( 'project_statistics.repository_size' => 0, 'project_settings.legacy_open_source_license_available' => true) .group('projects.id') .having('COUNT(project_authorizations.user_id) = 1') ProjectSetting .where(project_id: one_member_no_repo_projects) .update_all(legacy_open_source_license_available: false) end end |