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:
1. 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?
2. 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!