[Twisted-Python] problems w/ pyPgSQL and the Enterprise HOWTO

Jp Calderone exarkun at intarweb.us
Mon Feb 24 14:00:29 EST 2003

On Mon, Feb 24, 2003 at 03:18:02PM +1100, Andrew Bennetts wrote:
> On Sun, Feb 23, 2003 at 09:20:23PM -0600, Justin Ryan wrote:
> > 
> > > [snip]
> >
> > Is the qmarks paramstyle a required part of the DB API 2.0 spec?
> No, it's even worse than that: DB API 2.0 doesn't specify which paramstyle
> to use, it merely states that possible values are "qmark", "numeric",
> "named", "format", and "pyformat".  So a DB API 2.0-compliant module is free
> to implement any of these it feels like, so long as it sets the correct
> paramstyle for it.  Thus they've defined a spec which allows 5 incompatible
> flavours.  As far as I can see, the only portable way to write queries is to
> format the queries yourself, which means handling correct quoting yourself.
> Yuck.

  It occurs to me that this might be a useful place to apply localization,
gettext style. ;)  Now, if only there were an LC_SQL variable...


"Pascal is Pascal is Pascal is dog meat."
                -- M. Devine and P. Larson, Computer Science 340
 up 15 days, 22:29, 4 users, load average: 0.03, 0.01, 0.00
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://twistedmatrix.com/pipermail/twisted-python/attachments/20030224/3ff56f05/attachment.pgp 

More information about the Twisted-Python mailing list