Forum: Ruby on Rails Database Foreign Key - Basic question

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
D1fc110cbf58452f943666fe00d63487?d=identicon&s=25 Anthony (Guest)
on 2006-02-03 04:59
(Received via mailing list)
Hi all

I'm still waiting on my Agile Rails book to arrive - in the meantime ...
As an exercise I'm making a Help Desk application.
If I have a Problems table with two foreign keys to a People table,
how do I set up my models, problems_controller list method, and then
simply display say my problem submitter person? Here is what I have so
far:

Problems table with columns:
   id
   description
   submitter_id (foreign key to People table)
   assigned_to_id (foreign key to People table)
   etc

People table with columns:
   id
   name

models:
class Problem < ActiveRecord::Base
	has_many :people

class Person < ActiveRecord::Base
	has_many :problems

problem_Controller:
def list
    @submitter = Person.find(params[:submitter_id]  ???

views:problems:list.rhtml
    <td><%= problem.submitter.name %></td> ???
E48d29dc8fedb2878fa518d41cc63d88?d=identicon&s=25 Jan Prill (Guest)
on 2006-02-03 08:15
(Received via mailing list)
Hi, Anthony,

maybe you want to try something along the lines of:

class Problem < ActiveRecord::Base
  belongs_to :submitter, :class_name => 'Person', :foreign_key =>
'submitter_id'
  belongs_to :agent, :class_name => 'Person', :foreign_key =>
'assigned_to_id'
end

(untested, but should do it)

Best Regards
Jan Prill

2006/2/3, Anthony <portal33@gmail.com>:
This topic is locked and can not be replied to.