Fix FastAPI Booking Database Error

Заказчик: AI | Опубликовано: 26.12.2025
Бюджет: 150 $

My production stack is built on Python 3.11 with FastAPI served by Uvicorn, async-SQLAlchemy talking to PostgreSQL (asyncpg/psycopg2), Celery + Redis, Docker / Docker-Compose, and Nginx in front. Everything was stable until I recently re-uploaded the application files; since then the booking engine throws a database error and the room-availability page no longer loads. Priority one is to track down and eliminate that database error so the booking engine works again. The schema itself has not changed, so I suspect a mismatch in SQLAlchemy models, a bad migration, or a mis-configured connection string inside the Docker images. You will have full SSH and docker-compose access to the server (Ubuntu 22.04). Once the booking flow is healthy, I also need a tiny UI tweak: there is a misspelled menu item that simply needs correcting in the front-end (Next 15.5.7). Deliverables • Diagnose and resolve the FastAPI ⇄ PostgreSQL error so available rooms display correctly. • Prove the fix by completing a test booking end-to-end. • Correct the single typo in the navigation menu and push the change. • Supply a concise report of what was broken and what you changed (git diff or patch notes are fine). If you are comfortable debugging async SQLAlchemy within Docker and can turn this around quickly, I’d love your help today.