Do I need to manually create a migration for a HABTM join table?

Ruby on-Rails

Ruby on-Rails Problem Overview


I'm struggling now to get HATBM working correctly. I have a beaten scanario: articles and tags. I presume, HABTM should be used here, since it is a many-to-many relationship. I don't know however if I should manually create a join table (articles_tags in this case).

My code currently as follows:

class Article < ActiveRecord::Base
  has_and_belongs_to_many :tags  
end

class Tag < ActiveRecord::Base
  has_and_belongs_to_many :articles
end

When I run the migrations, no 3rd table is created. Also, I would like to add that my third table doesn't bear any domain logic, just blind assignment.

I'm using Rails 2.2.2

Ruby on-Rails Solutions


Solution 1 - Ruby on-Rails

You should do this in a migration of one of the tables, or in a separate migration if those migrations have been ran:

create_table :articles_tags, :id => false do |t|
  t.references :article, :tag
end

add_index :articles_tags, [:article_id, :tag_id]

This will create the table for you and the :id => false tells Rails not to add an id field to this table. There's an index also, which will speed up lookups for this join table.

You could also generate a model (ArticlesTag) for this and do:

# article.rb
has_many :articles_tags
has_many :tags, :through => :articles_tags

# tag.rb
has_many :articles_tags
has_many :articles, :through => :articles_tags

# article_tag.rb
belongs_to :tag
belongs_to :article

And then create the table in the migration generated from the script/generate model articles_tag call.

Solution 2 - Ruby on-Rails

Solution 3 - Ruby on-Rails

You probably also want to add an index to the migration:

add_index "articles_tags", "article_id"

add_index "articles_tags", "tag_id"

However, if you want tagging functionality I'd recommend the acts_as_taggable_on rails plugin:

http://www.intridea.com/tag/acts_as_taggable_on http://github.com/mbleigh/acts-as-taggable-on/

I've used it on a project and it was very easy to implement.

One of the issues with a join table for tagging is that it can easily get ugly creating a join table for each content type you wish to make taggable (ie. comments_tags, posts_tags, images_tags, etc). This plugin uses a taggings table which includes a discriminator to determine the content type without the need of a specific join table for each type.

Solution 4 - Ruby on-Rails

In combination with this Qeuestion(1st answear) https://stackoverflow.com/questions/6689540/how-to-set-up-a-typical-users-habtm-roles-relationship and 1st answear from here, it has to be understood even by a monkey. I am new in RoR and it's got working like a charm

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionValentin VView Question on Stackoverflow
Solution 1 - Ruby on-RailsRyan BiggView Answer on Stackoverflow
Solution 2 - Ruby on-RailsSai PerchardView Answer on Stackoverflow
Solution 3 - Ruby on-RailsJack ChuView Answer on Stackoverflow
Solution 4 - Ruby on-RailsmArtinko5MBView Answer on Stackoverflow