The current version of adodb-py does not function for me here with MySQL as a backend. Updating to the latest one appears to fix it. Copying the ebuild to 1.1.0 "just worked" for me.
What versions of mysql & mysql-python did 1.0.1 fail on, Tom? I'll add the new one and adjust the mysql dependencies on 1.0.1 Thanks
adodb-py-1.0.1 mysql-4.1.8 (hardmasked at present, but required for demoing mysql-querybrowser to the boss...) mysql-python-1.1.9 OK, adodb-py fails: >>> import adodb; >>> conn = adodb.NewADOConnection('mysql') >>> conn.Connect('localhost','root','','paf') >>> cursor = conn.Execute('select * from address limit 100') Traceback (most recent call last): File "<stdin>", line 1, in ? File "/usr/lib/python2.3/site-packages/adodb.py", line 236, in Execute rs = self._newcursor(c) File "/usr/lib/python2.3/site-packages/adodb_mysql.py", line 34, in _newcursor return cursor_mysql(rs,self) File "/usr/lib/python2.3/site-packages/adodb_mysql.py", line 91, in __init__ self._insertid = rs.insert_id() AttributeError: 'Cursor' object has no attribute 'insert_id' emerge info: (in case it's worthwhile) Portage 2.0.51-r15 (default-linux/x86/2004.3, gcc-3.4.3, glibc-2.3.4.20041102-r0, 2.6.10-gentoo-r7 i686) ================================================================= System uname: 2.6.10-gentoo-r7 i686 AMD Athlon(tm) MP 2400+ Gentoo Base System version 1.6.9 Python: dev-lang/python-2.3.4-r1 [2.3.4 (#1, Feb 9 2005, 18:19:39)] dev-lang/python: 2.3.4-r1 sys-devel/autoconf: 2.13, 2.59-r6 sys-devel/automake: 1.8.5-r3, 1.5, 1.9.4, 1.7.9-r1, 1.4_p6, 1.6.3 sys-devel/binutils: 2.15.92.0.2-r2 sys-devel/libtool: 1.5.10-r4 virtual/os-headers: 2.6.8.1-r2 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CFLAGS="-march=athlon-mp -O2 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config /u sr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/sh are/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/mail/dspam /etc/terminfo /etc/env.d" CXXFLAGS="-march=athlon-mp -O2 -pipe" DISTDIR="/usr/portage-distfiles" FEATURES="autoaddcvs autoconfig candy collision-protect distlocks fixpackages sandbox sfperms" GENTOO_MIRRORS="ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ http://gentoo.tiscali.nl/gentoo/ http: //ftp.easynet.nl/mirror/gentoo/ http://gentoo.mirror.sdv.fr ftp://ftp.tiscali.nl/pub/mirror/gentoo http:// mir.zyrianes.net/gentoo/ http://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ http://www.mirrorservice.org /sites/www.ibiblio.org/gentoo/" LANG="en_GB.UTF-8" MAKEOPTS="-j3" PKGDIR="/usr/portage-packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="x86 3dfx 3dnow X aalib alsa apm avi bash-completion berkdb bitmap-fonts cdr crypt cups dga dvd dvdr e ds encode evo f77 fam font-server foomaticdb fortran gdbm gif gnome gpm gstreamer gtk gtk2 guile hal image magick imlib ipv6 java jikes jpeg ldap libg++ libwww mad mikmod mmx motif moznocompose moznoirc moznomail mpeg mysql ncurses network nls nntp nptl offensive oggvorbis opengl oss pam pda pdflib perl png python qui cktime readline sdl slang smime spell ssl svga tcltk tcpd tetex tiff truetype truetype-fonts type1-fonts u nicode xine xml2 xprint xv zlib linguas_en_GB" Unset: ASFLAGS, CBUILD, CTARGET, LC_ALL, LDFLAGS
Bumped ~arch version. This fixes your 'no insert_id' problem in ~arch. Current stable versions of mysql-python and adodb-py also don't have this problem according to my tests.
