blob: 7fac09e750317e18fe18d785893f4414a7f030eb (
plain) (
blame)
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
|
module Arel
module Predicates
class Binary < Predicate
def to_sql(formatter = nil)
"#{operand1.to_sql} #{predicate_sql} #{operand1.format(operand2)}"
end
end
class CompoundPredicate < Binary
def to_sql(formatter = nil)
"(#{operand1.to_sql(formatter)} #{predicate_sql} #{operand2.to_sql(formatter)})"
end
end
class Or < CompoundPredicate
def predicate_sql; "OR" end
end
class And < CompoundPredicate
def predicate_sql; "AND" end
end
class GroupedPredicate < Grouped
def to_sql(formatter = nil)
"(" +
operands2.inject([]) { |predicates, operand|
predicates << operator.new(operand1, operand).to_sql
}.join(" #{predicate_sql} ") +
")"
end
end
class Any < GroupedPredicate
def predicate_sql; "OR" end
end
class All < GroupedPredicate
def predicate_sql; "AND" end
end
class Equality < Binary
def predicate_sql
operand2.equality_predicate_sql
end
end
class Not < Binary
def predicate_sql
operand2.not_predicate_sql
end
end
class GreaterThanOrEqualTo < Binary
def predicate_sql; '>=' end
end
class GreaterThan < Binary
def predicate_sql; '>' end
end
class LessThanOrEqualTo < Binary
def predicate_sql; '<=' end
end
class LessThan < Binary
def predicate_sql; '<' end
end
class Match < Binary
def predicate_sql; 'LIKE' end
end
class NotMatch < Binary
def predicate_sql; 'NOT LIKE' end
end
class In < Binary
def to_sql
if operand2.is_a?(Range) && operand2.exclude_end?
GreaterThanOrEqualTo.new(operand1, operand2.begin).and(
LessThan.new(operand1, operand2.end)
).to_sql
else
super
end
end
def predicate_sql; operand2.inclusion_predicate_sql end
end
class NotIn < Binary
def predicate_sql; operand2.exclusion_predicate_sql end
end
end
end
|