🧾 Project Prompt (Assignment)

Modifica una de las APIs anteriores para que los datos se guarden en una base de datos SQL en lugar de memoria.

Permite consultas con filtros (por id, nombre, etc.).

Now you must persist users in a real SQL database so the API survives restarts.

Connect your Users API to SQL and implement persistence + migrations.

Requirements

• Use PostgreSQL (recommended) or SQLite (acceptable)
• Create a users table (id, name, email, role, is_active, created_at)
• Enforce unique email at the database level
• Add migrations (create table + indexes)
• Add a seed script that inserts an admin user
• Update CRUD endpoints to read/write from SQL
• Add at least 5 integration tests against the DB

🛠 Tools (Tech Stack)

• SQL (PostgreSQL or SQLite)
• ORM: Prisma (Node) or SQLAlchemy (Python) or parameterized queries
• Migration tool: Prisma Migrate / Alembic

💡 Implementation Hints

• Start with repository functions: create_user, get_user, list_users, update_user, delete_user
• Always use parameterized queries (never string concatenate SQL)