aboutsummaryrefslogtreecommitdiffstats
path: root/lib/arel/engines/sql/predicates.rb
blob: 93d2a2f619599074d2f48a169a4af185572c52aa (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
96
97
98
99
100
101
102
103
module Arel
  module Predicates
    class Binary < Predicate
      def to_sql(formatter = nil)
        "#{operand1.to_sql} #{predicate_sql} #{operand1.format(operand2)}"
      end
    end

    class Unary < Predicate
      def to_sql(formatter = nil)
        "#{predicate_sql} (#{operand.to_sql(formatter)})"
      end
    end

    class Not < Unary
      def predicate_sql; "NOT" 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 Polyadic < Predicate
      def to_sql(formatter = nil)
        "(" +
          predicates.map {|p| p.to_sql(formatter)}.join(" #{predicate_sql} ") +
        ")"
      end
    end

    class Any < Polyadic
      def predicate_sql; "OR" end
    end

    class All < Polyadic
      def predicate_sql; "AND" end
    end

    class Equality < Binary
      def predicate_sql
        operand2.equality_predicate_sql
      end
    end

    class Inequality < Binary
      def predicate_sql
        operand2.inequality_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(formatter = nil)
        if operand2.is_a?(Range) && operand2.exclude_end?
          GreaterThanOrEqualTo.new(operand1, operand2.begin).and(
            LessThan.new(operand1, operand2.end)
          ).to_sql(formatter)
        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