How do I mock a database? Pytest Mocking Tutorial

Here I give a few example use cases for mocking SQLAlchemy that I have had to use in my day to day as a software engineer.

Useful resources:

Cheatsheet:

[cristianbautistamartinez]

Good video! It is good that you share your knowledge sir.
Just as an advice, I think it would be better if you explain step by step how to mock DB connections because there are just some few youtube videos related to that.
And you would make a big change/impact if you create a video collection dedicated to this.
Thanks in advance!
Kind regards

[diegofernandopalacioshoyos]

Very good video, but I have some doubts, could you share the repository to see the configuration in more detail?

[manvityagi]

Thank you so much for sharing this tutorial! Saved me some headbangs!

[chriskeo]

👋 awesome, video

I found this a bit advanced.

Possible to make a beginner approach to this subject?

[Lina-eevt]

It does not work for me . I got thsi error: RuntimeError: Either 'SQLALCHEMY_DATABASE_URI' or 'SQLALCHEMY_BINDS' must be set."

[MichaelGuglielmo-uqko]

This helped me. Thank you. Except:


should be replaced with:


as it looks like _QueryProperty has been moved into model

[mosesontheweb]

Hi, this is an excellent example, however, it would be great if you can share this sample code. There’s no Medium link in the description.