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
|
# File 'lib/ugc/helpers/parse.rb', line 3
def parse_sql(query)
result = {}
keywords = %w(select from where limit)
current = nil
query.downcase.split(/[\s,*]/).each do |ea|
next if ea == '' || (current == 'select' && ea == 'distinct')
if keywords.include? ea
current = ea
elsif current
if current == 'select' and ea.start_with? "{"
current = nil
next
end
if result[current]
if result[current].is_a? Array
result[current] << ea
else
result[current] = [result[current]] << ea
end
else
result[current] = (current == 'select') ? [ea] : ea
end
end
end
result
end
|