CRUD Operations in Python

From the FastAPI cheat sheet · Database Integration · verified Jul 2026

CRUD Operations

Create, read, update, and delete records with SQLAlchemy.

python

from fastapi import Depends
from sqlalchemy.orm import Session

@app.post("/items/", response_model=ItemOut, status_code=201)
def create_item(item: ItemCreate, db: Session = Depends(get_db)):
    db_item = Item(**item.model_dump())
    db.add(db_item)
    db.commit()
    db.refresh(db_item)
    return db_item

💡 Use model_dump(exclude_unset=True) for PATCH-style partial updates

⚡ db.refresh() reloads the object from the DB — gets auto-generated fields like id

📌 Always check if the record exists before updating/deleting — raise 404 if not

🟢 Use sync def (not async def) for SQLAlchemy — it uses blocking I/O by default

cruddatabasesqlalchemy

More Python tasks

SQLAlchemy Setup

Back to the full FastAPI cheat sheet