Rails: Editing Model Column

Question

I'm not sure why it happened, but one of the columns starts with a capital letter. I'm a little worried to change it by doing migrations because the affected column is 'comment_id' column, and Comment is this model's parent.

 id | has_voted | Comment_id | created_at | updated_at
----+-----------+------------+------------+------------
(0 rows)

this belongs to comment model. Is it okay to drop Comment_id and simply adding comment_id column by generating new migrations? Or should I fix it somewhere else?

If you drop the column, the data in it will be lost (unless you copy it first). — Sergio Tulentsev
– Sergio Tulentsev, Commented Nov 21, 2012 at 9:27
It's okay since I don't have any data yet. So would it be okay to drop it and add the correct column in this case? — Maximus S
– Maximus S, Commented Nov 21, 2012 at 9:30
Or you could just rename the column: api.rubyonrails.org/classes/ActiveRecord/Migration.html. I'm not sure how it will work in this case. Are column names case-sensitive? — Sergio Tulentsev
– Sergio Tulentsev, Commented Nov 21, 2012 at 9:32

Community · Accepted Answer · 2017-05-23 12:22:56Z

2

You can generate a new migration file:

  rails g migration FixColumnName

Now, edit the file ../migrate/fix_column_name.rb and change the table_name for the real name of your table.

  class FixColumnName < ActiveRecord::Migration
    def change
    rename_column :table_name, :Comment_id, :comment_id
    end
  end

source: How can I rename a database column in a Ruby on Rails migration?

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Nov 21, 2012 at 9:38

gabrielhilal

10.8k8 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails: Editing Model Column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related