Add latest changes from gitlab-org/gitlab@13-9-stable-eev13.9.0-rc42

1 files changed, 22 insertions, 0 deletions

diff --git a/lib/gitlab/background_migration/backfill_project_updated_at_after_repository_storage_move.rb b/lib/gitlab/background_migration/backfill_project_updated_at_after_repository_storage_move.rb
new file mode 100644
index 00000000000..61eb3b332de
--- /dev/null
+++ b/lib/gitlab/background_migration/backfill_project_updated_at_after_repository_storage_move.rb
@@ -0,0 +1,22 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module BackgroundMigration
+    # Update existent project update_at column after their repository storage was moved
+    class BackfillProjectUpdatedAtAfterRepositoryStorageMove
+      def perform(*project_ids)
+        updated_repository_storages = ProjectRepositoryStorageMove.select("project_id, MAX(updated_at) as updated_at").where(project_id: project_ids).group(:project_id)
+
+        Project.connection.execute <<-SQL
+          WITH repository_storage_cte as (
+            #{updated_repository_storages.to_sql}
+          )
+          UPDATE projects
+          SET updated_at = (repository_storage_cte.updated_at + interval '1 second')
+          FROM repository_storage_cte
+          WHERE projects.id = repository_storage_cte.project_id AND projects.updated_at <= repository_storage_cte.updated_at
+        SQL
+      end
+    end
+  end
+end