[DB-SIG] In praise of pyformat

[Paul Boddie]

On Monday 13 August 2007 14:16, Carsten Haese wrote:
> On Sun, 2007-08-12 at 20:34 +0200, Paul Boddie wrote:
> > Meanwhile, we still need a better way of dealing with parameters. Having
> > a database module tell me at runtime that its paramstyle is "xyz" is not
> > particularly useful if I've already written my queries
>
> True. That's why we decided not too long ago to make qmark and named
> mandatory in the next version of DB-API.

It isn't me that needs convincing. ;-)

I've uploaded a new version of sqlliterals which has a replace function for 
the conversion of favourite paramstyles to "legacy" paramstyles in SQL 
statements:

http://www.python.org/pypi/sqlliterals

Paul