raystack / frontier / 37298120008

54%

main: 54%

Pull #1966

github

feat(store): policy create checks that the role is live inside the insert transaction

A soft-deleted role keeps its row, so the foreign key on policies.role_id no longer proves the role is live. The insert transaction now reads the role from the live rows with FOR KEY SHARE before the insert. That read waits for a role delete that is still running and returns not found once it commits, and it does not block other policy creates for the same role.

19 of 21 new or added lines in 1 file covered. (90.48%)

22505 of 41398 relevant lines covered (54.36%)

17.9 hits per line