Track the processing state of each uploaded audio file (pending, processing, complete, error) to support frontend progress tracking and error handling.
Tasks
- Create a
recordings table with:
id, file_name, status, uploaded_at, completed_at, error_message, latitude, longitude
- Add service functions:
create_recording()
update_recording_status()
- On upload (
/analyze), create a recordings row with status pending
- In background task:
- Update status to
processing, then complete or error
- Add a
/recordings route to query processing states
Acceptance Criteria
- File uploads are tracked with processing status
- Frontend can query
/recordings to check state
- Failures are logged without crashing the app
Track the processing state of each uploaded audio file (
pending,processing,complete,error) to support frontend progress tracking and error handling.Tasks
recordingstable with:id,file_name,status,uploaded_at,completed_at,error_message,latitude,longitudecreate_recording()update_recording_status()/analyze), create arecordingsrow with statuspendingprocessing, thencompleteorerror/recordingsroute to query processing statesAcceptance Criteria
/recordingsto check state