GrottoCenter / grottocenter-api / 27830320349

88%

develop: 88%

Pull #1691

github

feat(substance): add t_substance reference table with PubChem integration

- Create t_substance table (name, formula, cas_number, external_id, external_source)
- Pre-seed 22 speleology-relevant substances with PubChem CIDs
- Add id_substance FK to t_sensor_configuration and t_time_series
- Rename substance varchar column to substance_label (denormalized for BI)
- Implement SubstanceService (local ILIKE search + PubChem fallback)
- Implement PubChemService (autocomplete + property lookup, 5s timeout)
- Add GET /api/v1/substances (public search) and POST /api/v1/substances (auth)
- Validate idSubstance in sensor config create/update (QK coupling, auto-clear)
- Propagate id_substance + substance_label through import pipeline to time series
- Update v_measurement_wide view with id_substance and bracket label format
- Return populated substance object in sensor config and device GET responses
- Capitalize first letter of substance name on create for display consistency
- Add diagnostic SQL script for manual migration of historical free-text values
- Document endpoints in Swagger and update steering file

4513 of 5402 branches covered (83.54%)

Branch coverage included in aggregate %.

132 of 143 new or added lines in 10 files covered. (92.31%)

8459 of 9486 relevant lines covered (89.17%)

136.24 hits per line