Re: [Sqlalchemy-users] Test failure on Mac OSX 10.4.8 w/ Python 2.4.4c1

[Michael Bayer]

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, sk...@pobox.com 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 - sk...@pobox.com - 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
> Sqlalche...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

[skip.mo...@gmail.com]

Michael> (just FYI we've moved the list to google groups)

Ah yes, forgot about that.

Michael> i think the error you have might be a result of MySQLDB not
Michael> being installed on your machine, and the dialect, not finding
Michael> it, is defaulting to "named parameter" mode. i could put a fix
Michael> into the mysql dialect to default to "positional" even if
Michael> mysqldb isnt found....

Correct, I only have sqlite on this machine, no MySQL. I can install MySQL
if that's the better supported database.

Michael> i also posted a request for someone to set up a SA pybot, could
Michael> this bot become the "official" SA pybot ?

In theory, I suppose it could. If I'm successful getting it set up I'm
happy to keep running it. First, I have to get there though. ;-)

Skip