looks like MySQL-Python changed their exception format again. here's
our current code:
try:
rs = connection.execute(st)
have = rs.rowcount > 0
rs.close()
return have
except exc.SQLError, e:
if e.orig.args[0] == 1146:
return False
raise
so obviously the e.orig.args[0] is not finding the code again.
maybe someone has time to look at this with mysql 1.2.3 ?
On Mar 6, 2009, at 6:13 AM, Ben Cheng wrote:
>
> Hi,
>
> I'm not sure is it a bug of SQLAlchemy or MySQL-Python, may some one
> advice or if you know any related tickets?
>
> When I'm using SQLAlchemy on MySQL-Python 1.2.3, it shows error on the
> following SQL when I call create_all:
>
> 19:05:33,895 INFO [sqlalchemy.engine.base.Engine.0x...a0f0] SHOW
> VARIABLES LIKE 'sql_mode'
> 19:05:33,895 INFO [sqlalchemy.engine.base.Engine.0x...a0f0] ()
> 19:05:33,934 INFO [sqlalchemy.engine.base.Engine.0x...a0f0] DESCRIBE
> `forms`
> 19:05:33,935 INFO [sqlalchemy.engine.base.Engine.0x...a0f0] ()
> 19:05:33,947 INFO [sqlalchemy.engine.base.Engine.0x...a0f0] ROLLBACK
>
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, "Table
> 'voters.forms' doesn't exist") 'DESCRIBE `forms`' ()
>
> But when I roll-back to MySQL-Python 1.2.1, the error gones.
>
> Any thought?
>
> Best,
> Ben
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
