sequenceDiagram
    participant CI as GitHub Actions
    participant PG as PostgreSQL Service
    participant O2 as OpenObserve Server
    participant PT as Pytest Tests
    participant DB as Postgres DB

    CI->>PG: start postgres service (port 5432)
    CI->>CI: build openobserve debug binary
    CI->>O2: start with ZO_META_STORE=postgres
    O2->>DB: initialize schema & tables
    CI->>O2: wait for healthz endpoint
    O2-->>CI: ready
    
    CI->>PT: run pytest tests
    
    Note over PT,DB: Test: Schema Validation
    PT->>O2: POST /api/{org}/{stream}/_json (ingest data)
    O2->>DB: create schema entries in meta table
    PT->>DB: SELECT schema FROM meta WHERE module='schema'
    DB-->>PT: return schema records
    PT->>PT: assert schema exists & contains fields
    
    Note over PT,DB: Test: Data Ingestion Count
    PT->>O2: POST /api/{org}/{stream}/_json (10 records)
    O2->>DB: persist data & metadata
    PT->>O2: POST /api/{org}/_search (query count)
    O2->>DB: query data
    DB-->>O2: return results
    O2-->>PT: search response
    PT->>PT: assert count >= 10
    
    Note over PT,DB: Test: Organization Metadata
    PT->>DB: SELECT FROM meta WHERE module='organization'
    DB-->>PT: return org metadata
    PT->>PT: assert org exists (BUG: >= 0 always true)
    
    Note over PT,DB: Test: Tantivy Indexing
    PT->>O2: POST /api/{org}/{stream}/_json (50 records with 'log' field)
    O2->>DB: write to file_list & create tantivy indexes
    PT->>PT: sleep 20 seconds (wait for persistence)
    PT->>DB: SELECT FROM file_list WHERE stream='{org}/logs/{stream}'
    DB-->>PT: return file records with index_size
    PT->>PT: assert all files have index_size > 0
    PT->>PT: assert total records == 50
    
    PT-->>CI: test results
    CI->>O2: stop server
    CI->>CI: upload logs if failure