• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

GrottoCenter / grottocenter-api / 27830320349
88%
develop: 88%

Build:
Build:
LAST BUILD BRANCH: feat/async-csv-import-queue
DEFAULT BRANCH: develop
Ran 19 Jun 2026 02:05PM UTC
Jobs 1
Files 462
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

19 Jun 2026 02:02PM UTC coverage: 87.131% (+0.07%) from 87.059%
27830320349

Pull #1691

github

ClemRz
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
Pull Request #1691: feat(substance): add t_substance reference table with PubChem integration

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

Uncovered Changes

Lines Coverage ∆ File
5
84.21
api/services/SubstanceService.js
2
94.74
api/controllers/v1/substance/create.js
2
88.89
api/controllers/v1/substance/find.js
2
90.91
api/services/PubChemService.js
Jobs
ID Job ID Ran Files Coverage
1 27830320349.1 19 Jun 2026 02:05PM UTC 462
87.13
GitHub Action Run
Source Files on build 27830320349
  • Tree
  • List 462
  • Changed 12
  • Source Changed 11
  • Coverage Changed 8
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Repo
  • Github Actions Build #27830320349
  • Pull Request #1691
  • PR Base - develop (#27829053887)
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc