Rockachopa/Timmy-time-dashboard
1
0
Fork 2
Code Issues 7 Pull Requests Actions Packages Projects Releases Wiki Activity

[loop-generated] [feature] Provider health history endpoint #457

New Issue
Closed
opened 2026-03-19 18:38:22 +00:00 by Timmy · 1 comment
Timmy commented 2026-03-19 18:38:22 +00:00
Owner
Copy Link

What

Time-series provider health data for dashboard visualization.

Why

CascadeRouter only exposes current snapshots. No history.

Acceptance criteria

  • GET /api/v1/router/history?hours=24
  • Timestamped snapshots of provider status/latency/error rate
  • SQLite storage, background task every 60s
  • Unit tests

Files

  • src/infrastructure/router/history.py (new)
  • src/infrastructure/router/api.py
  • tests/infrastructure/test_router_history.py (new)
## What Time-series provider health data for dashboard visualization. ## Why CascadeRouter only exposes current snapshots. No history. ## Acceptance criteria - GET /api/v1/router/history?hours=24 - Timestamped snapshots of provider status/latency/error rate - SQLite storage, background task every 60s - Unit tests ## Files - src/infrastructure/router/history.py (new) - src/infrastructure/router/api.py - tests/infrastructure/test_router_history.py (new)
Timmy commented 2026-03-19 18:54:54 +00:00
Author
Owner
Copy Link

Implementation Instructions\n\n1. Create src/infrastructure/router/history.py:\n - HealthRecorder class with SQLite backend (use data/router_health.db)\n - Background async task (every 60s) that snapshots current provider status from CascadeRouter\n - Store: timestamp, provider_name, is_healthy, latency_ms, error_rate, circuit_state\n - get_history(hours=24) method returning list of snapshots\n\n2. Add endpoint in src/infrastructure/router/api.py:\n - GET /api/v1/router/history?hours=24\n - Returns JSON array of timestamped health records\n\n3. Tests in tests/infrastructure/test_router_history.py:\n - Test recording snapshots\n - Test retrieval with time filtering\n - Test SQLite creation\n\nKeep it simple. Use aiosqlite or plain sqlite3. The CascadeRouter already has get_metrics() — use that as the data source.

## Implementation Instructions\n\n1. Create `src/infrastructure/router/history.py`:\n - `HealthRecorder` class with SQLite backend (use `data/router_health.db`)\n - Background async task (every 60s) that snapshots current provider status from CascadeRouter\n - Store: timestamp, provider_name, is_healthy, latency_ms, error_rate, circuit_state\n - `get_history(hours=24)` method returning list of snapshots\n\n2. Add endpoint in `src/infrastructure/router/api.py`:\n - `GET /api/v1/router/history?hours=24`\n - Returns JSON array of timestamped health records\n\n3. Tests in `tests/infrastructure/test_router_history.py`:\n - Test recording snapshots\n - Test retrieval with time filtering\n - Test SQLite creation\n\nKeep it simple. Use aiosqlite or plain sqlite3. The CascadeRouter already has `get_metrics()` — use that as the data source.
kimi was assigned by Timmy 2026-03-19 18:54:54 +00:00
kimi was unassigned by Timmy 2026-03-20 20:02:23 +00:00
hermes was assigned by Timmy 2026-03-20 20:02:23 +00:00
Timmy closed this issue 2026-03-20 20:09:22 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
222-epic
Workshop: Timmy as Presence (Epic #222)
 actionable
Has a concrete code/config task extracted
 assigned-claude
Issue currently assigned to Claude agent — do not assign to another agent
 assigned-gemini
Issue currently assigned to Gemini agent — do not assign to another agent
 assigned-groq
assigned-kimi
Issue currently assigned to Kimi agent — do not assign to another agent
 assigned-manus
Issue currently assigned to Manus agent — do not assign to another agent
 claude-ready
consolidation
Part of a consolidation epic
 deprioritized
Keep open but not blocking P0 work
 deprioritized
Keep open but not blocking P0 work
 duplicate
Duplicate of another issue
 gemini-review
Auto-generated by Gemini, needs relevance review
 groq-ready
harness
Core product: agent framework, heartbeat, inference, memory
 heartbeat
Harness: Agent heartbeat loop
 inference
Harness: Inference and model routing
 infrastructure
Supporting stage: dashboard, CI/CD, deployment, DNS
 kimi-ready
Scoped and ready for Kimi to pick up
 memory-session
Harness: Memory and session crystallization
 morrowind
Harness: Morrowind embodiment
 needs-design
Needs architectural design before implementation
 needs-extraction
Philosophy with unextracted engineering work
 p0-critical
Priority 0: Must fix now
 p1-important
Priority 1: Important, next sprint
 p2-backlog
Priority 2: Backlog, do when time permits
 philosophy
Philosophical foundation — informs architecture decisions
 rejected-direction
Closed: rejected or superseded direction
 seed:know-purpose
Three Seeds: KNOW YOUR PURPOSE
 seed:serve-real
Three Seeds: SERVE THE REAL
 seed:tell-truth
Three Seeds: TELL THE TRUTH
 sovereignty
Harness: Sovereignty stack
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
Timmy claude grok groq kimi manus perplexity Rockachopa
No Assignees hermes
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Rockachopa/Timmy-time-dashboard#457
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?