On Mon, Feb 14, 2011 at 11:04 PM, Walter Lee Davis <[email protected]>wrote:
>
> On Feb 14, 2011, at 9:53 AM, Lille wrote:
>
> Jim,
>>
>> Thanks, but your proposed RecordOwner would have no behavior distinct
>> from User and would not describe the relationship from the Project
>> model's perspective. My User shouldn't care about the kind of relation
>> it has to Project, rather the reverse.
>>
>> My pseudocode is about as specific as I know how to get.
>>
>> To recap in its most distilled form, my problem is what relationships
>> to include in two models, User and Project, where a User may be
>> associated with Project in any of three ways -- User,
>> 'primary_record_owner', or 'record_owner, such that the following
>> expressions are possible:
>>
>> 1) @user.projects # returns all projects associated with a User
>> instance
>>
>
Can't you use a condition for the has many while eager loading the other
models? Something like
has_many :projects, :include => [:record_owners, :project_users], :include
=> 'primary_record_owner = #{self.id} OR record_owners.user_id = #{self.id}
OR project_users.user_id = #{self.id}'
> 2) @project.primary_record_owner # returns a User instance
>> 3) @project.record_owners # returns a collection of User instances
>> 4) @project.users # returns a collection of User instances
>>
>> I think I see how to accomplish 2-4, using HABTM, but I don't see how
>> to accomplish 1) at the same time.
>>
>
> Have you thought about a polymorphic join model between the two, like maybe
> a Role? That's how I ended up structuring a recent project.
>
> Walter
>
>
>
>> Thanks,
>>
>> Lille
>>
>> On Feb 13, 8:41 pm, Jim Ruther Nill <[email protected]> wrote:
>>
>>> I'm thinking about 4 models
>>>
>>> - User
>>> - Project
>>> - RecordOwner
>>> - UserProject -> this is the join table for user and project
>>>
>>> You won't need RecordOwner if record_owners is a subset of the users
>>> association.
>>> Give us an example so we can help out with the options you want.
>>>
>>>
>>>
>>> On Mon, Feb 14, 2011 at 8:17 AM, Lille <[email protected]> wrote:
>>>
>>>> Hi,
>>>>
>>>
>>> I want to specify relationships between two classes like that
>>>> expressed in the following pseudocode:
>>>>
>>>
>>> class User < ActiveRecord::Base
>>>> has_many :projects
>>>> end
>>>>
>>>
>>> class Project < ActiveRecord::Base
>>>>
>>>
>>> has_one :primary_record_owner, :<pseudo_option_for_referring_to>=>"User"
>>>> has_many :record_owners, :<pseudo_option_for_referring_to>=>"User"
>>>> has_many :users # this refers to User, too
>>>> end
>>>>
>>>
>>> From the above I seek the following kind of results:
>>>>
>>>
>>> @user.projects # returns all projects associated with the user from
>>>> any of the three User associations in Project
>>>> @project.primary_record_owner # returns the User instance
>>>> @project.record_owners # returns the collection of User instances
>>>> @project.users # returns User instances, not necessarily overlapping
>>>> with the other associations
>>>>
>>>
>>> The intent I mean to express is that a Project can have any of three
>>>> levels of relationship with a User, while a User has only one level of
>>>> association with a Project.
>>>>
>>>
>>> I was thinking HABTM, but I don't see how to get my desired
>>>> '[email protected]' result from that.
>>>>
>>>
>>> Any helpful comment would be greatly appreciated.
>>>>
>>>
>>> Thanks,
>>>>
>>>
>>> Lille
>>>>
>>>
>>> --
>>>> 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.
>>>>
>>>
>>> --
>>> -------------------------------------------------------------
>>> visit my blog athttp://jimlabs.heroku.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.
>>
>>
> --
> 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.
>
>
--
-------------------------------------------------------------
visit my blog at http://jimlabs.heroku.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.
