blob: 3772430d0b7f3eb1e8ad68b0ade12862814ae516 (
plain)
1
2
3
4
5
6
7
8
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
# frozen_string_literal: true
module Gitlab
module BackgroundMigration
# Fix project name duplicates and backfill missing project namespace ids
class FixDuplicateProjectNameAndPath
SUB_BATCH_SIZE = 10
# isolated project active record
class Project < ActiveRecord::Base
include ::EachBatch
self.table_name = 'projects'
scope :without_project_namespace, -> { where(project_namespace_id: nil) }
scope :id_in, ->(ids) { where(id: ids) }
end
def perform(start_id, end_id)
@project_ids = fetch_project_ids(start_id, end_id)
backfill_project_namespaces_service = init_backfill_service(project_ids)
backfill_project_namespaces_service.cleanup_gin_index('projects')
project_ids.each_slice(SUB_BATCH_SIZE) do |ids|
ApplicationRecord.connection.execute(update_projects_name_and_path_sql(ids))
end
backfill_project_namespaces_service.backfill_project_namespaces
mark_job_as_succeeded(start_id, end_id)
end
private
attr_accessor :project_ids
def fetch_project_ids(start_id, end_id)
Project.without_project_namespace.where(id: start_id..end_id)
end
def init_backfill_service(project_ids)
service = Gitlab::BackgroundMigration::ProjectNamespaces::BackfillProjectNamespaces.new
service.project_ids = project_ids
service.sub_batch_size = SUB_BATCH_SIZE
service
end
def update_projects_name_and_path_sql(project_ids)
<<~SQL
WITH cte (project_id, path_from_route ) AS (
#{path_from_route_sql(project_ids).to_sql}
)
UPDATE
projects
SET
name = concat(projects.name, '-', id),
path = CASE
WHEN projects.path <> cte.path_from_route THEN path_from_route
ELSE projects.path
END
FROM
cte
WHERE
projects.id = cte.project_id;
SQL
end
def path_from_route_sql(project_ids)
Project.without_project_namespace.id_in(project_ids)
.joins("INNER JOIN routes ON routes.source_id = projects.id AND routes.source_type = 'Project'")
.select("projects.id, SUBSTRING(routes.path FROM '[^/]+(?=/$|$)') AS path_from_route")
end
def mark_job_as_succeeded(*arguments)
::Gitlab::Database::BackgroundMigrationJob.mark_all_as_succeeded(
'FixDuplicateProjectNameAndPath',
arguments
)
end
end
end
end
|
