On Thu, Apr 27, 2006 at 02:30:00PM +0200, Davide Alberani wrote:
> It seems that there are no other ways, besides the extraction
> of a cursor, to directly use the executemany() method - and deal
> with inconsistent parameter styles. :-/
You may also try to make a generic patch for SQLObject to use
executemany().
> PS: only to satisfy my curiosity: the fact that the
> connection = connectionForURI('postrges://...')
> connection.sqlrepr(sqlbuilder.Insert(..., valueList=[{...}, {...}]))
>
> commands return a SQL statement that is not valid for a
> PostgreSQL database is a bug or I have misunderstood its usage?
Insert() doesn't check if the arguments are suitable for a concrete DB.
The responsibilty is on the user. Again, patches with tests will be gladly
accepted.
For Postgres the usage is
connection.sqlrepr(sqlbuilder.Insert(..., values={...}))
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
