Build a User Management Service with FastAPI

Problem/Feature Description

Build a user management microservice using FastAPI and Python. The service will run in Docker containers behind a Kubernetes ingress controller.

Endpoints:

• GET /api/users -- list all users (paginated)
• POST /api/users -- create a user (fields: name, email, role)
• GET /api/users/{id} -- get user by ID
• DELETE /api/users/{id} -- deactivate a user (soft delete)

Use SQLite via sqlite3 for storage. Each user has id, name, email, role, active, and created_at fields. Email must be unique.

Output Specification

Produce:

• main.py -- FastAPI application with routes and database setup
• models.py -- Pydantic models for request/response schemas
• database.py -- Database connection and initialization
• requirements.txt -- Python dependencies
• Dockerfile -- For containerized deployment