Thanks a lot, I will try that out!
On Tuesday, November 20, 2012 4:58:01 PM UTC+8, Jeremy Evans wrote:
>
> On Monday, November 19, 2012 7:26:51 PM UTC-8, Stefan Rohlfing wrote:
>
>>
>> You probably don't want to add friends as an association. I would use a
>>> simple method:
>>>
>>> class User < Sequel::Model
>>> def friends
>>> follows & followers
>>> end
>>> end
>>>
>>> since friends appears to be the intersection of follows and followers.
>>>
>>
>> Thanks for this simple and elegant implementation. However, I am still
>> interested to know I could achieve the same result using an association. Or
>> would you in this case just write the raw SQL query?
>>
>>
> You could probably use an custom association if you wanted to:
>
> User.many_to_many :friends, :class=>User,
> :dataset=>proc{User.join(:relationships___ru, :user_id =>
> :nickname).join(:relationships___rf,
> :follower_id=>:users__nickname).where(:ru__follower_id=>nickname,
> :rf__user_id=>nickname)}
>
> Writing an eager loader for the association is left as an exercise to the
> reader. :)
>
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/44Gko6OjZsEJ.
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/sequel-talk?hl=en.
