What are some examples of using ORM with FastAPI?

What are some examples of using ORM with FastAPI?

FastAPI works well with ORMs like SQLAlchemy. Would you like to see a basic example?

Yes, please provide a simple example.

Here's a basic example: First, define your SQLAlchemy model. Then, create a FastAPI endpoint to interact with it.

Can you show me the code for that?

Sure! Here's a simple code snippet:

from fastapi import FastAPI
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

DATABASE_URL = "sqlite:///./test.db"

engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()

class Item(Base):
    __tablename__ = "items"
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, index=True)

app = FastAPI()

@app.post("/items/")
def create_item(item: Item):
    db = SessionLocal()
    db.add(item)
    db.commit()
    db.refresh(item)
    return item