search

czbiohub-sf / Rapid-QC-MS

Realtime quality control for mass spectrometry data acquisition
https://czbiohub-sf.github.io/Rapid-QC-MS
Other
13 stars 2 forks source link

apostrophe's in instrument names potentially cause sql errors #85

Closed InventoRyAlpaca closed 11 months ago

InventoRyAlpaca commented 11 months ago

need to add a check \ disclaimer

InventoRyAlpaca commented 11 months ago

Can confirm

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "s": syntax error [SQL: SELECT * FROM instruments WHERE name='Bobby's drop tables']

InventoRyAlpaca commented 11 months ago

Fixed in commit https://github.com/czbiohub-sf/MS-AutoQC/commit/3f728018adc44f50de21baa867ae13b485736916