Scope parameter as array in Rails 5

Question

I have this scope with the parameter city, the scope receives the parameter, joins a table call Restaurant (because I have the param there) and then it makes a where condition with IN for multiple OR.

scope :by_cities, -> (city) { joins(:restaurant).where('restaurants.city IN (?)', city) }

The thing is that I want to learn how the scope can receive an array of param in the scope, I already have tried a lot of stuff and I'm taking the guide of this guy: Rails 4 scope with argument and this: ActiveRecord where field = ? array of possible values

Logs

Parameters: {"city"=>"SanPedro"} SELECT "vacancies".* FROM "vacancies" INNER JOIN "restaurants" ON "restaurants"."id" = "vacancies"."restaurant_id" WHERE (restaurants.city IN ('SanPedro'))

Route

http://localhost:3000/v1/vacancies?city=SanPedro&Monterrey

But, don't understand very well how to do it, anyone knows about this?

"don't understand very well how to do it" - but you already did it. Use it like this: MyModel.by_cities([city1, city2]) — Sergio Tulentsev
– Sergio Tulentsev, Commented Aug 8, 2018 at 22:24
doesn't work that way, I already tried, when I write MyModel.by_cities('New York', 'San Fransisco') I get this error: ArgumentError: wrong number of arguments (given 2, expected 1) — Daniel Disblu
– Daniel Disblu, Commented Aug 8, 2018 at 22:31
Have you tried scope :by_cities, -> (*cities) { joins(:restaurant).where('restaurants.city IN (?)', cities) }? BTW, the docs state "Using a class method is the preferred way to accept arguments for scopes." — jvillian
– jvillian, Commented Aug 8, 2018 at 22:42
I already try that too, fortunately, I don't get an error but when I'm getting the consult in the database I don't get all the info, only one city, the return of the logs was this: SELECT "vacancies".* FROM "vacancies" INNER JOIN "restaurants" ON "restaurants"."id" = "vacancies"."restaurant_id" WHERE (restaurants.city IN ('Monterrey')) and I want the same but with multiple values, like this: SELECT "vacancies".* FROM "vacancies" INNER JOIN "restaurants" ON "restaurants"."id" = "vacancies"."restaurant_id" WHERE (restaurants.city IN ('Monterrey, SanPedro')) — Daniel Disblu
– Daniel Disblu, Commented Aug 8, 2018 at 23:00
"when I write MyModel.by_cities('New York', 'San Fransisco')" - but that's not what i wrote. My example has an array, yours doesn't. — Sergio Tulentsev
– Sergio Tulentsev, Commented Aug 9, 2018 at 7:31

jvillian · Accepted Answer · 2018-08-08 23:24:30Z

2

Minimally, there is a problem with how you're forming your url query, here:

http://localhost:3000/v1/vacancies?city=SanPedro&Monterrey

As you can see in your params:

Parameters: {"city"=>"SanPedro"}

Your not getting an array of cities. Try something more like:

http://localhost:3000/v1/vacancies?city%5B%5D=San+Pedro&city%5B%5D=Monterrey

Which should give you something like:

Parameters: {"city"=>['San Pedro', 'Monterrey']}

BTW, you can see how a proper query string should look by doing:

{city: ['San Pedro', 'Monterrey']}.to_query

in your console.

Then, you should be able to do something like:

Vacancy.by_city(params[:city])

answered Aug 8, 2018 at 23:24

jvillian

20.3k5 gold badges33 silver badges45 bronze badges

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

1 Comment

Daniel Disblu Over a year ago

thank you for your response, it helps me, I didn't know about to_query, it will help me a lot in the future!

Collectives™ on Stack Overflow

Scope parameter as array in Rails 5

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related