Class: Gitlab::BackgroundMigration::FixUserProjectRouteNames

Inherits:
Object
  • Object
show all
Defined in:
lib/gitlab/background_migration/fix_user_project_route_names.rb

Overview

This migration fixes the routes.name for all user-projects that have names that don't start with the users name. For more info see gitlab.com/gitlab-org/gitlab-foss/merge_requests/23272

Instance Method Summary collapse

Instance Method Details

#perform(from_id, to_id) ⇒ Object 


9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/gitlab/background_migration/fix_user_project_route_names.rb', line 9

def perform(from_id, to_id)
  ActiveRecord::Base.connection.execute <<~ROUTES_UPDATE
    WITH routes_to_update AS (
      SELECT
          routes.id,
          users.name || ' / ' || projects.name AS correct_name
      FROM
          routes
          INNER JOIN projects ON routes.source_id = projects.id
          INNER JOIN namespaces ON projects.namespace_id = namespaces.id
          INNER JOIN users ON namespaces.owner_id = users.id
      WHERE
          routes.source_type = 'Project'
          AND routes.id BETWEEN #{from_id} AND #{to_id}
          AND namespaces.type IS NULL
          AND (routes.name NOT LIKE users.name || '%' OR routes.name IS NULL)
    )
    UPDATE
        routes
    SET
        name = routes_to_update.correct_name
    FROM
        routes_to_update
    WHERE
        routes_to_update.id = routes.id
  ROUTES_UPDATE
end