Ruby parse SQL query string into hash

Question

I am trying to parse a SQL query string into a hash. Example: field = value AND field2 = value2 becomes { field: 'value', field2: 'value2' }

I have tried Rack::Utils.parse, which works great for URL params, but doesn't for SQL query string.

My initial thoughts are to split by AND, OR etc and then use Rack::Utils.parse recursively.

I was thinking there would be a straightforward way of doing this in Rails, but I haven't found anything yet. Has anyone accomplished this before?

Thanks in advance.

B Seven · Accepted Answer · 2015-05-06 18:10:12Z

1

sql_query = 'field = value AND field2 = value2 OR field3 = value3'

def hash_for sql_query
  parts = sql_query.split /(and|or)/i
  parts.map do | p | 
    fv = p.split('=').map &:strip
    { fv[0].to_sym => fv[1] }
  end
end

answered May 6, 2015 at 18:10

B Seven

46.3k73 gold badges257 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Ruby parse SQL query string into hash

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related