1 files changed, 16 insertions, 0 deletions
diff --git a/lib/gitlab/background_migration/delete_orphans_approval_project_rules.rb b/lib/gitlab/background_migration/delete_orphans_approval_project_rules.rb
new file mode 100644
index 00000000000..33aa1a8d29d
--- /dev/null
+++ b/lib/gitlab/background_migration/delete_orphans_approval_project_rules.rb
@@ -0,0 +1,16 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module BackgroundMigration
+    # Deletes orphans records whenever report_type equals to scan_finding (i.e., 4)
+    class DeleteOrphansApprovalProjectRules < BatchedMigrationJob
+      operation_name :delete_all
+
+      def perform
+        each_sub_batch do |sub_batch|
+          sub_batch.where(report_type: 4, security_orchestration_policy_configuration_id: nil).delete_all
+        end
+      end
+    end
+  end
+end