Related

Database Migrations

fastapi

Use Alembic for migrations

Dependency Injection

fastapi

Use dependency injection

Create Database

mysql

Create new database

fastapi/db-session

Database Session Dependency

Create database session

di
database

Explanation

Creates and manages database sessions using dependency injection

Examples

Database session dependency

async def get_db():
      db = SessionLocal()
      try:
          yield db
      finally:
          db.close()
  
  @app.post("/users/")
  def create_user(user: UserCreate, db: Session = Depends(get_db)):
      db_user = User(**user.dict())
      db.add(db_user)
      db.commit()
      db.refresh(db_user)
      return db_user

More

SQLAlchemy Setup

fastapi

Configure SQLAlchemy ORM

Create Database

psql

Create a new PostgreSQL database

Create Migrations

django

Create database migrations