FastAPI Product API Development

I’m extending a web application and need a focused FastAPI backend that handles all product-related operations. The service must expose clean, REST-style endpoints so the front-end can create new products, update existing entries, fetch single or multiple records, and delete items when required.

You’ll receive the PostgreSQL schema and a rough data model. From there, please wire up an asynchronous FastAPI service—feel free to use SQLAlchemy (async), Tortoise ORM, or another idiomatic option—along with Pydantic models for strict request and response validation. Proper status codes, error handling, and auto-generated Swagger/OpenAPI docs should come baked-in.

Deliverables
• Endpoint implementations for create/update, retrieve, and delete product data
• Pydantic schemas and validation logic
• Async database layer connected to the provided schema
• Dockerfile and requirements.txt for one-command startup
• Source code in a clean, review-ready pull request

I’ll run my unit tests against the PR, and once everything passes, we’re good to go.