CODEWITHSUNDEEP
htmlruby-on-railsajax
Alon Shmiel
Alon Shmiel

Reputation: 7121

Add a column to a table

how to add a column to my table Users.

because I ran the migration, I have to do something like:

rails generate migration AddShowmsgColumnToUsers show_msg:boolean

and then: 

rake db:migrate

but I'm not sure about "AddShowmsgColumnToUsers". how can I know how it suppose to be? why not: AddShow_msgColumnToUsers? if the problem was pluralization and singularization, I can run the rails console and check that, but how can I know about the uppercase letter: ShowMsg/Show_msg/Show_Msg/Showmsg? is there a command that helps me to check it?

Upvotes: 0

Views: 90

Answers (2)

Peter de Ridder
Peter de Ridder

Reputation: 2399

If you generate a migration to add an column, you should use either camelcase or underscores. Besides you dont have to put "Column" inside your migration generator, with Add...To... the migration already knows you are adding a column.

So either:

rails generate migration AddShowMsgToUsers show_msg:boolean

or:

rails generate migration add_show_msg_to_users show_msg:boolean

Is the way to go. The migration-generator will result in the following migration:

class AddShowMsgToUsers < ActiveRecord::Migration
  def change
    add_column :users, :show_msg, :boolean
  end
end

Of course you could also do it all manually, but the whole point of generators is that you don't need to write everything yourself.

Upvotes: 1

Sam Peacey
Sam Peacey

Reputation: 6034

In answer to your first question, it doesn't matter, as long as the table name is correct - Rails uses the arguments you specify for the columns rather than the name of the migration.

Also, you should only really be asking one question at a time... ;-)

Upvotes: 1

Related Questions