Re: [Zope] Getting a Mysqldb.Connection objetct form ZMySAQLDA
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 )
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@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
participants (2)
-
Gilles Lenfant -
Martin Gebert