While designing test cases for an application's database code (the data layer), I would like to determine a good subset of tests to run in order to guarantee its proper function. In essence, the goal would be to come up with the smallest set of tests that can provide the best guarantee possible of its function.
Probably, the set of tests includes simple operations (
DELETE, etc.) as well as certain combinations of operations that should work (
SELECT). It is this set of combinations that is non-trivial and of greatest interest here.
Is there a standard or best-practice set of tests that is defined for database operations? Where should I look for something like that?
Thanks very much!