[DB-SIG] Table Oriented Programming

Denis S. Otkidach ods at strana.ru
Sat Jan 29 15:04:38 CET 2005


On Sat, 29 Jan 2005 13:21:14 +0100
Federico Di Gregorio <fog at initd.org> wrote:

> Il giorno ven, 28-01-2005 alle 15:11 -0600, Ian Bicking ha scritto:
> > It doesn't use bound parameters like ?, instead it does all the SQL 
> > generation itself including quotation.  So it has to know what
> > database you are using to actually create the SQL, like "mysql",
> > "postgresql", etc.
> 
> This is.. er.. "horrible". PostgreSQL supports a *lot* of different
> types and the only way to support them all is to let the driver do the
> quoting (possibly with the user adding its own quoting rules, see
> PEP-246 adapt() in psycopg 2). I suppose your driver is not quoting
> PostGis or or even simple geometrical types mapped to Python
> instances, right?

AFAIK, Oleg Broytmann is working on changing SQLObject to use bound
parameters.  But there is a lot of work and probably compatibility
issues.  Anyway, builder must know database adapter to use appropriate
paramstyle.

-- 
Denis S. Otkidach
http://www.python.ru/      [ru]


More information about the DB-SIG mailing list