linnet/app/migrations/001_corrections.sql
pyr0ball 1bc47b8e0f fix: mobile tab timeout — idle session reaper + wake lock + visibility reconnect
Backend:
- Session.last_subscriber_left_at: monotonic timestamp set when last SSE subscriber
  leaves, cleared when a new one arrives
- Session.subscriber_count(): replaces len(_subscribers) access from outside the model
- session_store._reaper_loop(): kills sessions with no subscribers for >SESSION_IDLE_TTL_S
  (default 90s); runs every TTL/2 seconds via asyncio.create_task at startup
- session_store._reaper_loop_once(): single-cycle variant for deterministic tests
- app/main.py lifespan: starts reaper on startup, cancels it cleanly on shutdown
- config.py: SESSION_IDLE_TTL_S setting (90s default, overridable per-env)

Frontend:
- useWakeLock.ts: Screen Wake Lock API wrapper; acquires on connect, releases on
  disconnect; degrades silently when unsupported (battery saver, iOS Safari)
- useToneStream.ts: visibilitychange handler — on hidden: closes EventSource without
  ending backend session (grace window stays open); on visible: GET /session/{id}
  liveness check, reconnects SSE + re-acquires wake lock if alive, sets expired=true
  and calls store.reset() if reaped
- ComposeBar.vue: surfaces expired state with calm 'Session timed out' notice
  (not an error — expected behaviour on long screen-off)

Tests:
- test_reaper.py: 7 tests covering subscriber idle tracking, reaper eligibility
  (kills idle, spares active subscriber, spares within-TTL)
2026-04-11 09:42:42 -07:00

21 lines
1.3 KiB
SQL

-- Migration 001: Corrections table for tone annotation training data.
-- Users can rate annotations (up/down) and submit corrected versions.
-- Only opted_in=1 rows are exported to the Avocet SFT pipeline.
CREATE TABLE IF NOT EXISTS corrections (
id INTEGER PRIMARY KEY AUTOINCREMENT,
item_id TEXT NOT NULL DEFAULT '', -- session_id or event_id
product TEXT NOT NULL DEFAULT 'linnet',
correction_type TEXT NOT NULL DEFAULT 'annotation',
input_text TEXT NOT NULL, -- the utterance that was annotated
original_output TEXT NOT NULL, -- the LLM annotation produced
corrected_output TEXT NOT NULL DEFAULT '', -- user's correction (empty = thumbs up)
rating TEXT NOT NULL DEFAULT 'down', -- 'up' | 'down'
context TEXT NOT NULL DEFAULT '{}', -- JSON: session_id, model, elcor flag, etc.
opted_in INTEGER NOT NULL DEFAULT 0, -- 1 = user consented to share for training
created_at TEXT NOT NULL DEFAULT (datetime('now'))
);
CREATE INDEX IF NOT EXISTS idx_corrections_product ON corrections (product);
CREATE INDEX IF NOT EXISTS idx_corrections_opted_in ON corrections (opted_in);
CREATE INDEX IF NOT EXISTS idx_corrections_item_id ON corrections (item_id);