http://bin.cakephp.org/view/1178242700
This is the behaviour I use for this purpose. Basically it looks at every query, and if you haven't already set any conditions that look at the owner id (or "artist_id" in your case), then it automatically appends a condition to only retrieve those owned by the model's "$active_owner_id" property, or what is in the session. Using the session in a behaviour like this is a terrible hack - but it works for us. If you don't need to do this, remove that stuff and just always have $this->Track->active_owner_id = 123; $tracks = $this->Track->findAll(); On Apr 22, 7:44 am, tgies <[EMAIL PROTECTED]> wrote: > I am setting up a website for an independent music publisher. > > Rather, I am setting up three websites: the label's own website and > three artists' websites. We will call the artists foo, bar, and plugh. > > All of these sites use the same database. The rationale behind this is > that each artist's catalog can be populated with their songs/albums > from the label's central catalog, with the label's catalog displaying > all songs/albums from all artists. > > All models are associated with a certain artist_id, which should make > it possible for each artist's site to transparently only select its > own database records. But how would I go about doing this? Is there > something I can add to AppModel to automatically add this constraint > to every find? > > Thanks, > tgies --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---