Should referential integrity from the database be unit tested?

Question

Lets assume I have a Customer and Order table.

When I do a Customer_Delete_Test do you also Assert if the related Orders are deleted too or

do you rely on the referential integrity between the tables like On Cascade Delete ?

score 2 · Accepted Answer · answered Feb 26 '12 at 01:14

2

I would unit test to ensure that you have constructed your database correctly and is behaving as you are expecting it to behave.

The database vendors may have done their job but that is only part of the story. Have you done yours correctly?

answered Feb 26 '12 at 01:14

Ed Heal

Of course... I should test what I setup. Guess I should not ask that late any questions ;-) – Pascal Feb 26 '12 at 11:32
2

... and I should not drink so much caffeine and I would not be up so late! – Ed Heal Feb 26 '12 at 11:46

1 Answers1