TRON-Bioinformatics / covigator

CoVigator - Monitoring SARS-CoV-2 mutations
MIT License
11 stars 1 forks source link

Avoid possible SQL injections by using placeholders #73

Closed priesgo closed 1 year ago

priesgo commented 1 year ago

Within queries.py some SQL queries are created by string formatting. This is a possible point for SQL injections. SQLalchemy uses the TextClause object for simple SQL queries. In it, you can specify placeholders that will be replaced with values from a dictionary when the query is executed using the execute method.