GrottoCenter / grottocenter-api / 25396598633

87%

develop: 87%

push

github

fix(entrance): resolve permanent delete FK violations and preserve audit history

- Parallelize sub-entity deletes for ~100x performance improvement
- Make notification fire-and-forget to unblock response
- Fix FK violations: clean up exit references, junction tables, and
  history table FKs using raw SQL (Waterline silently fails on
  composite-PK models)
- Preserve h_ rows for auditability instead of deleting them
- Add SQL migration to drop h_* parent FK constraints that block
  permanent deletes (aligns dev/test with production behavior)
- Add structured audit logging with entity IDs
- Add comprehensive auditability test covering all entity types,
  junction tables, and cave cascade
- Fix cave delete: use raw SQL for junction cleanup, fire-and-forget
  notifications, parallelize operations
- Extract subEntityDelete to module scope, fix entranceId type coercion

3016 of 3616 branches covered (83.41%)

Branch coverage included in aggregate %.

32 of 35 new or added lines in 4 files covered. (91.43%)

6223 of 7035 relevant lines covered (88.46%)

52.57 hits per line