On Sat, 29 Jan 2005 13:21:14 +0100 Federico Di Gregorio <[EMAIL PROTECTED]> 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] _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
