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
|
# frozen_string_literal: true
require "cases/helper"
require "models/author"
require "models/categorization"
require "models/post"
module ActiveRecord
class OrTest < ActiveRecord::TestCase
fixtures :posts
fixtures :authors, :author_addresses
def test_or_with_relation
expected = Post.where("id = 1 or id = 2").to_a
assert_equal expected, Post.where("id = 1").or(Post.where("id = 2")).to_a
end
def test_or_identity
expected = Post.where("id = 1").to_a
assert_equal expected, Post.where("id = 1").or(Post.where("id = 1")).to_a
end
def test_or_with_null_left
expected = Post.where("id = 1").to_a
assert_equal expected, Post.none.or(Post.where("id = 1")).to_a
end
def test_or_with_null_right
expected = Post.where("id = 1").to_a
assert_equal expected, Post.where("id = 1").or(Post.none).to_a
end
def test_or_with_large_number
expected = Post.where("id = 1 or id = 9223372036854775808").to_a
assert_equal expected, Post.where(id: 1).or(Post.where(id: 9223372036854775808)).to_a
end
def test_or_with_bind_params
assert_equal Post.find([1, 2]).sort_by(&:id), Post.where(id: 1).or(Post.where(id: 2)).sort_by(&:id)
end
def test_or_with_null_both
expected = Post.none.to_a
assert_equal expected, Post.none.or(Post.none).to_a
end
def test_or_without_left_where
expected = Post.all
assert_equal expected, Post.or(Post.where("id = 1")).to_a
end
def test_or_without_right_where
expected = Post.all
assert_equal expected, Post.where("id = 1").or(Post.all).to_a
end
def test_or_preserves_other_querying_methods
expected = Post.where("id = 1 or id = 2 or id = 3").order("body asc").to_a
partial = Post.order("body asc")
assert_equal expected, partial.where("id = 1").or(partial.where(id: [2, 3])).to_a
assert_equal expected, Post.order("body asc").where("id = 1").or(Post.order("body asc").where(id: [2, 3])).to_a
end
def test_or_with_incompatible_relations
error = assert_raises ArgumentError do
Post.order("body asc").where("id = 1").or(Post.order("id desc").where(id: [2, 3])).to_a
end
assert_equal "Relation passed to #or must be structurally compatible. Incompatible values: [:order]", error.message
end
def test_or_with_unscope_where
expected = Post.where("id = 1 or id = 2")
partial = Post.where("id = 1 and id != 2")
assert_equal expected, partial.or(partial.unscope(:where).where("id = 2")).to_a
end
def test_or_with_unscope_where_column
expected = Post.where("id = 1 or id = 2")
partial = Post.where(id: 1).where.not(id: 2)
assert_equal expected, partial.or(partial.unscope(where: :id).where("id = 2")).to_a
end
def test_or_with_unscope_order
expected = Post.where("id = 1 or id = 2")
assert_equal expected, Post.order("body asc").where("id = 1").unscope(:order).or(Post.where("id = 2")).to_a
end
def test_or_with_incompatible_unscope
error = assert_raises ArgumentError do
Post.order("body asc").where("id = 1").or(Post.order("body asc").where("id = 2").unscope(:order)).to_a
end
assert_equal "Relation passed to #or must be structurally compatible. Incompatible values: [:order]", error.message
end
def test_or_when_grouping
groups = Post.where("id < 10").group("body").select("body, COUNT(*) AS c")
expected = groups.having("COUNT(*) > 1 OR body like 'Such%'").to_a.map { |o| [o.body, o.c] }
assert_equal expected, groups.having("COUNT(*) > 1").or(groups.having("body like 'Such%'")).to_a.map { |o| [o.body, o.c] }
end
def test_or_with_named_scope
expected = Post.where("id = 1 or body LIKE '\%a\%'").to_a
assert_equal expected, Post.where("id = 1").or(Post.containing_the_letter_a)
end
def test_or_inside_named_scope
expected = Post.where("body LIKE '\%a\%' OR title LIKE ?", "%'%").order("id DESC").to_a
assert_equal expected, Post.order(id: :desc).typographically_interesting
end
def test_or_on_loaded_relation
expected = Post.where("id = 1 or id = 2").to_a
p = Post.where("id = 1")
p.load
assert_equal true, p.loaded?
assert_equal expected, p.or(Post.where("id = 2")).to_a
end
def test_or_with_non_relation_object_raises_error
assert_raises ArgumentError do
Post.where(id: [1, 2, 3]).or(title: "Rails")
end
end
def test_or_with_references_inequality
joined = Post.includes(:author)
actual = joined.where(authors: { id: 1 })
.or(joined.where(title: "I don't have any comments"))
expected = Author.find(1).posts + Post.where(title: "I don't have any comments")
assert_equal expected.sort_by(&:id), actual.sort_by(&:id)
end
def test_or_with_scope_on_association
author = Author.first
assert_nothing_raised do
author.top_posts.or(author.other_top_posts)
end
end
end
end
|
