Foreign Keys and Testing

Rails
#1

I recently started an application that is using foreign key
constraints in the database. How do I get these constraints to be
placed in the test database to ensure that my tests are running on the
same schema that my application is?

Thanks,
Alex

#2

Alex Kroman wrote:

I recently started an application that is using foreign key
constraints in the database. How do I get these constraints to be
placed in the test database to ensure that my tests are running on the
same schema that my application is?

The foreign_key_migrations plugin [1] will make this happen for you, if
you create foreign keys using migrations like that plugin prescribes.

[1] http://www.redhillonrails.org/

–
Roderick van Domburg
http://www.nedforce.nl