is there a way to set the placeholder for queries in sqlite3 ? I have some functions that work with a database and it would be more satisfying if they could work both with mysql and sqlite. Mysql and Postgres python apis use the %s as a placeholder, but sqlite3 use a question mark instead.
I'm looking for a way to use the same placeholder whatever the database engine.
Thanks for your help.
The underlying library doesn't support
%s
, so it would need to be replaced manually. It might be easier to check theparamstyle
attribute and replace all instances of a different placeholder in the query with an appropriate value instead.Updated to fix my earlier error about how to use the
paramstyle
globalIf the DB modules you use follow the Python Database API Specification v2.0, you can get the module global
paramstyle
which should be any of these:You can then compose your SQL statements with the placeholder used by the module. You can do something like this: