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. 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). It's very shorter to write... cursor = dbconnect.cursor() cursor.execute("update mytable...", (data, data...)) Using the method you suggest is overkill. (why make it simple when you can have it complicated :-) Okay, I'm gonna parse the ZMySQLDA connection string to get my own DB API Connection object. Cheers --Gilles PS : please CC your replies to zope@zope.org ----- Original Message ----- From: "Martin Gebert" <Murphy@members.netsolution-net.de> To: "Gilles Lenfant" <gilles@pilotsystems.net> Sent: Monday, December 16, 2002 5:02 PM Subject: Re: [Zope] Getting a Mysqldb.Connection objetct form ZMySAQLDA
AFAIK ZMySQLDA uses the underlying _mysql class directly, not the Python DB API compliant MySQLdb class (any votes against that?). What's the problem with your query string? Why can't you use Z SQL Methods? You know you can build the SQL statements with DTML constructs?
Martin
Gilles Lenfant schrieb:
Hi,
Is it possible to get a MySQLdb.Connection object from a ZMySQLDA object ? I need this because my Python product builds the query string dynamically and a ZSQL Method is not suitable for this. Or should I parse the connection string and build my own Connection object ?
Thanks in advance for your help
--Gilles
_______________________________________________ Zope maillist - Zope@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 )