Joshua overseer
overseer pushed to task/d5bca74b-corrupt-db-startup at Maniacs_Mansion/NestQuest 2026-09-14 08:37:10 -04:00
0281b51676 fix: read-only corruption preflight, early-return safety path, errorcode classification, sidecar snapshot test
overseer pushed to task/d5bca74b-corrupt-db-startup at Maniacs_Mansion/NestQuest 2026-09-14 08:32:43 -04:00
c5cebc9f49 feat: handle missing, valid, and corrupt databases on startup (#22)
overseer created branch task/d5bca74b-corrupt-db-startup in Maniacs_Mansion/NestQuest 2026-09-14 08:32:43 -04:00
a887df232a test: derive occurred-at query date from the event stamp; capture generated_at at creation
6e1f22e18a fix: rollover-safe today reads under lock, INSERT INTO regex, midnight-safe dynamic dates
e48123e488 fix: immutable completed instances, no past generation, strict UTC timestamps, hardened append-only guards
overseer created branch task/a9ea75fc-dao-instances-events in Maniacs_Mansion/NestQuest 2026-09-14 08:10:43 -04:00
ea6cf73bdc feat: add typed DAO layer for task_instances and append-only completion_events (#21)
overseer pushed to task/e5c9c4ad-dao-presence at Maniacs_Mansion/NestQuest 2026-09-14 08:07:43 -04:00
9a4bf4f765 docs: correct gate comment and get_by_child cross-reference
overseer pushed to task/e5c9c4ad-dao-presence at Maniacs_Mansion/NestQuest 2026-09-14 08:06:02 -04:00
da87266c36 test: gate the child-SELECT (post-BEGIN) so the race proves an open transaction, not just a held lock
overseer pushed to task/e5c9c4ad-dao-presence at Maniacs_Mansion/NestQuest 2026-09-14 08:03:58 -04:00
4ac2bf1050 fix: unambiguous get_by_child, deterministic gated-executor race test, exact-line probe exemption
overseer pushed to task/e5c9c4ad-dao-presence at Maniacs_Mansion/NestQuest 2026-09-14 07:49:16 -04:00
a36aad36c8 feat: add typed DAO layer for presence schedules and overrides (#20)
overseer created branch task/e5c9c4ad-dao-presence in Maniacs_Mansion/NestQuest 2026-09-14 07:49:16 -04:00
caea163e17 test: race hook pauses after validation passes, before INSERT; assert create must win that ordering
3a7ab12ab2 fix: atomic assignment validation, sentinel-based clearing, strict date validation, race test both orderings
overseer created branch task/8c72300c-dao-rules-definitions in Maniacs_Mansion/NestQuest 2026-09-14 07:34:44 -04:00
46a0a3445c feat: add typed DAO layer for schedule_rules and task_definitions (#19)
overseer pushed to main at overseer/Home-Assistant 2026-09-14 07:32:19 -04:00
775b080341 Fix typo in media player name for bedtime notification automation
overseer pushed to main at overseer/Home-Assistant 2026-09-14 07:29:00 -04:00
4e2f425ed3 cleanup of ESP32 items
221160aa33 Delete respeaker-satellite-fr.yaml
e45401882b Delete polly-a1-mini-camera.yaml
28e49122b3 Delete office-jarvis-satellite.yaml
Compare 4 commits »
overseer pushed to task/4ce39f1a-dao-children-admins at Maniacs_Mansion/NestQuest 2026-09-14 07:24:58 -04:00
d8b16766e9 test: catch backtick and bracket-quoted table names in self-scan