#648 Changing a field ending in id and renaming it, removes the id column in migrations - Hobo

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

#648 ✓invalid

Changing a field ending in id and renaming it, removes the id column in migrations

Reported by Kieran P | March 1st, 2010 @ 11:53 PM

Changing a field ending in id and renaming it, removes the id column in migrations

Here is basically what I did:

script/generate JobAssignment job_id:integer user_id:integer
script/generate hobo_migration (generate and migrate)

[
  change JobAssignment.rb and renamed user_id to staff_id
  also add:  belongs_to :staff, :class_name => "User", :foreign_key => :id
]

script/generate hobo_migration (enter staff_id to rename then migrate

Result:

SQLite3::SQLException: duplicate column name: id: ALTER TABLE "job_assignments" ADD "id" integer

Cause:

The following is in the migration:

rename_column :job_assignments, :user_id, :staff_id
add_column :job_assignments, :id, :integer

Notice that it makes the id column again, yet it already exists as evident from the SQL error.

Comments and changes to this ticket

Matt Jones March 3rd, 2010 @ 02:42 AM
Those belongs_to in your examples are incorrect - :foreign_key specifies the name of the field on the object declaring belongs_to, not on the associated object. So in your Project example above, projects.client_id refers to clients.id (using DB field names). What exactly are you trying to achieve with :foreign_key here?
Matt Jones September 14th, 2011 @ 09:42 PM
- State changed from “new” to “invalid”
- Milestone order changed from “0” to “0”

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.