Amadeus PNR Monitoring & Fare Automation System

We need a Python-based automation system to monitor and process ~10 airline bookings/PNRs per day using Amadeus (read-only operations).

Core Requirements:

* Automate login and navigation in Amadeus using Playwright (browser automation)
* Scan PNR queues and extract booking/fare details
* Identify ticketed vs unticketed PNRs
* Run scheduled checks (cron or background worker)
* Store data in a database (SQLite or PostgreSQL)
* Generate simple reports (Excel or dashboard optional)

Technical Stack:

* Python (core backend logic)
* Playwright (browser automation)
* PostgreSQL/SQLite (data storage)
* Optional: FastAPI for API/dashboard
* Optional: LLM integration for edge-case interpretation

Scope:

* Small-scale system (~10 PNRs/day)
* Read-only automation only (no ticketing, cancellation, or modifications)
* Must be stable and handle session/timeouts reliably

Deliverable:

A working automation system that can run daily, extract PNR status and fare information, and store results for reporting/monitoring.

Notes:

* Prefer clean, maintainable code with clear structure
* Reliability is more important than advanced features
* Experience with browser automation is essential