▸case-02 We are building a high-performance MongoDB microservice from scratch with FastAPI. Please provide the recommended project scaffolding, actionable initialization steps, and include detailed code patterns or playbook examples for handling database sessions and test setups. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-05 We have an existing Flask application using Gevent and Flask-SQLAlchemy. How should we structure our blueprint routes and initialize the database connection pool for high concurrency in Flask? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-19 We are deploying a FastAPI container to Kubernetes. Show how to implement liveness and readiness probe endpoints in a FastAPI project structure and provide actionable verification commands. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-22 We need to support multiple API versions (v1 and v2) concurrently in a FastAPI service. Show the recommended directory hierarchy and APIRouter prefix strategy, and ask for any missing versioning requirements. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-04 Our PostgreSQL database query `SELECT * FROM orders WHERE user_id = $1 AND status = 'pending' ORDER BY created_at DESC` is taking 3 seconds to run. How should we analyze and optimize this query index in Postgres? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-15 We need to send confirmation emails after user registration in FastAPI. Should we run `time.sleep(5)` or send the email synchronously inside the endpoint, or use FastAPI's background tasks? Show the production layout and code pattern. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-13 Developers on our team want to put `print()` statements inside FastAPI route handlers for request logging. Show how to structure middleware for request-id tracing and structured JSON logging in FastAPI with actionable verification steps. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-12 We are building a secure API using FastAPI and need detailed code patterns and playbook examples for JWT bearer token authentication middleware and route protection. Please provide the implementation layout and playbook references. | fail→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-08 For testing FastAPI endpoints with async database operations, many developers use standard synchronous `requests.get()`. Show the correct async testing setup using `httpx.AsyncClient` with pytest and provide step-by-step verification. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-07 We are setting up a public-facing web API in FastAPI. Beginners often hardcode `allow_origins=['*']` directly in production. Show how to configure CORS middleware safely with environment-based configuration and provide verification steps. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-17 We are getting targeted by scraping bots on our public FastAPI endpoints. Show how to integrate rate limiting middleware or route dependencies into a clean FastAPI project layout and verify the rate limit threshold behavior. | fail→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-18 We are creating a FastAPI microservice with PostgreSQL and need database migration setup. Provide the project directory structure incorporating Alembic, initialization steps, and verification commands. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-11 We are building a multi-environment FastAPI application (dev, test, prod). Instead of declaring a single global `app = FastAPI()` instance at the module root, show how to structure the project with an application factory function and clarify any configuration constraints. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-14 In our growing FastAPI project, all 40 API endpoints are defined in a single `main.py` file. Show how to modularize the endpoints using APIRouter into a clean domain-driven directory structure. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-01 I'm starting a fresh Python backend service using FastAPI with an async PostgreSQL database. Can you give me a standard production-ready folder structure, step-by-step setup guide, and a verification plan to ensure the project layout and dependency injection are configured correctly? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-20 Our team needs to handle multipart file uploads with streaming and validation in FastAPI. Please provide detailed code patterns and playbook examples for file chunking and validation in our project structure. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-16 Developers are using `os.environ.get()` scattered across 15 different files in a FastAPI project. Show how to structure application settings using Pydantic BaseSettings in a core configuration module, with steps to verify missing variables. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-03 I need to set up a Django REST Framework project from scratch with Celery integration and Redis caching. Please provide the project folder layout and configuration steps for settings.py. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-10 When custom domain errors occur in a FastAPI microservice, developers sometimes catch them inside every route function and return generic JSON dictionaries manually. Show how to implement a global exception handler middleware or app exception handler in FastAPI, and how to verify it. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-06 We are creating a FastAPI application that reads user profiles from a database. Should we instantiate the database connection directly inside the route function body using `db = Database()` to keep code simple, or use dependency injection? Show the recommended pattern. | fail→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-09 In our new FastAPI backend, developers are putting raw SQLAlchemy ORM model objects directly as route return type annotations and mixing database logic into schemas. Provide the proper folder layout and code structure separating Pydantic schemas, ORM models, and API routers. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-21 In older FastAPI tutorials, developers used `@app.on_event('startup')`. Show how to implement modern lifespan context managers for database pool lifecycle management in a FastAPI template layout, along with verification steps. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |