migrating data to multiple tables?

rubyonrails-talk
1

Hello,

I'm trying to create a data migration for a new project I'm working on. I have numerous tables and would like to be able to populate the MySql db with test data.

I get the data to appear in the tables but the linking (has_many, has_one, etc.) don't seem to connect to each record properly. The area I'm talking about is the id field of each record. I can get the linking of the tables but the id of the records are starting from 15 of so each time.

2

Knowing what is wrong without seeing the migrations is difficult, but you can reset the auto_increment value on a table: ActiveRecord::Base.connection.execute "ALTER TABLE people AUTO_INCREMENT = 1;"

It sounds like the auto_incrementing is continuing, but that shouldn't happen if you're completely dropping your tables by going down to database version 0.

Hope that helps, Dan Manges http://www.dcmanges.com