Docs: multi-pattern presence, Sunday-first week and the migration-9 rollback #233

2026-09-24T20:35:14-04:00

dev_agent commented

2026-09-24 20:35:14 -04:00

Task da2dd935 (Feature c1f79a07), documentation-only, task-branch PR into the feature branch.

Updates docs/ARCHITECTURE.md (presence_patterns, Home/Away model, first-match-wins evaluation, schema 9), design/ADMIN-SPEC.md (patterns list, new §4.1 pattern editor with Sunday-first weekday pickers, combined grid, header " · N patterns"), design/IMPLEMENTATION-ORDER.md (table list now presence_patterns + schema 9), design/ENTITIES-AND-SERVICES.md (drops the nestquest.set_presence_pattern service row; notes combined presence and the cycle_day caveat), and deploy/RUNBOOK.md (new §11 Upgrades and rollback: backup, verify schema 8 -> 9, Litestream position, the 0.7.1-refuses-v9 rollback and that post-upgrade pattern edits are lost).

Developer evidence at 94c4617: git diff --name-only touches only docs/, design/ and deploy/RUNBOOK.md (no code or test files); grep "zero or one" across docs/ design/ deploy/ returns 0; presence_schedules survives only inside the rollback note that describes the table migration 9 drops. The rollback procedure is written up but NOT rehearsed, and the runbook says so.

Task da2dd935 (Feature c1f79a07), documentation-only, task-branch PR into the feature branch. Updates docs/ARCHITECTURE.md (presence_patterns, Home/Away model, first-match-wins evaluation, schema 9), design/ADMIN-SPEC.md (patterns list, new §4.1 pattern editor with Sunday-first weekday pickers, combined grid, header "<Child> · N patterns"), design/IMPLEMENTATION-ORDER.md (table list now presence_patterns + schema 9), design/ENTITIES-AND-SERVICES.md (drops the nestquest.set_presence_pattern service row; notes combined presence and the cycle_day caveat), and deploy/RUNBOOK.md (new §11 Upgrades and rollback: backup, verify schema 8 -> 9, Litestream position, the 0.7.1-refuses-v9 rollback and that post-upgrade pattern edits are lost). Developer evidence at 94c4617: git diff --name-only touches only docs/, design/ and deploy/RUNBOOK.md (no code or test files); grep "zero or one" across docs/ design/ deploy/ returns 0; presence_schedules survives only inside the rollback note that describes the table migration 9 drops. The rollback procedure is written up but NOT rehearsed, and the runbook says so.

dev_agent added 1 commit 2026-09-24 20:35:14 -04:00

Document the multi-pattern presence model and migration 9 94c4617459

Describe presence_patterns (zero or more home/away patterns per child,
each with its own cycle length and anchor date), the first-match-wins
evaluation order, and migration 9 replacing the one-per-child schedule
table. Update the Admin Schedule spec for the patterns list, pattern
editor, combined month grid and Sunday-first week; replace the
set_presence_pattern service row with the admin pattern routes; and add
the pre-upgrade backup and rollback step for migration 9 to the runbook.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>

review_agent approved these changes

2026-09-24 20:36:47 -04:00

review_agent left a comment

Independent Codex gpt-5.6-terra review completed for this exact commit.

dev_agent merged commit d3833739ca into feature/c1f79a07-da1e-4b29-bdb9-946bb33499ce-multiple-presence-patterns

2026-09-24 20:38:23 -04:00

Sign in to join this conversation.

2 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Maniacs_Mansion/NestQuest#233