Ruby on Rails Use custom id for join table

Question

I'm trying to get a join table working with a custom id in the schema. I want to be able to get all the relevant posts for a user through the join table using the custom_id on the join table as recipient_id

Here is my current setup:

class User > ActiveRecord::Base
  has_many :user_posts
  has_many :received_posts, through: :user_posts, source: :recipient
end

class UserPost < ActiveRecord::Base
  belongs_to :recipient, class_name: "User"
  belongs_to :post
end

class Post < ActiveRecord::Base
  has_many :user_posts
  has_many :recipients, through: :user_posts, source: :recipient
end

Here's the schema of my join table:

UserPost
recipient_id: integer
post_id: integer

The error I get is:

PG::UndefinedColumn: ERROR:  column user_posts.user_id does not exist

I've tried adding the source like above but to no avail. It makes me think that it's looking for the user_id and not recipient_id on the join table. I'm not sure how to correctly specify the custom id as the field to use. I've tried foreign keys and other answers on here but to no luck. Could be that I'm implementing foreign keys or source wrong.

Any help is much appreciated, Thanks.

xiaoboa · Accepted Answer · 2017-05-05 08:19:50Z

2

In User model, add foreigh_key to :user_posts

class User > ActiveRecord::Base
  has_many :user_posts, foreign_key: :recipient_id
  has_many :received_posts, through: :user_posts, source: :recipient
end

answered May 5, 2017 at 8:19

xiaoboa

1,95114 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jckly Over a year ago

Thanks a lot! worked perfectly. I'd been adding the foreign key to the has_many through association.

Collectives™ on Stack Overflow

Ruby on Rails Use custom id for join table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related