Unit Testing Database Access

Unit testing is all well and good until you start processing lots of data from databases or the like. At this point, you want to assert that your results are as you expect. The problem here is that it is obviously a pain to type out the list of lists or dictionaries that are returned where you are more likely to make a mistake in transferring it to code.
more...