On Tue, Apr 28, 2009 at 9:38 PM, blgroup <blgr...@gmail.com> wrote:
>
> Having trouble with a somewhat unconventional modelling in Rails
> 2.2.2.
>
> Take three table.
>
> 1. User model with primary integer id and a unique string guid.
>
> 2. Model X has foreign key to User as integer user_id and its model
> includes
> belongs_to :users
>
> 3. Model Y has foreign key to User as string user_guid and its model
> includes
> belongs_to :users, :foreign_key => 'user_guid'

Are you sure you don't mean:
belongs_to :user, :foreign_key => 'user_guid' #<- Using singular 'user'
then Y.user should work fine

>
>
> This tells Rails which column to use in Model Y to look up Users.
> But How do I tell Rails which column to use in User?
>
> In other words, how do I tell Rails to join (or select) from
> Users.guid instead of Users.id when  referencing Y.user?
>
> The has_one and has_many association has a :primary_key option, but
> this seems to be missing on the belongs_to association
>
> How do people work around this?  Any help would be greatly
> appreciated.
>
> Thanks,
> =Blair.

Setup your user model like this:

class User < ActiveRecord::Base
  set_primary_key :guid
end


Andrew Timberlake
http://ramblingsonrails.com
http://www.linkedin.com/in/andrewtimberlake

"I have never let my schooling interfere with my education" - Mark Twain

--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to