GrottoCenter / grottocenter-api / 26074022622

87%

develop: 87%

Pull #1597

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

3246 of 3873 branches covered (83.81%)

Branch coverage included in aggregate %.

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

6570 of 7405 relevant lines covered (88.72%)

56.46 hits per line