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

[Jp Calderone]

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...

  Jp

-- 
"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: </pipermail/twisted-python/attachments/20030224/3ff56f05/attachment.sig>