1 files changed, 36 insertions, 0 deletions
diff --git a/lib/gitlab/background_migration/disable_legacy_open_source_license_for_no_issues_no_repo_projects.rb b/lib/gitlab/background_migration/disable_legacy_open_source_license_for_no_issues_no_repo_projects.rb
new file mode 100644
index 00000000000..019c3d15b3e
--- /dev/null
+++ b/lib/gitlab/background_migration/disable_legacy_open_source_license_for_no_issues_no_repo_projects.rb
@@ -0,0 +1,36 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module BackgroundMigration
+    # Set `project_settings.legacy_open_source_license_available` to false for public projects with no issues & no repo
+    class DisableLegacyOpenSourceLicenseForNoIssuesNoRepoProjects < ::Gitlab::BackgroundMigration::BatchedMigrationJob
+      PUBLIC = 20
+
+      # Migration only version of `project_settings` table
+      class ProjectSetting < ApplicationRecord
+        self.table_name = 'project_settings'
+      end
+
+      def perform
+        each_sub_batch(
+          operation_name: :disable_legacy_open_source_license_for_no_issues_no_repo_projects,
+          batching_scope: ->(relation) { relation.where(visibility_level: PUBLIC) }
+        ) do |sub_batch|
+          no_issues_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 issues ON issues.project_id = projects.id')
+              .where('project_statistics.repository_size' => 0,
+                     'project_settings.legacy_open_source_license_available' => true)
+              .group('projects.id')
+              .having('COUNT(issues.id) = 0')
+
+          ProjectSetting
+            .where(project_id: no_issues_no_repo_projects)
+            .update_all(legacy_open_source_license_available: false)
+        end
+      end
+    end
+  end
+end