[sqlalchemy] Sqlalchemy exception for mysql in window: TypeError: immutabledict object is immutable

2011-06-02 Thread zhwolf
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:root@127.0.0.1/linelocationdb?charset=utf8use_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 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.



[sqlalchemy] Re: Sqlalchemy exception for mysql in window: TypeError: immutabledict object is immutable

2011-06-02 Thread zhwolf
Thanks, the patch works now.

Jun Zhou

-- 
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.