How would you test a CRUD app with a DB? The way that I do it now it's just use some simple functional test to GET / POST and measure the time in a pytest scri

How would you test a CRUD app with a DB? The way that I do it now it's just use some simple functional test to GET / POST and measure the time in a pytest script, I'm sure there are better ways to do it.