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
|
module Arel
module Visitors
class ToSql
def initialize engine
@engine = engine
@connection = nil
end
def accept object
@connection = @engine.connection
visit object
end
private
def visit_Arel_Nodes_DeleteStatement o
[
"DELETE FROM #{visit o.relation}",
("WHERE #{o.wheres.map { |x| visit x }.join ' AND '}" unless o.wheres.empty?)
].compact.join ' '
end
def visit_Arel_Nodes_UpdateStatement o
[
"UPDATE #{visit o.relation}",
("SET #{o.values.map { |value| visit value }.join ', '}" unless o.values.empty?),
("WHERE #{o.wheres.map { |x| visit x }.join ' AND '}" unless o.wheres.empty?)
].compact.join ' '
end
def visit_Arel_Nodes_InsertStatement o
[
"INSERT INTO #{visit o.relation}",
("(#{o.columns.map { |x|
quote_column_name x.name
}.join ', '})" unless o.columns.empty?),
("VALUES (#{o.values.map { |value|
value ? quote(visit(value)) : 'NULL'
}.join ', '})" unless o.values.empty?),
].compact.join ' '
end
def visit_Arel_Nodes_SelectStatement o
[
o.cores.map { |x| visit x }.join,
("LIMIT #{o.limit}" if o.limit)
].compact.join ' '
end
def visit_Arel_Nodes_SelectCore o
[
"SELECT #{o.projections.map { |x| visit x }.join ', '}",
("FROM #{o.froms.map { |x| visit x }.join ', ' }" unless o.froms.empty?),
("WHERE #{o.wheres.map { |x| visit x }.join ' AND ' }" unless o.wheres.empty?)
].compact.join ' '
end
def visit_Arel_Table o
quote_table_name o.name
end
def visit_Arel_Nodes_In o
"#{visit o.left} IN (#{o.right.map { |x| quote visit x }.join ', '})"
end
def visit_Arel_Nodes_Or o
"#{visit o.left} OR #{visit o.right}"
end
def visit_Arel_Nodes_Equality o
right = o.right
right = right ? quote(visit(right)) : 'NULL'
"#{visit o.left} = #{right}"
end
def visit_Arel_Nodes_UnqualifiedColumn o
"#{quote_column_name o.name}"
end
def visit_Arel_Attributes_Attribute o
"#{quote_table_name o.relation.name}.#{quote_column_name o.name}"
end
alias :visit_Arel_Attributes_Integer :visit_Arel_Attributes_Attribute
alias :visit_Arel_Attributes_String :visit_Arel_Attributes_Attribute
alias :visit_Arel_Attributes_Time :visit_Arel_Attributes_Attribute
def visit_Fixnum o; o end
alias :visit_Time :visit_Fixnum
alias :visit_String :visit_Fixnum
alias :visit_TrueClass :visit_Fixnum
alias :visit_Arel_Nodes_SqlLiteral :visit_Fixnum
alias :visit_Arel_SqlLiteral :visit_Fixnum # This is deprecated
DISPATCH = {}
def visit object
send "visit_#{object.class.name.gsub('::', '_')}", object
#send DISPATCH[object.class], object
end
private_instance_methods(false).each do |method|
method = method.to_s
next unless method =~ /^visit_(.*)$/
const = $1.split('_').inject(Object) { |m,s| m.const_get s }
DISPATCH[const] = method
end
def quote value, column = nil
@connection.quote value, column
end
def quote_table_name name
@connection.quote_table_name name
end
def quote_column_name name
@connection.quote_column_name name
end
end
end
end
|
