Ruby on rails – Reference the same model twice?

by

Here’s a complete answer to this issue, in case people visiting this question are new to Ruby on Rails and having a hard time putting everything together (as I was when I first looked into this).

Some parts of the solution take place in your Migrations and some in your Models:

Migrations

class CreatePrivateMessages < ActiveRecord::Migration
  def change
    create_table :private_messages do |t|
      t.references :sender
      t.references :recipient
    end
    # Rails 5+ only: add foreign keys
    add_foreign_key :private_messages, :users, column: :sender_id, primary_key: :id
    add_foreign_key :private_messages, :users, column: :recipient_id, primary_key: :id
  end
end

Here you are specifying that there are two columns in this table that will be referred to as :sender and :recipient and which hold references to another table. Rails will actually create columns called ‘sender_id’ and ‘recipient_id’ for you. In our case they will each reference rows in the Users table, but we specify that in the models, not in the migrations.

Models

class PrivateMessage < ActiveRecord::Base
  belongs_to :sender, :class_name => 'User'
  belongs_to :recipient, :class_name => 'User'
end

Here you are creating a property on the PrivateMessage model named :sender, then specifying that this property is related to the User class. Rails, seeing the “belongs_to :sender”, will look for a column in your database called “sender_id”, which we defined above, and use that to store the foreign key. Then you’re doing the exact same thing for the recipient.

This will allow you to access your Sender and Recipient, both instances of the User model, through an instance of the PrivateMessage model, like this: 

@private_message.sender.name
@private_message.recipient.email

Here is your User Model:

class User < ActiveRecord::Base
  has_many :sent_private_messages, :class_name => 'PrivateMessage', :foreign_key => 'sender_id'
  has_many :received_private_messages, :class_name => 'PrivateMessage', :foreign_key => 'recipient_id'
end

Here you are creating a property on the User Model named :sent_private_messages, specifying that this property is related to the PrivateMessage Model, and that the foreign key on the PrivateMessage model which relates it to this property is called ‘sender_id’. Then you are doing the same thing for received private messages.

This allows you to get all of a users sent or received private messages by doing something like this:

@user.sent_private_messages
@user.received_private_messages

Doing either of these will return an array of instances of the PrivateMessage model.

….

More Related Contents:

  1. Rails extending ActiveRecord::Base
  2. How to change default timezone for Active Record in Rails?
  3. Rails :include vs. :joins
  4. Rails ActiveRecord date between
  5. Rails 4 scope to find parents with no children
  6. Random record in ActiveRecord
  7. What is the easiest way to duplicate an activerecord record?
  8. ActiveRecord: size vs count
  9. Rails: How can I set default values in ActiveRecord?
  10. How to express a NOT IN query with ActiveRecord/Rails?
  11. How can I avoid running ActiveRecord callbacks?
  12. Rails 4: List of available datatypes
  13. ActiveRecord OR query Hash notation
  14. Rails: Access to current_user from within a model in Ruby on Rails
  15. Rails 5: ActiveRecord OR query
  16. Rails – Nested includes on Active Records?
  17. ActiveRecord Find By Year, Day or Month on a Date field
  18. Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)
  19. Rails 3 SQLite3 Boolean false
  20. Add a reference column migration in Rails 4
  21. find vs find_by vs where
  22. How to skip ActiveRecord callbacks? [duplicate]
  23. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  24. Rails update_attributes without save?
  25. query , can not select column count
  26. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  27. Can I write PostgreSQL functions on Ruby on Rails?
  28. New data not persisting to Rails array column on Postgres
  29. Validate uniqueness of multiple columns
  30. Changing a column type to longer strings in rails

Leave a Comment