Safe sqlite3 queries

[poautran]

In GitLab by @woutdenolf on Oct 24, 2022, 17:40 GMT+2:

Use

https://docs.python.org/3/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries

here

https://gitlab.esrf.fr/workflow/ewoks/ewoksutils/-/blob/main/src/ewoksutils/sqlite3_utils.py

Migrated from GitLab: https://gitlab.esrf.fr/workflow/ewoks/ewoksutils/-/issues/1

[poautran]

In GitLab by @woutdenolf on Oct 24, 2022, 17:42 GMT+2:

Any API changes will affect ewokscore and ewoksjob

[poautran]

In GitLab by @loichuder on Mar 28, 2025, 11:31 GMT+1:

Perhaps easier to use https://redirect.github.com/sqlalchemy/sqlalchemy instead of sanitizing the queries ourselves

It has no deps except typing extensions ?

[poautran]

In GitLab by @loichuder on Apr 3, 2025, 08:46 GMT+2:

After discussion, since ewoksutils is such a core dep, we should never add more dependencies than needed.