Migrating data to multiple tables?

Rails
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.

±—±----------±--------+
| id | client_id | address |
±—±----------±--------+
| 33 | 1 | 1 |
| 34 | 2 | 2 |
| 35 | 3 | 3 |
| 36 | 1 | 4 |
±—±----------±--------+

Now this db has been through a number of migrations, both forward and
backwards (Version=0).
Is this something I’m overlooking in Rails or is this a MySql problem?

thanks
Jeffrey

2

This happened to me once, I didn’t know what to do also :slight_smile:

But as “Dan M.” said, if you drop your table the auto increment will
reset to ZERO again.

3

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 M.
http://www.dcmanges.com