Rails 3 query multi-dimensional array

Question

I have an array called @venues with all the restaurants within a radius. Each venue has_manydishes and I want to insert an array of these dishes into venue.

@venues = Venue.within(radius, :origin => [lat, lng]).order('distance ASC')

@venues.each do |venue|
  dishes = venue.dishes.where("? BETWEEN DATE(served_from) AND DATE(served_until)", Date.today)
  # insert dishes into venue
end

How do I insert dishes into venue so that I can access all the available dishes of an venue with: @venues[i].dishes?

sgtFloyd · Accepted Answer · 2012-03-15 15:48:09Z

4

It might might more sense to add a scope on Dish itself:

scope :today, :conditions => ["? BETWEEN DATE(served_from) AND DATE(served_until)", Date.today]

With that, you can access the available dishes with @venues[i].dishes.today

edited Mar 15, 2012 at 15:48

answered Mar 15, 2012 at 14:46

sgtFloyd

1,0071 gold badge10 silver badges18 bronze badges

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

1 Comment

Andrew Marshall Over a year ago

Agreed. It might be useful though to clarify why what they're doing is a bad idea: they're mutating the state of each Venue instance (by assigning dishes to a subset of itself) with no intent to save those changes because they're not actually correct.

Collectives™ on Stack Overflow

Rails 3 query multi-dimensional array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related