Nice article! 😉

Wasn't aware of the autospec feature. It will save me some typing. Also for the SQLAlchemy it is probably preferable to use an sqlite database setup with pytest instead of mocking.

Also, I usually use pytest-mock to reduce boilerplate code when patching objects 🙂

https://pytest-mock.readthedocs.io/en/latest/