1 files changed, 27 insertions, 0 deletions
diff --git a/lib/gitlab/background_migration/backfill_namespace_details.rb b/lib/gitlab/background_migration/backfill_namespace_details.rb
new file mode 100644
index 00000000000..b8a51b576b6
--- /dev/null
+++ b/lib/gitlab/background_migration/backfill_namespace_details.rb
@@ -0,0 +1,27 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module BackgroundMigration
+    # Backfill namespace_details for a range of namespaces
+    class BackfillNamespaceDetails < ::Gitlab::BackgroundMigration::BatchedMigrationJob
+      def perform
+        each_sub_batch(operation_name: :backfill_namespace_details) do |sub_batch|
+          upsert_namespace_details(sub_batch)
+        end
+      end
+
+      def upsert_namespace_details(relation)
+        connection.execute(
+          <<~SQL
+          INSERT INTO namespace_details (description, description_html, cached_markdown_version, created_at, updated_at, namespace_id)
+            SELECT namespaces.description, namespaces.description_html, namespaces.cached_markdown_version, now(), now(), namespaces.id
+            FROM namespaces
+            WHERE namespaces.id IN(#{relation.select(:id).to_sql})
+            AND namespaces.type <> 'Project'
+          ON CONFLICT (namespace_id) DO NOTHING;
+        SQL
+        )
+      end
+    end
+  end
+end