Hello!
On Fri, Aug 24, 2007 at 04:12:03PM -0500, Kevin J. Rice wrote:
> I've been playing around with the idea that maybe SQLObject could use bound
> parameters ("prepared statements") for some types of queries.
I had tried to do this in the "paramstyles" private branch; look at
_executeRetry(), _insertSQL() and _SO_update() at
http://svn.colorstudy.com/home/phd/SQLObject/paramstyles/sqlobject/dbconnection.py
Also look at
http://svn.colorstudy.com/home/phd/SQLObject/paramstyles/sqlobject/include/DBSingleStyle.py
The problems that prevented me to merge all this into SQLObject is that
different DB API drivers have many problems converting different types.
I don't remember exactly, but I think PySQLite has problems with datetime,
psycopg with mxDateTime (or vice versa).
I haven't tried to retest these drivers (even less other drivers,
especially MySQLdb), so I don't know now, they could do better conversions.
Now I have a bigger problem because the code in the trunk has changed so
much I couldn't just do "svn merge" - I have to merge things manually.
PS. This brief answer is not exactly an answer for the question you have
asked, and this is intentional. It is 2 past midnight here now, and I am
leaving the town for a weekend. I'm answering to let you know your voice is
heard. Meanwhile you can read the code, and we will continue the discussion
after I return.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
