CODEWITHSUNDEEP
ruby-on-railsactiverecord
markquezada
markquezada

Reputation: 8515

Custom non auto-incrementing ActiveRecord "id" column possible?

I'd like to be able to use a custom id (instead of the auto-incrementing default ones) for a Rails model. Basically, all the ids will be iTunes store ids, which are just long integers. Is it possible to turn off the default auto-incrementing ids and require that one be set? These ids will also be used as foreign keys in other models.

Upvotes: 5

Views: 2126

Answers (2)

Chandra Patni
Chandra Patni

Reputation: 17577

You can manually set the id before you save the model.

a = Model.new
a.id = 8888 #from itunes
a.save

However, you should consider a separate field called itunes_id instead of this approach.

Upvotes: 2

Alex
Alex

Reputation: 65944

Something like this:

create_table :blah, {:id => false} do |t|
  t.int :my_custom_int_id
end
execute "ALTER TABLE blah ADD PRIMARY KEY (my_custom_int_id);"

Upvotes: 6

Related Questions