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
|
# frozen_string_literal: true
class UpdateApiIndexesForProjects < Gitlab::Database::Migration[1.0]
disable_ddl_transaction!
ARCHIVED_INDEX_NAME = 'idx_projects_api_created_at_id_for_archived'
OLD_ARCHIVED_INDEX_NAME = 'index_projects_api_created_at_id_for_archived'
PUBLIC_AND_ARCHIVED_INDEX_NAME = 'idx_projects_api_created_at_id_for_archived_vis20'
OLD_PUBLIC_AND_ARCHIVED_INDEX_NAME = 'index_projects_api_created_at_id_for_archived_vis20'
INTERNAL_PROJECTS_INDEX_NAME = 'idx_projects_api_created_at_id_for_vis10'
OLD_INTERNAL_PROJECTS_INDEX_NAME = 'index_projects_api_created_at_id_for_vis10'
def up
add_concurrent_index :projects, [:created_at, :id],
where: "archived = true AND pending_delete = false AND hidden = false",
name: ARCHIVED_INDEX_NAME
add_concurrent_index :projects, [:created_at, :id],
where: "archived = true AND visibility_level = 20 AND pending_delete = false AND hidden = false",
name: PUBLIC_AND_ARCHIVED_INDEX_NAME
add_concurrent_index :projects, [:created_at, :id],
where: "visibility_level = 10 AND pending_delete = false AND hidden = false",
name: INTERNAL_PROJECTS_INDEX_NAME
remove_concurrent_index_by_name :projects, OLD_ARCHIVED_INDEX_NAME
remove_concurrent_index_by_name :projects, OLD_PUBLIC_AND_ARCHIVED_INDEX_NAME
remove_concurrent_index_by_name :projects, OLD_INTERNAL_PROJECTS_INDEX_NAME
end
def down
add_concurrent_index :projects, [:created_at, :id],
where: "archived = true AND pending_delete = false",
name: OLD_ARCHIVED_INDEX_NAME
add_concurrent_index :projects, [:created_at, :id],
where: "archived = true AND visibility_level = 20 AND pending_delete = false",
name: OLD_PUBLIC_AND_ARCHIVED_INDEX_NAME
add_concurrent_index :projects, [:created_at, :id],
where: "visibility_level = 10 AND pending_delete = false",
name: OLD_INTERNAL_PROJECTS_INDEX_NAME
remove_concurrent_index_by_name :projects, ARCHIVED_INDEX_NAME
remove_concurrent_index_by_name :projects, PUBLIC_AND_ARCHIVED_INDEX_NAME
remove_concurrent_index_by_name :projects, INTERNAL_PROJECTS_INDEX_NAME
end
end
|