Hi,
I experienced the exception while accessing a mysql database in
windows via sqlalchemy0.7.0.

It should be due to source code error in 0.7.0:
The member tables of class MetaData is created as immutabledict,
    sqlalchemy\schema.py::line 2181
     self.tables = util.immutabledict()
But the follow code try to change it's content:
     sqlalchemy\dialects\mysql\base.py::line 1986
           table.metadata.tables[lc_alias] = table

Could any people assist to resolve this issue?

Thanks,

log:
mysql://root:[email protected]/linelocationdb?charset=utf8&use_unicode=0
Traceback (most recent call last):
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\schema.py", line 263, in __new__   table._init(name,
metadata, *args, **kw)
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\schema.py", line 329, in _init
    reflecttable(self, include_columns=include_columns)
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\engine\base.py", line 2132, in reflecttable
    self.dialect.reflecttable(conn, table, include_columns)
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\engine\default.py", line 254, in reflecttable
    return insp.reflecttable(table, include_columns)
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\engine\reflection.py", line 353, in reflecttable
    dialect._adjust_casing(table)
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\dialects\mysql\base.py", line 1986, in _adjust_casing
    table.metadata.tables[lc_alias] = table
  File "d:\python25\lib\site-packages\sqlalchemy-0.7.0-py2.5.egg
\sqlalchemy\util\_collections.py", line 38, in _immutable
    raise TypeError("%s object is immutable" %
self.__class__.__name__)
TypeError: immutabledict object is immutable

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to