[ANNOUNCEMENT] MySQLdb-0.1.2 now available
-----BEGIN PGP SIGNED MESSAGE----- After a long testing period during which nobody complained :-/, I have released MySQLdb-0.1.2, which is a DB API v2.0 compliant interface to MySQL-3.22. You can find it at: http://starship.python.net/crew/adustman/MySQLdb.html New features: - -- There is now a literal conversion dictionary which can be used to control the conversion of Python types into MySQL literals (default is to treat as a string). This results in better literal handling for numbers and user-defined objects. - -- Some of the MySQL-specific functions are now accessible directly through the MySQL Connection object. These are quite non-portable to other databases, but if you need 'em, they're now easier to get to. Zope smokers: The ZMySQLDA patch is unchanged. In fact, none of the above features affect you in the slightest, so no rush to upgrade. :) Due to time constraints, I have not been able to keep up at all with the Zope mailing list, so if there are any issues with ZMySQLDA and MySQLdb, please cc: me or write me directly. - -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or courage, come no further, for death awaits you all, with nasty, big, pointy teeth!" -----BEGIN PGP SIGNATURE----- Version: 2.6.3a Charset: noconv iQEPAwUBOKzHrxOPBZTHLz8dAQHU2wfPQGZPHRTgjKY34+/XPyYCDpH+Z2V3y/MJ uTBXTDRch9sKYMn5mvE0CuSvpZYY+zpwwMYhShRVz/EVlTEZXqQgA9fIyvQ5Rpn/ MDrYaAX968T07NYjeVfanvYzQkUrsuBfLbzFujk3vpooojP/lFSWanStKXJ2/5+z VWoUJLYX2q31dxe26Lvx2+fpLdqpn4RAkzlXLw5CzM+04s61etNbdDtWPRb386fY Zxjhw8FJg6B0zaaZ4aB/skhTGUjJ/yqzqDeq5id5Pldk2zBOmtvHXmxB1f+z56gO F8iZMNTLoP9X4cPyUWdCS2PZdbnr7QBBsIxe6lC4vcVH9Q== =ehLh -----END PGP SIGNATURE-----
Zope smokers: The ZMySQLDA patch is unchanged. In fact, none of the above features affect you in the slightest, so no rush to upgrade. :) Due to time constraints, I have not been able to keep up at all with the Zope mailing list, so if there are any issues with ZMySQLDA and MySQLdb, please cc: me or write me directly.
There was a thread awhile back about having the DA return the value of the auto_increment fields (if available) as the result set to an insert query. I suspect this is more in the code of the zope DA than the python adaptor, but if you know your way around the zope DA, perhaps you could create a patch. I made a quick attempt a while back, and failed miserably. --sam
On Fri, 18 Feb 2000, Sam Gendler wrote:
There was a thread awhile back about having the DA return the value of the auto_increment fields (if available) as the result set to an insert query. I suspect this is more in the code of the zope DA than the python adaptor, but if you know your way around the zope DA, perhaps you could create a patch. I made a quick attempt a while back, and failed miserably.
Since the patched ZMySQLDA only uses _mysql (the C interface part used by MySQLdb), you should be able to get the info you want from db.insert_id(), where db is the database connection object. Note that this will return a long integer. I don't know how you would incorporate this into ZMySQLDA, however. (The above method now works on MySQLdb connection objects as well, as of 0.1.2.) -- andy dustman | programmer/analyst | comstar.net, inc. telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or courage, come no further, for death awaits you all, with nasty, big, pointy teeth!"
participants (2)
-
Andy Dustman -
Sam Gendler