Traditionally, in these cases, you use a test database with sample data (fixtures) to test that the output depends on the db data in the right way.