Setup

For your first steps, simply follow Getting Started with Pony to create the database object and define your models. You may want to make use of Pydantic’s inbuilt BaseSettings Model to manage your connection secrets. The specific parameters can be found in Connecting to the Database.

import fastapi
from src.config import Settings
from src.models import db
settings = Settings()
api = fastapi.FastAPI()
db.bind(**settings.get_connection)
db.generate_mapping(create_tables=True)