CODEWITHSUNDEEP
ruby-on-railsmigration
Meltemi
Meltemi

Reputation: 38359

Adding a Model Reference to existing Rails model

I'd like to know the "proper" way to approach adding a relation between two existing classes in Rails 3.

Given existing models: Clown & Rabbit

I'd like to add a reference (belongs_to) from Rabbit to Clown. I start by trying to generate a migration: 

rails g migration AddClownToRabbits clown:reference

which gives me a migration that looks like: 

class AddClownToRabbits < ActiveRecord::Migration
  def self.up
    add_column :rabbits, :clown, :reference
  end

  def self.down
    remove_column :rabbits, :clown
  end
end

After rake db:migrate on this migration I examine SQLite3's development.db and see a new column: "clown" reference

I guess I was expecting a "clown_id" integer column and a migration that looked like:

class AddClownToRabbits < ActiveRecord::Migration
  def self.up
    add_column :rabbits, :clown_id
  end

  def self.down
    remove_column :rabbits, :clown_id
  end
end

I'm sure :reference is supposed to be equivalent to "t.references :clown" but I can't find the documentation (big surprise). API says add_column: Instantiates a new column for the table. The type parameter is normally one of the migrations native types, which is one of the following: :primary_key, :string, :text, :integer, :float, :decimal, :datetime, :timestamp, :time, :date, :binary, :boolean.

...with no reference to :reference.

Upvotes: 28

Views: 40008

Answers (4)

Varun
Varun

Reputation: 39

To add references to already existing model in rails we have to create a migration: Suppose we have a User, Post model=> to add user references to posts we say

$ rails generate migration add_user_to_post user:references

Upvotes: -1

clemensp
clemensp

Reputation: 2510

After you set belongs_to in Rabbit, and has_many in Clown, you can do a migration with:

add_column :rabbit, :clown_id, :integer

EDIT: See Paulo's answer below for a more updated answer (Rails 4+)

Upvotes: 18

Paulo Fidalgo
Paulo Fidalgo

Reputation: 22311

If you are using edge rails (4.0) you can use:

rails generate migration AddAddressRefToContacts address:references

As you can see by the docs.

Upvotes: 64

ryeguy
ryeguy

Reputation: 66851

I'm not sure where you got this idea, but there is no (and never has been) such syntax to do what you want with add_column. To get the behavior you want, you'd have to do t.refences :clown, as you stated. In the background this will call: @base.add_column(@table_name, "#{col}_id", :integer, options).

See here.

EDIT:

I think I can see the source of your confusion. You saw the method call t.reference and assumed it was a datatype because calls such as t.integer and t.string exist, and those are datatypes. That's wrong. Reference isn't a datatype, it's just simply the name of a method, similar to t.rename is.

Upvotes: 5

Related Questions