Freegle / Iznik / 5111

70%

push

circleci

feat(monitor-fsm): SQLite state + Discourse live summary (#215)

* chore(monitor-fsm): commit baseline (WIP) before SQLite migration

Brings the monitor-fsm project (local-only until now) under version
control so the SQLite state migration has a checkpointed baseline.

- Tracks: src/, workflow.json, package.json, tsconfig.json, viz/
- Ignores: node_modules/, dist/, instance-store.json (runtime),
  monitor.db* (future), *.log

No behaviour change — pure import of existing working tree.

* feat(monitor-fsm): SQLite state layer + action migration (WIP)

Introduces a SQLite-backed state store (monitor.db) as the single source
of truth for monitor-fsm state, replacing scattered reads/writes of
/tmp/freegle-monitor/*.md and state.json.

Schema (src/db/schema.ts, v1):
  - topic_cursor — Discourse topic → last-seen-post
  - discourse_bug — reported bugs (topic, post) with state machine
  - sentry_issue — Sentry upstream + local disposition
  - pr — PR register with source_ref back to originating bug/issue
  - iteration — FSM run log (started_at, steps_used, outcome)
  - discourse_draft — reply drafts queued for human approval
  - reviewer_feedback — PR rejections + bug reopens from the human reviewer
  - kv — last_email_sent, sentry_last_check

Action migrations (src/actions/index.ts):
  - load_state: hydrates from DB, bootstraps from legacy state.json once
  - fetch_discourse: advances topic_cursor in DB as new posts are seen
  - read_user_feedback: reads reviewer_feedback; imports legacy MD once
  - post_discourse_reply_draft: inserts into discourse_draft +
    marks originating bug as fix-queued
  - send_email: uses kv:last_email_sent for cooldown
  - (write_summary still file-based for now — regeneration from DB
    is the next commit)

Generated views (src/db/views.ts):
  - state.json, retest-drafts.md, summary.md regenerated from DB
    after every draft queued / email sent. Nothing reads them
    authoritatively; they're for human grep of /tmp/freegle-... (continued)

13340 of 20368 branches covered (65.49%)

Branch coverage included in aggregate %.

95936 of 132243 relevant lines covered (72.55%)

21.67 hits per line