Another approach to this is just to set up a test database and do full integration tests. Then you can unit test most methods, and do a full integration test of all layers for things like handlers that might want database access, and you won't need any mocks at all.