HI everybody,
I need some help with model association.
Here I have one user table.
User table. id name 1 XXX 2 YYY 3 ZZZ 4 XYZ
Message Table
id sender_id receiver_id message 1 1 2 HI. HOW R U 2 2 1 YEAH. FINE 3 2 4 HI. WR R U NOW?
1. Here I want get the sender_name and receiver name for an message. Like below @msg=Message.find(1) @msg.sender.name @msg.receiver.name
class Message < ActiveRecord::Base belongs_to :sender, :class_name => "User" belongs_to :receiver, :class_name => "User" end
2. Same like I want to get the sent and received messages for a Particular message. @user=User.find(1) @user.sent_msg @user.received_msg
class User < ActiveRecord::Base has_many :sent_messages, :class_name => "Message", :foreign_key => "sender_id" has_many :received_messages, :class_name => "Message", :foreign_key => "receiver_id" end
Pat