39 lines
1.2 KiB
Ruby
39 lines
1.2 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
class RemoveSprintsProjectIdColumn < Gitlab::Database::Migration[2.0]
|
|
disable_ddl_transaction!
|
|
|
|
DATERANGE_CONSTRAINT_NAME = 'iteration_start_and_due_daterange_project_id_constraint'
|
|
|
|
def up
|
|
with_lock_retries do
|
|
remove_column :sprints, :project_id, :bigint if column_exists?(:sprints, :project_id)
|
|
end
|
|
end
|
|
|
|
def down
|
|
with_lock_retries do
|
|
add_column :sprints, :project_id, :bigint unless column_exists?(:sprints, :project_id)
|
|
end
|
|
|
|
with_lock_retries do
|
|
next if check_constraint_exists?(:sprints, DATERANGE_CONSTRAINT_NAME)
|
|
|
|
execute(<<~SQL)
|
|
ALTER TABLE sprints
|
|
ADD CONSTRAINT #{DATERANGE_CONSTRAINT_NAME}
|
|
EXCLUDE USING gist (project_id WITH =, daterange(start_date, due_date, '[]'::text) WITH &&)
|
|
WHERE (project_id IS NOT NULL)
|
|
SQL
|
|
end
|
|
|
|
add_check_constraint(:sprints,
|
|
'project_id <> NULL::bigint AND group_id IS NULL OR group_id <> NULL::bigint AND project_id IS NULL',
|
|
'sprints_must_belong_to_project_or_group')
|
|
|
|
add_concurrent_index :sprints, [:project_id, :iid], unique: true, name: 'index_sprints_on_project_id_and_iid'
|
|
|
|
add_concurrent_foreign_key :sprints, :projects, column: :project_id, on_delete: :cascade
|
|
end
|
|
end
|