GrottoCenter / grottocenter-api / 27838584622 / 1

88%

develop: 88%

push

github

fix(substance): address code review findings on PR #1691

- Remove duplicate unique index (constraint already creates one)
- Wrap DDL sections 3-5 in BEGIN/COMMIT for atomicity
- Change external_source DEFAULT to NULL (was 'PubChem')
- Replace case-sensitive UNIQUE constraint with LOWER() functional index
- Remove dead externalSource derivation from controller
- Add length validation for formula, casNumber, externalId
- Unify create response path (201 for new, 200 for existing)

4551 of 5424 branches covered (83.9%)

Branch coverage included in aggregate %.

8568 of 9509 relevant lines covered (90.1%)

135.94 hits per line