Re: [sqlalchemy] problems with mysql reflect

2014-07-11 Thread Paul Molodowitch
Done: https://bitbucket.org/zzzeek/sqlalchemy/issue/3123/mysql-reflection-on-python-26-causes-error FYI, for now we're patching sqlalchemy/engine/reflection.py, changing Inspector.reflectable after it gets tbl_opts (line 450 in my code): # reflect table options, like mysql_engine

Re: [sqlalchemy] problems with mysql reflect

2014-07-11 Thread Paul Molodowitch
oops, that line should read Python 2.6 doesn't accept, not except. My hands are too used to typing except SomeError:... On Fri, Jul 11, 2014 at 11:38 AM, Paul Molodowitch elron...@gmail.com wrote: Done:

Re: [sqlalchemy] problems with mysql reflect

2014-07-10 Thread Paul Molodowitch
Whoops! Just noticed this was the totally wrong traceback! Here's the correct trace: Traceback (most recent call last): File stdin, line 1, in module File test.py, line 155, in module metadata.reflect(db.engine, only=tables) File ./sqlalchemy/sql/schema.py, line 3277, in reflect

Re: [sqlalchemy] problems with mysql reflect

2014-07-10 Thread Mike Bayer
On 7/10/14, 3:49 PM, Paul Molodowitch wrote: Whoops! Just noticed this was the totally wrong traceback! Here's the correct trace: Traceback (most recent call last): File stdin, line 1, in module File test.py, line 155, in module metadata.reflect(db.engine,

Re: [sqlalchemy] problems with mysql reflect

2014-07-09 Thread Paul Molodowitch
I just ran into the same problem, using python 2.6 + sqlalchemy 0.9.4 / 0.9.6 + MySQL. The problem in my case IS definitely related to python 2.6 - basically, python 2.6 doesn't allow unicode keywords, while 2.7 does. Ie, if you do this: def foo(**kwargs): print kwargs foo(**{u'thing':1})

Re: [sqlalchemy] problems with mysql reflect

2014-07-09 Thread Mike Bayer
On 7/9/14, 3:41 PM, Paul Molodowitch wrote: I just ran into the same problem, using python 2.6 + sqlalchemy 0.9.4 / 0.9.6 + MySQL. The problem in my case IS definitely related to python 2.6 - basically, python 2.6 doesn't allow unicode keywords, while 2.7 does. Ie, if you do this: def

Re: [sqlalchemy] problems with mysql reflect

2014-07-09 Thread Paul Molodowitch
Sure - I think it's the same as the original poster's, but the traceback I'm getting is: inspect(Project).relationships Traceback (most recent call last): File stdin, line 1, in module File ./sqlalchemy/util/langhelpers.py, line 712, in __get__ obj.__dict__[self.__name__] = result =

[sqlalchemy] problems with mysql reflect

2014-02-10 Thread robert rottermann
Hi there, I have a mysql database that I use on several linux boxes. No I get the following error on on of them: Traceback (most recent call last): File ../bin/zopepy, line 317, in module execfile(__file__) File t.py, line 38, in module BaseA.metadata.reflect(local_engine_a) File

Re: [sqlalchemy] problems with mysql reflect

2014-02-10 Thread Michael Bayer
so this code runs fine on many machines, just one machine is doing this? have there been modifications made to the SQLAlchemy library on that one machine? I’m not able to reproduce this case. There’s a path where table.dialect_kwargs gets populated and within the scope of MySQL reflection,