Hello,
My tests are messing with one another because it seems that they
aren’t cleaning the database after execution. I have the tables
headlines and articles. And the articles table has a foreign key to
the headlines table. My schema structure is created by this script
drop table if exists changes;
drop table if exists articles;
drop table if exists headlines;
create table headlines (
id int not null auto_increment,
author varchar(40) not null,
title varchar(100) not null,
happened_at timestamp not null,
reported_by varchar(40) not null,
– An id that identifies the revision to the reporter
rid varchar(40) not null,
primary key (id)
);
create table articles (
id int not null auto_increment,
headline_id int not null,
description text,
constraint fk_article_headline foreign key (headline_id) references
headlines(id),
primary key (id)
);
create table changes (
id int not null auto_increment,
article_id int not null,
summary text not null,
diff text,
constraint fk_change_article foreign key (article_id) references
articles(id),
primary key (id)
);
The Headline class declares a “has_one” relationship to the Article
class. And the Article class declares a “has_many” relationship to the
Change class. I have tests for the Article and Headline classes, and
if I run the article tests before the headline tests without
explicitly cleaning the database, I get a foreing key constraint
error. For example:
$ ruby test/unit/headline_test.rb
Loaded suite test/unit/headline_test
Started
…
Finished in 0.312 seconds.
11 tests, 14 assertions, 0 failures, 0 errors
This runs nicely. But if I had run the article tests before, I get this
$ ruby test/unit/article_test.rb
Loaded suite test/unit/article_test
Started
.
Finished in 0.203 seconds.
1 tests, 1 assertions, 0 failures, 0 errors
$ C:\devel\motiro>ruby test/unit/headline_test.rb | more
Loaded suite test/unit/headline_test
Started
EEEEEEEEEEE
Finished in 0.531 seconds.
- Error:
test_cache_already_recorded(HeadlineTest):
ActiveRecord::StatementInvalid: Mysql::Error: #23000Cannot delete or
update a pa
rent row: a foreign key constraint fails: DELETE FROM articles
The article tests use the :headlines, :articles and :changes fixtures
but the headline tests only need the :headlines and :articles
fixtures. If I add the changes fixtures to the headline tests,
everything runs smoothly. I think the database cleanup is done before
running the tests on the fixtures used for that test case only, but
because the previous test left the database dirty there are foreign
key constraints when doing this. The headline test should clean all
the three tables, but it tries to clean only those it knows about.
I have tried to use :dependent and :exclusively_dependent on the
article-change relationship, but it didn’t help.
For the sake of completeness, I am using MySQL 4.1.
Should I be doing anything differently? Do I have to use all three
fixtures on all my test cases?
Cheers,
Thiago A.