gpt-3.5-turbo-0301· OpenAI
WildChat-4.8M (AI2)
fastapi with sqlchemy, return the total count number of row of the table
- User
fastapi with sqlchemy, return the total count number of row of the table
- Assistant
Assuming you have a SQLAlchemy model for your table, and you're using FastAPI's
SQLAlchemydependency to work with it, you could return the total count of rows in the following way:from fastapi import FastAPI, Depends from sqlalchemy.orm import Session from .database import SessionLocal from .models import MyModel app = FastAPI() # Dependency to get a database session def get_db(): try: db = SessionLocal() yield db finally: db.close() @app.get("/total_count") async def get_total_count(db: Session = Depends(get_db)): count = db.query(MyModel).count() return {"total_count": count}Here, we define an endpoint
/total_countthat returns the total count of rows in theMyModeltable. We use theDependsfunction to get a database session, and then simply call.count()on the query for theMyModeltable to get the total count.