Add latest changes from gitlab-org/gitlab@16-0-stable-eev16.0.0-rc42

1 files changed, 27 insertions, 0 deletions

diff --git a/db/post_migrate/20230508175057_backfill_corrected_secure_files_expirations.rb b/db/post_migrate/20230508175057_backfill_corrected_secure_files_expirations.rb
new file mode 100644
index 00000000000..9644a555756
--- /dev/null
+++ b/db/post_migrate/20230508175057_backfill_corrected_secure_files_expirations.rb
@@ -0,0 +1,27 @@
+# frozen_string_literal: true
+
+class BackfillCorrectedSecureFilesExpirations < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+  restrict_gitlab_migration gitlab_schema: :gitlab_ci
+
+  BATCH_SIZE = 1000
+
+  def up
+    each_batch_range('ci_secure_files', of: BATCH_SIZE) do |min, max|
+      sql = <<-SQL
+        SELECT id
+        FROM ci_secure_files
+        WHERE name ILIKE any (array['%.cer', '%.p12'])
+        AND ci_secure_files.id BETWEEN #{min} AND #{max}
+      SQL
+
+      rows = execute(sql)
+
+      rows.each do |row|
+        ::Ci::ParseSecureFileMetadataWorker.perform_async(row["id"])
+      end
+    end
+  end
+
+  def down; end
+end