We have our main app skeleton, but need to begin building infrastructure to tie in a database
Definition of Done
SQLAlchemy is installed and requirements.txt is updated
new db.py (or database.py) file is created with initial configuration to link SQLAlchemy with a localhost postgresql database
*note that the SQLAlchemy models and Pydantic Schema will all be completed in future issues and that we will be using Alembic for migrations, so no need to have those parts setup in this issue
Engineering Details
There's a great guide in the FastAPI docs for setting up any SQL db with SQLAlchemy, I suggest going through this for the install and initial configuration (also, I find it very helpful to poke through this demo app that FastAPI points to in their docs that has Postgres configured well - although with a different ORM, but same general philosophy).
Context
We have our main app skeleton, but need to begin building infrastructure to tie in a database
Definition of Done
*note that the SQLAlchemy models and Pydantic Schema will all be completed in future issues and that we will be using Alembic for migrations, so no need to have those parts setup in this issue
Engineering Details