feat(occupancy): introduce distinct MIGRATION audit action in business-day schedule audit #224

Open
opened 2026-10-03 06:54:12 +00:00 by gabogg · 0 comments
Owner

P3 follow-up from PR #178 review pass 3 (r32 item d).

Finding

Migration 20261002_holiday_backfill currently writes STAMP / CORRECTION rows in occupancy_business_day_schedule_audit. Admin manual corrections use CORRECTION. Reusing CORRECTION or STAMP blurs the provenance of schema migration backfills versus manual admin corrections or normal reset stamping.

Acceptance Criteria

  • Introduce a distinct MIGRATION action in occupancy_business_day_schedule_audit schema/domain definitions.
  • Update migration 20261002_holiday_backfill in app/db/database.py to record action='MIGRATION' when backfilling past holiday schedules.
  • Update repository audit queries and types to support the MIGRATION action.
  • Add or update migration tests to verify action == 'MIGRATION'.

Refs #178, #161.

P3 follow-up from PR #178 review pass 3 (r32 item d). ### Finding Migration `20261002_holiday_backfill` currently writes `STAMP` / `CORRECTION` rows in `occupancy_business_day_schedule_audit`. Admin manual corrections use `CORRECTION`. Reusing `CORRECTION` or `STAMP` blurs the provenance of schema migration backfills versus manual admin corrections or normal reset stamping. ### Acceptance Criteria - Introduce a distinct `MIGRATION` action in `occupancy_business_day_schedule_audit` schema/domain definitions. - Update migration `20261002_holiday_backfill` in `app/db/database.py` to record `action='MIGRATION'` when backfilling past holiday schedules. - Update repository audit queries and types to support the `MIGRATION` action. - Add or update migration tests to verify `action == 'MIGRATION'`. Refs #178, #161.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
gabogg/hikcentral#224
No description provided.