How to create test databases and connect them to the test Sanic app? about sanic-testing

[ahopkins]

I cannot advise on any best practices with an ORM, you will have to turn to them for that.

GENERALLY, I would say your testing should NOT hit any database. Instead you should use mocking to retrieve fake data in your tests. When you have to start incorporating networking calls and state management into tests it gets pretty complex quickly.

I cover some testing strategies specifically dealing with DB interactions in my book. Generally, I just point people to the companion code in GH, but I think the concepts you are aiming for are much more complex and you really should look deeper into the topic of testing. IMO the problem is in strategy not implementation.