Is there any tip for unit testing with drizzle?

I'm trying to write unit test code with drizzle, but I have no idea how to write create statement with rollback.
  • Using transaction for rollback could be a way, but I think it's too complicated for testing.
  • Drizzle instance is too complicated to mock.
  • I also have thought about creating repository class, but I don't think repository can handle complicated query (like query with join).
Can I get any advice?
Was this page helpful?