Also very elucidative, Colin. Thank you very much!
On 3 set, 16:58, Colin Law <[email protected]> wrote:
> 2009/9/3 Daniel Drehmer <[email protected]>:
>
>
>
> > The only thing that remains unknown to me is how query the list of
> > users of a given sandbox that have the role "donkey". Is it possible
> > to use the find method the rails way, without "injecting" sql?
>
> Yes of course, you should very rarely find yourself using sql. If you
> have a Sandbox called @sandbox then the users of that sandbox are
> @sandbox.users so those that have the role donkey are
> @sandbox.users.find_by_role('donkey')
> At least I think you can do that, I prefer to use a named scope rather
> than find_by.. So you might have a named scope on User called
> by_role(role) that returns the Users with the given role. Then you
> would use
> @sandbox.users.by_role('donkey')
> Or if you often wanted to find the donkeys then you might have a named
> scope on User called donkies that finds them and then you could say
> @sandbox.users.donkies
>
> Colin
>
>
>
>
>
> > On 3 set, 16:29, Daniel Drehmer <[email protected]> wrote:
> >> Thank you Ar Chron! This is exactly what I was looking for.
>
> >> I appreciate the other answers, but those reading this thread should
> >> notice that the case I described could not be solved without this
> >> "role" attribute in the participation model.
>
> >> This was the missing piece. Thank you!
>
> >> On 3 set, 13:21, Ar Chron <[email protected]> wrote:
>
> >> > > Any idea of how to approach this?
>
> >> > Sounds like Users, Sandboxes, and Participations - the main point being
> >> > a full join table (participation) with additional attributes
>
> >> > User
> >> > has_many :participations
> >> > has_many :sandboxes, :through => :participations
>
> >> > Sandbox
> >> > has_many :participations
> >> > has_many :users, :through => :participations
>
> >> > Participation
> >> > user_id
> >> > sandbox_id
> >> > role (which is user, or admin, or donkey, or whatever)
> >> > belongs_to :user
> >> > belongs_to :sandbox
>
> >> > Or something along those lines...
> >> > --
> >> > Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
