Gilles Lenfant schrieb:

> Martin,
> 
> Yes, it would be very useful to get a DB API compliant Connection object
> from a Zope DA. There are so many "goodies" for Python I can get from a
> MySQLdb.Connection object that are not available from a ZMySQLDA.
> 
OK, what about using an External Method importing MySQLdb then?

> The SQL query is built dynamically in a method of a Python product. I really
> need this to get from the cursor object some data I *cannot* get from ZSQL
> method (like the last autoincrement insert row).
> 
select last_insert_id() as ID

works for me.

> It's very shorter to write...
> cursor = dbconnect.cursor()
> cursor.execute("update mytable...", (data, data...))
> 
??? Short? OK, call me a newbie, but I've come across no update 
statement so far which I couldn't comfortably code in a Z SQL method. 
Maybe you could explain in more detail what magic you're up to?

> Using the method you suggest is overkill. (why make it simple when you can
> have it complicated :-)
> 
Hm, I'd see it the other way round (Cursor coding in Python more 
complicated than using Z SQL/DA), but if you think so...

> Okay, I'm gonna parse the ZMySQLDA connection string to get my own DB API
> Connection object.
>   
> 
You can get the Connection String from the connection_string attribute 
of your ZMySQL instance.

> Cheers
> 
> --Gilles
> 
> PS : please CC your replies to zope@[...].org
> 
Sorry, I forgot. I'm pampered from the german DZUG list which sets a 
"Reply to" automatically on every mailing... *big hint for the list 
admins* ;-)

Martin



_______________________________________________
Zope maillist  -  Zope@[...].org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )