StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>What you want is a many to many relationship between User and Feed.</p> <p>You'll want something like this in your code for the User and Feed relationship to work.</p> <pre><code>class User < ActiveRecord::Base has_and_belongs_to_many :feeds end class Feed < ActiveRecord::Base has_and_belongs_to_many :users end </code></pre> <p>You can read more about this in the Rails Guides - <a href="http://guides.rubyonrails.org/association_basics.html#the-has_and_belongs_to_many-association" rel="nofollow">http://guides.rubyonrails.org/association_basics.html#the-has_and_belongs_to_many-association</a></p> <p>You may also want to look at using has_many :through with an intermediate model for this (explained here <a href="http://guides.rubyonrails.org/association_basics.html#choosing-between-has_many-through-and-has_and_belongs_to_many" rel="nofollow">http://guides.rubyonrails.org/association_basics.html#choosing-between-has_many-through-and-has_and_belongs_to_many</a>) if you'd like to store any meta data for a user-feed relationship record.</p> <p>Edit: I managed to get a similar setup working on 3.0 as well as 3.1 (using has_many :through).</p> <p>Here are the contents of my models.</p> <pre><code>➜ app cat app/models/* class Cast < ActiveRecord::Base belongs_to :feed end class Feed < ActiveRecord::Base has_many :subscriptions has_many :casts end class Subscription < ActiveRecord::Base belongs_to :user belongs_to :feed end class User < ActiveRecord::Base has_many :subscriptions has_many :feeds, :through => :subscriptions # For 3.1 has_many :casts, :through => :feeds # For 3.0 def casts Cast.joins(:feed => :subscriptions).where("subscriptions.user_id" => self.id) end end </code></pre> <p>and here are the migrations I used</p> <pre><code>➜ app cat db/migrate/* class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| t.string :name t.timestamps end end def self.down drop_table :users end end class CreateFeeds < ActiveRecord::Migration def self.up create_table :feeds do |t| t.string :name t.timestamps end end def self.down drop_table :feeds end end class CreateCasts < ActiveRecord::Migration def self.up create_table :casts do |t| t.string :name t.integer :feed_id t.timestamps end end def self.down drop_table :casts end end class CreateSubscriptions < ActiveRecord::Migration def self.up create_table :subscriptions do |t| t.integer :feed_id t.integer :user_id end end def self.down drop_table :subscriptions end end </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload