where_test.rb
7.07 KB
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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
require_relative "test_helper"
class WhereTest < Minitest::Test
def test_where
now = Time.now
store [
{name: "Product A", store_id: 1, in_stock: true, backordered: true, created_at: now, orders_count: 4, user_ids: [1, 2, 3]},
{name: "Product B", store_id: 2, in_stock: true, backordered: false, created_at: now - 1, orders_count: 3, user_ids: [1]},
{name: "Product C", store_id: 3, in_stock: false, backordered: true, created_at: now - 2, orders_count: 2, user_ids: [1, 3]},
{name: "Product D", store_id: 4, in_stock: false, backordered: false, created_at: now - 3, orders_count: 1}
]
assert_search "product", ["Product A", "Product B"], where: {in_stock: true}
# date
assert_search "product", ["Product A"], where: {created_at: {gt: now - 1}}
assert_search "product", ["Product A", "Product B"], where: {created_at: {gte: now - 1}}
assert_search "product", ["Product D"], where: {created_at: {lt: now - 2}}
assert_search "product", ["Product C", "Product D"], where: {created_at: {lte: now - 2}}
# integer
assert_search "product", ["Product A"], where: {store_id: {lt: 2}}
assert_search "product", ["Product A", "Product B"], where: {store_id: {lte: 2}}
assert_search "product", ["Product D"], where: {store_id: {gt: 3}}
assert_search "product", ["Product C", "Product D"], where: {store_id: {gte: 3}}
# range
assert_search "product", ["Product A", "Product B"], where: {store_id: 1..2}
assert_search "product", ["Product A"], where: {store_id: 1...2}
assert_search "product", ["Product A", "Product B"], where: {store_id: [1, 2]}
assert_search "product", ["Product B", "Product C", "Product D"], where: {store_id: {not: 1}}
assert_search "product", ["Product C", "Product D"], where: {store_id: {not: [1, 2]}}
assert_search "product", ["Product A"], where: {user_ids: {lte: 2, gte: 2}}
# or
assert_search "product", ["Product A", "Product B", "Product C"], where: {or: [[{in_stock: true}, {store_id: 3}]]}
assert_search "product", ["Product A", "Product B", "Product C"], where: {or: [[{orders_count: [2, 4]}, {store_id: [1, 2]}]]}
assert_search "product", ["Product A", "Product D"], where: {or: [[{orders_count: 1}, {created_at: {gte: now - 1}, backordered: true}]]}
# all
assert_search "product", ["Product A", "Product C"], where: {user_ids: {all: [1, 3]}}
assert_search "product", [], where: {user_ids: {all: [1, 2, 3, 4]}}
# any / nested terms
assert_search "product", ["Product B", "Product C"], where: {user_ids: {not: [2], in: [1, 3]}}
# not / exists
assert_search "product", ["Product D"], where: {user_ids: nil}
assert_search "product", ["Product A", "Product B", "Product C"], where: {user_ids: {not: nil}}
assert_search "product", ["Product A", "Product C", "Product D"], where: {user_ids: [3, nil]}
assert_search "product", ["Product B"], where: {user_ids: {not: [3, nil]}}
end
def test_regexp
store_names ["Product A"]
assert_search "*", ["Product A"], where: {name: /Pro.+/}
end
def test_alternate_regexp
store_names ["Product A", "Item B"]
assert_search "*", ["Product A"], where: {name: {regexp: "Pro.+"}}
end
def test_where_string
store [
{name: "Product A", color: "RED"}
]
assert_search "product", ["Product A"], where: {color: "RED"}
end
def test_where_nil
store [
{name: "Product A"},
{name: "Product B", color: "red"}
]
assert_search "product", ["Product A"], where: {color: nil}
end
def test_where_id
store_names ["Product A"]
product = Product.last
assert_search "product", ["Product A"], where: {id: product.id.to_s}
end
def test_where_empty
store_names ["Product A"]
assert_search "product", ["Product A"], where: {}
end
def test_where_empty_array
store_names ["Product A"]
assert_search "product", [], where: {store_id: []}
end
# http://elasticsearch-users.115913.n3.nabble.com/Numeric-range-quey-or-filter-in-an-array-field-possible-or-not-td4042967.html
# https://gist.github.com/jprante/7099463
def test_where_range_array
store [
{name: "Product A", user_ids: [11, 23, 13, 16, 17, 23]},
{name: "Product B", user_ids: [1, 2, 3, 4, 5, 6, 7, 8, 9]},
{name: "Product C", user_ids: [101, 230, 150, 200]}
]
assert_search "product", ["Product A"], where: {user_ids: {gt: 10, lt: 24}}
end
def test_where_range_array_again
store [
{name: "Product A", user_ids: [19, 32, 42]},
{name: "Product B", user_ids: [13, 40, 52]}
]
assert_search "product", ["Product A"], where: {user_ids: {gt: 26, lt: 36}}
end
def test_near
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {location: {near: [37.5, -122.5]}}
end
def test_near_hash
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {location: {near: {lat: 37.5, lon: -122.5}}}
end
def test_near_within
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000},
{name: "San Marino", latitude: 43.9333, longitude: 12.4667}
]
assert_search "san", ["San Francisco", "San Antonio"], where: {location: {near: [37, -122], within: "2000mi"}}
end
def test_near_within_hash
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000},
{name: "San Marino", latitude: 43.9333, longitude: 12.4667}
]
assert_search "san", ["San Francisco", "San Antonio"], where: {location: {near: {lat: 37, lon: -122}, within: "2000mi"}}
end
def test_top_left_bottom_right
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {location: {top_left: [38, -123], bottom_right: [37, -122]}}
end
def test_top_left_bottom_right_hash
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {location: {top_left: {lat: 38, lon: -123}, bottom_right: {lat: 37, lon: -122}}}
end
def test_multiple_locations
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {multiple_locations: {near: [37.5, -122.5]}}
end
def test_multiple_locations_hash
store [
{name: "San Francisco", latitude: 37.7833, longitude: -122.4167},
{name: "San Antonio", latitude: 29.4167, longitude: -98.5000}
]
assert_search "san", ["San Francisco"], where: {multiple_locations: {near: {lat: 37.5, lon: -122.5}}}
end
end