🔴 [HIGH] Setup Firestore for state management

[ucguy4u]

Description

Setup Firestore database for storing meeting metadata and processing state.

Tasks

• Design Firestore schema for meetings collection
• Design schema for processing_state collection
• Implement CRUD operations (create, read, update, delete)
• Add indexing for common queries
• Add error handling for database operations
• Test with sample data

Estimated Time

1 day

Priority

HIGH - Required for state tracking

Dependencies

• GCP project
• Firestore API enabled

Schema Design

meetings/
  {meeting_id}/
    - meeting_id: string
    - created_at: timestamp
    - audio_files: array
    - transcript_file: string
    - status: string (pending, processing, complete, error)
    - outputs: object
    - validation: object

processing_state/
  {execution_id}/
    - execution_id: string
    - meeting_id: string
    - stage: string (upload, transcribe, process, validate)
    - status: string
    - error: string (if any)

Related Files

• config/orchestration.yaml
• src/orchestration/google_cloud.py