Hi, I’m a noob trying to figure out the best way to limit queries by a
particular condition that is dependent on the subdomain of the site.
I have a table “places” with a field called “subdomain”. Say I have
another table that belongs to places called “knights” (contains
“place_id”). Like so:
places
table - Place.id, Place.subdomain
knights
table - Knight.id, Knight.place_id
On the site, “heredia.knightsofni.es”, I only want to show the
knights who live in Heredia wherever knights are shown.
My questions are these:
-
What is the best way to set the “active” place globally? Right now
I am setting an instance variable @active_place in
application_controller.rb like so: @active_place = Place.find
(:first, :conditions => [‘places = ?’, subdomain]). Is this OK, or is
there a better way so that the @active_place data is more globally
available? -
How can I constrain by place while staying RESTful? Right now I’m
putting if/then statements in my controller methods like so: if
@active_place { @knights = Knight.by_place } else { @knights =
Knight.all }
Thanks for the help,
Ni!