GrottoCenter / grottocenter-api / 25120504056

86%

develop: 87%

Pull #1542

github

fix(organization): coerce empty-string coordinates to null before DB update

Empty latitude/longitude strings from the frontend caused a PostgreSQL
22P02 error (invalid input syntax for type numeric) on PUT
/api/v1/organizations/:id.

Add coerceToNumeric utility (mirrors coerceToInt) that converts empty
and whitespace-only strings to null. Apply it in
GrottoService.getConvertedDataFromClientRequest, GrottoService.createGrotto,
CaveService.getConvertedDataFromClient, and the cave update controller.

Remove the ad-hoc delete-on-empty-string hack from createGrotto.

2939 of 3552 branches covered (82.74%)

Branch coverage included in aggregate %.

12 of 14 new or added lines in 4 files covered. (85.71%)

6103 of 6923 relevant lines covered (88.16%)

94.89 hits per line