Hi all,
After upgrading to RC4 all my test’s fail with errors similar to the
following:
ActiveRecord::StatementInvalid: Cannot delete or update a parent
row: a foreign key constraint fails: DELETE FROM developers
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/connection_adapters/abstract_adapter.rb:67:in log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/ active_record/connection_adapters/mysql_adapter.rb:155:inexecute’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/connection_adapters/mysql_adapter.rb:179:in delete' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/ active_record/fixtures.rb:279:indelete_existing_fixtures’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/fixtures.rb:252:in `create_fixtures’
It’s obvious that the FK constrains is preventing Rails from cleaning
up the DB tables after a test, but I don’t know what to do about it.
Further confusing the issue is I set “use_transactional_fixtures” to
true, so it doesn’t make sense to me why Rails would need to clean
out the DB after each test (since I thought it would just roll back).
Any help would be greatly appreciated.
Thanks!
–Dave.