GrottoCenter / grottocenter-api / 26074084098

87%

push

github

fix(document): use native queries to clear junction rows on permanent delete

Waterline's collection setter (set({ [key]: [] })) via updateOne
fails silently on soft-deleted records because the default scope
excludes them. This leaves junction rows (e.g. j_document_entrance)
intact, causing FK constraint violations (23503) on the final
hard delete.

Replace with direct DELETE queries against junction tables, which
work regardless of the document's soft-delete state.

Closes #1596

3253 of 3879 branches covered (83.86%)

Branch coverage included in aggregate %.

4 of 6 new or added lines in 1 file covered. (66.67%)

6575 of 7410 relevant lines covered (88.73%)

56.39 hits per line