How to perform unit testing on Postgres using SQLAlchemy in Windows?
Asked Answered
J

0

7

I am working on a Flask app for APIs and created few Flask-SQLAlchemy models. I have written a function which takes a list of dictionaries and insert them into Postgres database model tables as rows using Flask-SQLAlchemy.

It's inserting the data into main Postgres database when I hit the API which calls the insertion function. Now I'm writing test cases for the insertion functionality. But I don't want to insert the data into my main Postgres database.

Instead I want to insert the data into temporary a dummy Postgres DB and also create the tables with the models that I have and insert rows into those tables.

I have gone through testing postgres db python and Python Unit Test : How to unit test the module which contains database operations? also. It didn't help much. Is there any other way to do unittesting on dummy Postgres DB using Python, Flask-SQLAlchemy?

Jemmie answered 11/9, 2019 at 8:46 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.