Sequel Grep using variables as matcher

Question

I'd like to do a query using the Sequel's Models object. I'd like the pattern to match certain variables value like so:

Models::Show.grep(:name, %w'#{var1} #{var2}')

But unfortunately, the Models.grep instance method seems not to be working this way. It query as following:

SELECT * FROM "shows" 
WHERE (("name" LIKE '#{titre_fr}' ESCAPE '\') 
OR ("name" LIKE ' {titre_en}' ESCAPE '\'))

Is there a way to make the function work with variables ?

score 1 · Accepted Answer · edited May 23 '17 at 11:44

1

Just do as below :

Models::Show.grep(:name, %W(#{var1} #{var2}))

Demo example :

a = 2
b = 3
%W(#{a} #{b}) # => ["2", "3"]

edited May 23 '17 at 11:44

Community

answered Jan 09 '14 at 19:44

Arup Rakshit

I just tried it, getting the same result. is the W case sensitive ? – Francis.Beauchamp Jan 09 '14 at 19:49
@Francis.Beauchamp Can you give the method documentation link..? – Arup Rakshit Jan 09 '14 at 19:50
Edited my first comment. You will find the doc here http://sequel.jeremyevans.net/rdoc/classes/Sequel/Dataset.html#method-i-grep – Francis.Beauchamp Jan 09 '14 at 19:51
@Francis.Beauchamp what is var1 and var2 ? – Arup Rakshit Jan 09 '14 at 19:53
Its a variable inside an array. But in the end, I think my error was not making the w upper-case. Changed it and now it seems to work as intended. – Francis.Beauchamp Jan 09 '14 at 19:55
I think adding the 2 % makes it match any records with the characters between them. It results in thousands of queries (I have stopped the process in case I get an overflow). Your first answer was better for me, along with a precision that W must be upper-case ! – Francis.Beauchamp Jan 09 '14 at 20:02
@Francis.Beauchamp let me know which one works for you. i will update it in my answer.. as i am not aware of what's going on there.. – Arup Rakshit Jan 09 '14 at 20:04
Models::Show.grep(:name, %W(#{var1} #{var2})) works, and W must be upper-case – Francis.Beauchamp Jan 09 '14 at 20:16

score 0 · Answer 2 · answered Jul 20 '16 at 16:40

0

Your code

Models::Show.grep(:name, %w'#{var1} #{var2}')

Is using single quotes. Change to double quotes and it will work

Models::Show.grep(:name, %w"#{var1} #{var2}")

answered Jul 20 '16 at 16:40

MR-RON

2 Answers2