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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
# frozen_string_literal: true
require 'spec_helper'
require_migration!
RSpec.describe AddTicketWorkItemType, :migration, feature_category: :service_desk do
include MigrationHelpers::WorkItemTypesHelper
let(:work_item_types) { table(:work_item_types) }
let(:work_item_widget_definitions) { table(:work_item_widget_definitions) }
let(:work_item_hierarchy_restrictions) { table(:work_item_hierarchy_restrictions) }
let(:base_types) do
{
issue: 0,
incident: 1,
test_case: 2,
requirement: 3,
task: 4,
objective: 5,
key_result: 6,
epic: 7,
ticket: 8
}
end
after(:all) do
# Make sure base types are recreated after running the migration
# because migration specs are not run in a transaction
reset_work_item_types
end
before do
reset_db_state_prior_to_migration
end
it 'adds the ticket type, widget definitions and hierarchy restrictions', :aggregate_failures do
expect do
migrate!
end.to change { work_item_types.count }.by(1)
.and(change { work_item_widget_definitions.count }.by(13))
.and(change { work_item_hierarchy_restrictions.count }.by(2))
ticket_type = work_item_types.last
issue_type = work_item_types.find_by!(namespace_id: nil, base_type: base_types[:issue])
expect(work_item_types.pluck(:base_type)).to include(base_types[:ticket])
expect(
work_item_widget_definitions.where(work_item_type_id: ticket_type.id).pluck(:widget_type)
).to match_array(described_class::TICKET_WIDGETS.values)
expect(
work_item_hierarchy_restrictions.where(parent_type_id: ticket_type.id).pluck(:child_type_id, :maximum_depth)
).to contain_exactly([ticket_type.id, 1], [issue_type.id, 1])
end
it "skips creating the new type and it's definitions when it already exists" do
work_item_types.find_or_create_by!(
name: 'Ticket', namespace_id: nil, base_type: base_types[:ticket], icon_name: 'issue-type-issue'
)
expect do
migrate!
end.to not_change(work_item_types, :count)
.and(not_change(work_item_widget_definitions, :count))
.and(not_change(work_item_hierarchy_restrictions, :count))
end
it "skips creating the new type and it's definitions when type creation fails" do
allow(described_class::MigrationWorkItemType).to receive(:create)
.and_return(described_class::MigrationWorkItemType.new)
expect do
migrate!
end.to not_change(work_item_types, :count)
.and(not_change(work_item_widget_definitions, :count))
.and(not_change(work_item_hierarchy_restrictions, :count))
end
def reset_db_state_prior_to_migration
# Database needs to be in a similar state as when this migration was created
work_item_types.delete_all
{
issue: { name: 'Issue', icon_name: 'issue-type-issue' },
incident: { name: 'Incident', icon_name: 'issue-type-incident' },
test_case: { name: 'Test Case', icon_name: 'issue-type-test-case' },
requirement: { name: 'Requirement', icon_name: 'issue-type-requirements' },
task: { name: 'Task', icon_name: 'issue-type-task' },
objective: { name: 'Objective', icon_name: 'issue-type-objective' },
key_result: { name: 'Key Result', icon_name: 'issue-type-keyresult' },
epic: { name: 'Epic', icon_name: 'issue-type-epic' }
}.each do |type, opts|
work_item_types.find_or_create_by!(
name: opts[:name], namespace_id: nil, base_type: base_types[type], icon_name: opts[:icon_name]
)
end
end
end
|