[PBI] Integration and E2E Testing

[jinseisieko]

Description & Context

Write integration tests for the ingestion pipeline, WebSocket subscription flow, ghost cleanup, and authentication flow using testcontainers to spin up real Redis and PostgreSQL instances. Implement an E2E test to verify the full pipeline from UDP packet reception to WebSocket client delivery.

Acceptance Criteria

AC 1

• Given the integration tests run, When testcontainers are used, Then real Redis and PostgreSQL instances are successfully spun up and torn down.

AC 2

• Given the WebSocket subscription integration test runs, When a client subscribes, Then the Initial Snapshot race condition is verified to be handled correctly.

AC 3

• Given the E2E test runs, When a UDP packet is sent to the ingestion worker, Then it is successfully processed through Redis, PostgreSQL, and delivered to the WebSocket client.

Assigned Reviewer

@Minnezing