hey skip (just FYI we've moved the list to google groups)
i think the error you have might be a result of MySQLDB not being installed on your machine, and the dialect, not finding it, is defaulting to "named parameter" mode. i could put a fix into the mysql dialect to default to "positional" even if mysqldb isnt found.... i also posted a request for someone to set up a SA pybot, could this bot become the "official" SA pybot ? - mike On Oct 15, 2006, at 9:44 PM, [EMAIL PROTECTED] wrote: > I'm trying to learn about buildbot and the pybots project > (http://www.pybots.org/). I decided to try and set up a buildbot > slave for > sqlalchemy on my Mac OSX G5. With a little effort I got pysqlite > built on > the G5 and ran sqlalchemy's test suite. I got this one failure: > > FAIL: testforupdate (sql.select.SelectTest) > > ---------------------------------------------------------------------- > Traceback (most recent call last): > File "/Users/skip/src/sqlalchemy/test/sql/select.py", line > 258, in testforupdate > self.runtest(table1.select(table1.c.myid==7, > for_update="read"), "SELECT mytable.myid, mytable.name, > mytable.description FROM mytable WHERE mytable.myid = %s LOCK IN > SHARE MODE", dialect=mysql.dialect()) > File "/Users/skip/src/sqlalchemy/test/sql/select.py", line > 58, in runtest > self.assert_(cc == result, "\n'" + cc + "'\n does not match > \n'" + result + "'") > AssertionError: > 'SELECT mytable.myid, mytable.name, mytable.description FROM > mytable WHERE mytable.myid = :mytable_myid LOCK IN SHARE MODE' > does not match > 'SELECT mytable.myid, mytable.name, mytable.description FROM > mytable WHERE mytable.myid = %s LOCK IN SHARE MODE' > > This is on a fully up-to-date Mac OSX 10.4.8 system using the recently > released Python 2.4.4c1 installer. > > Look familiar to anyone? > > -- > Skip Montanaro - [EMAIL PROTECTED] - http://www.mojam.com/ > "In China today, Bill Gates is Britney Spears. In America today, > Britney > Spears is Britney Spears - and that is our problem." Thomas L. > Friedman in > "The World is Flat" > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy -~----------~----~----~----~------~----~------~--~---