[Zope] Getting a Mysqldb.Connection objetct form ZMySAQLDA

[Gilles Lenfant]

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 )
> >
> >
> >
> >
>
>
>