How do I handle the where conditions dynamically in squeel?

Question

From this input: {'hearing' => 1} I need to generate this query

Score.joins(:target_disability).where{ (target_disabilities.name == 'hearing') & (round(total_score) >= 1) }

From this input is {'hearing' => 1, 'mobility' => 2}, I need to generate this:

Score.joins(:target_disability).where{ (target_disabilities.name == 'hearing') & (round(total_score) >= 1) | (target_disabilities.name == 'mobility') & (round(total_score) >= 2) }

And so on...

How can this be generalized? Because my input sometimes has 3 or 4 keys... sometime 1...

score 2 · Accepted Answer · answered May 13 '12 at 12:42

2

Assuming your hash is in my_params:

@scores = Score.joins(:target_disability).where do
    my_params.map{|k,v| (target_disabilities.name==k) & (round(total_score)>=v) }.inject(:|)
end

answered May 13 '12 at 12:42

jdoe

15,665
2
46
48

can you look at this for me? http://stackoverflow.com/questions/14654010/squeel-and-rails-dynamic-where-clause – Joel Grannas Feb 01 '13 at 20:24

How do I handle the where conditions dynamically in squeel?

1 Answers1

Linked