Mock a result that says "everything is OK" and continue watching Netflix.

I jest. I don't like mocking database methods, they don't give me much confidence. I test the SQL against Postgres in a Docker container.

It's ideal for testing all the negative paths, the error handling.

With a real DB it's not exactly easy to inject "ERROR: deadlock" at every single step.