/
have_db_index_matcher.rb
111 lines (90 loc) · 2.68 KB
/
have_db_index_matcher.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
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
module Shoulda # :nodoc:
module Matchers
module ActiveRecord # :nodoc:
# Ensures that there are DB indices on the given columns or tuples of
# columns.
#
# Options:
# * <tt>unique</tt> - whether or not the index has a unique
# constraint. Use <tt>true</tt> to explicitly test for a unique
# constraint. Use <tt>false</tt> to explicitly test for a non-unique
# constraint.
#
# Examples:
#
# it { should have_db_index(:age) }
# it { should have_db_index([:commentable_type, :commentable_id]) }
# it { should have_db_index(:ssn).unique(true) }
#
def have_db_index(columns)
HaveDbIndexMatcher.new(columns)
end
class HaveDbIndexMatcher # :nodoc:
def initialize(columns)
@columns = normalize_columns_to_array(columns)
@options = {}
end
def unique(unique)
@options[:unique] = unique
self
end
def matches?(subject)
@subject = subject
index_exists? && correct_unique?
end
def failure_message_for_should
"Expected #{expectation} (#{@missing})"
end
def failure_message_for_should_not
"Did not expect #{expectation}"
end
def description
if @options.key?(:unique)
"have a #{index_type} index on columns #{@columns.join(' and ')}"
else
"have an index on columns #{@columns.join(' and ')}"
end
end
protected
def index_exists?
! matched_index.nil?
end
def correct_unique?
return true unless @options.key?(:unique)
is_unique = matched_index.unique
is_unique = !is_unique unless @options[:unique]
unless is_unique
@missing = "#{table_name} has an index named #{matched_index.name} " <<
"of unique #{matched_index.unique}, not #{@options[:unique]}."
end
is_unique
end
def matched_index
indexes.detect { |each| each.columns == @columns }
end
def model_class
@subject.class
end
def table_name
model_class.table_name
end
def indexes
::ActiveRecord::Base.connection.indexes(table_name)
end
def expectation
"#{model_class.name} to #{description}"
end
def index_type
if @options[:unique]
'unique'
else
'non-unique'
end
end
def normalize_columns_to_array(columns)
Array.wrap(columns).map(&:to_s)
end
end
end
end
end