Re: API 3.0 limiting paramstyle to ['named', 'qmark'] is okay. ('format' is not desirable)
Michael Bayer <[email protected]>
| Newsgroups | gmane.comp.python.db |
|---|---|
| Message-ID | <[email protected]> |
On May 17, 2013, at 12:33 PM, Christoph Zwerschke <[email protected]> wrote: > Am 17.05.2013 18:21, schrieb Daniele Varrazzo: > > Quite the contrary: the quotes should never appear in the query and > > these examples are correct but... > > Just tested this with psycopg2. If you use the clause "WHERE name=%s" and pass a value without quotes, you get a ProgrammingError from the database. So is psycopg2 not properly implementing DBAPI 2? right, did you pass any parameters to execute()? I believe if no parameters are present, it decides not to do the "%" operation. Other DBAPIs that don't use format/pyformat don't have this behavior. _______________________________________________ DB-SIG maillist - [email protected] http://mail.python.org/mailman/listinfo/db-sig