Module: Arel::Predications

Instance Method Summary collapse

Instance Method Details

#between(other) ⇒ Object



27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
# File 'lib/arel/predications.rb', line 27

def between other
  if other.begin == -Float::INFINITY
    if other.end == Float::INFINITY
      not_in([])
    elsif other.exclude_end?
      lt(other.end)
    else
      lteq(other.end)
    end
  elsif other.end == Float::INFINITY
    gteq(other.begin)
  elsif other.exclude_end?
    gteq(other.begin).and(lt(other.end))
  else
    left = quoted_node(other.begin)
    right = quoted_node(other.end)
    Nodes::Between.new(self, left.and(right))
  end
end

#does_not_match(other, escape = nil) ⇒ Object



133
134
135
# File 'lib/arel/predications.rb', line 133

def does_not_match other, escape = nil
  Nodes::DoesNotMatch.new self, quoted_node(other), escape
end

#does_not_match_all(others, escape = nil) ⇒ Object



141
142
143
# File 'lib/arel/predications.rb', line 141

def does_not_match_all others, escape = nil
  grouping_all :does_not_match, others, escape
end

#does_not_match_any(others, escape = nil) ⇒ Object



137
138
139
# File 'lib/arel/predications.rb', line 137

def does_not_match_any others, escape = nil
  grouping_any :does_not_match, others, escape
end

#eq(other) ⇒ Object



15
16
17
# File 'lib/arel/predications.rb', line 15

def eq other
  Nodes::Equality.new self, quoted_node(other)
end

#eq_all(others) ⇒ Object



23
24
25
# File 'lib/arel/predications.rb', line 23

def eq_all others
  grouping_all :eq, quoted_array(others)
end

#eq_any(others) ⇒ Object



19
20
21
# File 'lib/arel/predications.rb', line 19

def eq_any others
  grouping_any :eq, others
end

#gt(right) ⇒ Object



157
158
159
# File 'lib/arel/predications.rb', line 157

def gt right
  Nodes::GreaterThan.new self, quoted_node(right)
end

#gt_all(others) ⇒ Object



165
166
167
# File 'lib/arel/predications.rb', line 165

def gt_all others
  grouping_all :gt, others
end

#gt_any(others) ⇒ Object



161
162
163
# File 'lib/arel/predications.rb', line 161

def gt_any others
  grouping_any :gt, others
end

#gteq(right) ⇒ Object



145
146
147
# File 'lib/arel/predications.rb', line 145

def gteq right
  Nodes::GreaterThanOrEqual.new self, quoted_node(right)
end

#gteq_all(others) ⇒ Object



153
154
155
# File 'lib/arel/predications.rb', line 153

def gteq_all others
  grouping_all :gteq, others
end

#gteq_any(others) ⇒ Object



149
150
151
# File 'lib/arel/predications.rb', line 149

def gteq_any others
  grouping_any :gteq, others
end

#in(other) ⇒ Object



47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
# File 'lib/arel/predications.rb', line 47

def in other
  case other
  when Arel::SelectManager
    Arel::Nodes::In.new(self, other.ast)
  when Range
    if $VERBOSE
      warn "Passing a range to `#in` is deprecated. Call `#between`, instead.\n"
    end
    between(other)
  when Enumerable
    Nodes::In.new self, quoted_array(other)
  else
    Nodes::In.new self, quoted_node(other)
  end
end

#in_all(others) ⇒ Object



69
70
71
# File 'lib/arel/predications.rb', line 69

def in_all others
  grouping_all :in, others
end

#in_any(others) ⇒ Object



65
66
67
# File 'lib/arel/predications.rb', line 65

def in_any others
  grouping_any :in, others
end

#lt(right) ⇒ Object



169
170
171
# File 'lib/arel/predications.rb', line 169

def lt right
  Nodes::LessThan.new self, quoted_node(right)
end

#lt_all(others) ⇒ Object



177
178
179
# File 'lib/arel/predications.rb', line 177

def lt_all others
  grouping_all :lt, others
end

#lt_any(others) ⇒ Object



173
174
175
# File 'lib/arel/predications.rb', line 173

def lt_any others
  grouping_any :lt, others
end

#lteq(right) ⇒ Object



181
182
183
# File 'lib/arel/predications.rb', line 181

def lteq right
  Nodes::LessThanOrEqual.new self, quoted_node(right)
end

#lteq_all(others) ⇒ Object



189
190
191
# File 'lib/arel/predications.rb', line 189

def lteq_all others
  grouping_all :lteq, others
end

#lteq_any(others) ⇒ Object



185
186
187
# File 'lib/arel/predications.rb', line 185

def lteq_any others
  grouping_any :lteq, others
end

#matches(other, escape = nil) ⇒ Object



121
122
123
# File 'lib/arel/predications.rb', line 121

def matches other, escape = nil
  Nodes::Matches.new self, quoted_node(other), escape
end

#matches_all(others, escape = nil) ⇒ Object



129
130
131
# File 'lib/arel/predications.rb', line 129

def matches_all others, escape = nil
  grouping_all :matches, others, escape
end

#matches_any(others, escape = nil) ⇒ Object



125
126
127
# File 'lib/arel/predications.rb', line 125

def matches_any others, escape = nil
  grouping_any :matches, others, escape
end

#not_between(other) ⇒ Object



73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
# File 'lib/arel/predications.rb', line 73

def not_between other
  if other.begin == -Float::INFINITY # The range begins with negative infinity
    if other.end == Float::INFINITY
      self.in([])
    elsif other.exclude_end?
      gteq(other.end)
    else
      gt(other.end)
    end
  elsif other.end == Float::INFINITY
    lt(other.begin)
  else
    left = lt(other.begin)
    right = if other.exclude_end?
      gteq(other.end)
    else
      gt(other.end)
    end
    left.or(right)
  end
end

#not_eq(other) ⇒ Object



3
4
5
# File 'lib/arel/predications.rb', line 3

def not_eq other
  Nodes::NotEqual.new self, quoted_node(other)
end

#not_eq_all(others) ⇒ Object



11
12
13
# File 'lib/arel/predications.rb', line 11

def not_eq_all others
  grouping_all :not_eq, others
end

#not_eq_any(others) ⇒ Object



7
8
9
# File 'lib/arel/predications.rb', line 7

def not_eq_any others
  grouping_any :not_eq, others
end

#not_in(other) ⇒ Object



95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
# File 'lib/arel/predications.rb', line 95

def not_in other
  case other
  when Arel::SelectManager
    Arel::Nodes::NotIn.new(self, other.ast)
  when Range
    if $VERBOSE
      warn "Passing a range to `#not_in` is deprecated. Call `#not_between`, instead.\n"
    end
    not_between(other)
  when Enumerable
    Nodes::NotIn.new self, quoted_array(other)
  else
    Nodes::NotIn.new self, quoted_node(other)
  end
end

#not_in_all(others) ⇒ Object



117
118
119
# File 'lib/arel/predications.rb', line 117

def not_in_all others
  grouping_all :not_in, others
end

#not_in_any(others) ⇒ Object



113
114
115
# File 'lib/arel/predications.rb', line 113

def not_in_any others
  grouping_any :not_in, others
end