Please note, this current implementation is not closing database connections

correctly. My understanding is it is the way SQLAlchemy and FastAPI are designed. I have found two post that talk about it sqlalchemy/sqlalchemy#6594 fastapi/fastapi#726 - This post suggest using SQLAlchemy's async mode, but I am unable to get the version of asyncpg to install correctly.

Setting up a development evvironment on a mac....

I prefer to use brew, so brew update brew upgrade - if needed brew search python brew install python3

I create an alias so I can just type python and it runs python3

Create a Python Virtual Environment to isolate dependencies python -m venv my_env so in our case, I would suggest python -m venv py-api Now activate the Virtual Environment source py-api/bin/activate

Now install the packages in the requirements.txt file pip install -r requirements.txt

If you have trouble with psycopg2-binary, do the following: brew install postgresql brew install openssl brew link openssl

export LDFLAGS="-L/opt/homebrew/opt/[email protected]/lib" export CPPFLAGS="-I/opt/homebrew/opt/[email protected]/include"

rerun the pip install -r requirements.txt

For now, to start the app Start database using 'docker compose up' Start the Uvicorn server "python ./src/main.py"

Look at the Swagger ( provided by fastapi) 
http://localhost:9000/docs

( fastapi is built on top of OpenAPI standard, alt. will contain JSON schemas of our Pydantic models )
Alternative 
http://localhost:9000/redoc

The application expects the following environment variables to be set, otherwise it will use defaults:

db_host = os.environ.get('DB_HOST', 'localhost')
db_port = os.environ.get('DB_PORT', '5432')
db_name = os.environ.get('DB_NAME', 'artist_db')
db_user = os.environ.get('DB_USER', 'root')
db_pass = os.environ.get('DB_PASS', 'root')
api_port = os.environ.get('PORT', '9000')

Note the database defaults correspond to the values in the docker_compose.yml

Trying to run pydantic-docs datamodel code generator on the openapi.json

model1.py is generated off of the above... It is not currently being used in the code.