StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORails: Multiple "has_many through" for the two same models?
primarykey
Id
2542526
data
AcceptedAnswerId
2542553
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-03-30T02:34:45.957
FavoriteCount
3
LastActivityDate
2010-03-30T02:42:19.940
LastEditDate
LastEditorUserId
0
OwnerUserId
32154
ParentId
0
PostTypeId
1
Score
0
ViewCount
1536
LastEditorDisplayName
text
Body
Can't wrap my head around this... <pre><code>class User < ActiveRecord::Base has_many :fantasies, :through => :fantasizings has_many :fantasizings, :dependent => :destroy end class Fantasy < ActiveRecord::Base has_many :users, :through => :fantasizings has_many :fantasizings, :dependent => :destroy end class Fantasizing < ActiveRecord::Base belongs_to :user belongs_to :fantasy end </code></pre> ... which works fine for my primary relationship, in that a <code>User</code> can have many <code>Fantasies</code>, and that a <code>Fantasy</code> can belong to many <code>Users</code>. However, I need to add another relationship for liking (as in, a <code>User</code> "likes" a <code>Fantasy</code> rather than "has" it... think of Facebook and how you can "like" a wall-post, even though it doesn't "belong" to you... in fact, the Facebook example is almost exactly what I'm aiming for). I gathered that I should make another association, but I'm kinda confused as to how I might use it, or if this is even the right approach. I started by adding the following: <pre><code>class Fantasy < ActiveRecord::Base ... has_many :users, :through => :approvals has_many :approvals, :dependent => :destroy end class User < ActiveRecord::Base ... has_many :fantasies, :through => :approvals has_many :approvals, :dependent => :destroy end class Approval < ActiveRecord::Base belongs_to :user belongs_to :fantasy end </code></pre> ... but how do I create the association through <code>Approval</code> rather than through <code>Fantasizing</code>? If someone could set me straight on this, I'd be much obliged!
Tags
<ruby-on-rails><associations>
Title
Rails: Multiple "has_many through" for the two same models?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USneezer
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PORails: Multiple "has_many through" for the two same models?
 UserUserId
 USStefan Pettersson
 VoteTypeVoteTypeId
 VTFavorite
2. VO
 singulars
 PostPostId
 PORails: Multiple "has_many through" for the two same models?
 UserUserId
 USt0rpedo
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.