/
migrate_drop_check_constraint_spec.rb
72 lines (64 loc) · 2.05 KB
/
migrate_drop_check_constraint_spec.rb
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
# frozen_string_literal: true
describe 'Ridgepole::Client#diff -> migrate', condition: [['>= 6.1', :mysql80]] do
context 'when drop check constraint' do
let(:actual_dsl) do
erbh(<<-ERB)
create_table "salaries", id: false, force: :cascade do |t|
t.integer "emp_no", null: false
t.integer "salary", null: false
t.date "from_date", null: false
t.date "to_date", null: false
t.check_constraint "`salary` > 100", name: "salary_check"
end
ERB
end
let(:expected_dsl) do
erbh(<<-ERB)
create_table "salaries", id: false, force: :cascade do |t|
t.integer "emp_no", null: false
t.integer "salary", null: false
t.date "from_date", null: false
t.date "to_date", null: false
end
ERB
end
before { subject.diff(actual_dsl).migrate }
subject { client }
it {
delta = subject.diff(expected_dsl)
expect(delta.differ?).to be_truthy
expect(subject.dump).to match_ruby actual_dsl
delta.migrate
expect(subject.dump).to match_ruby expected_dsl
}
end
context 'when drop check constraint (merge: true)' do
let(:actual_dsl) do
erbh(<<-ERB)
create_table "salaries", id: false, force: :cascade do |t|
t.integer "emp_no", null: false
t.integer "salary", null: false
t.date "from_date", null: false
t.date "to_date", null: false
t.check_constraint "`salary` > 100", name: "salary_check"
end
ERB
end
let(:expected_dsl) do
erbh(<<-ERB)
create_table "salaries", id: false, force: :cascade do |t|
t.integer "emp_no", null: false
t.integer "salary", null: false
t.date "from_date", null: false
t.date "to_date", null: false
end
ERB
end
before { subject.diff(actual_dsl).migrate }
subject { client(merge: true) }
it {
delta = subject.diff(expected_dsl)
expect(delta.differ?).to be_falsy
}
end
end