[sqlalchemy] Entity name - multiple schema - relationship

2014-05-05 Thread Julien Meyer
I need some help and advices to create a mapping. The context : - Multiple schemas on postgresql (dynamic number and name) who store the same tables. - SQLAlchemy used into a pyramid web application. Example : A table Customer and a table CustomerOrder (link by customer.id) and a schema by

Re: [sqlalchemy] Entity name - multiple schema - relationship

2014-05-05 Thread Michael Bayer
part of a feature that will make this kind of thing more direct is the schema name execution argument feature, which is https://bitbucket.org/zzzeek/sqlalchemy/issue/2685/default-schema-as-an-execution-argument. This application is somewhat of a multi-tenancy application; technically its

[sqlalchemy] Problem with _compiler_dispatch() call?

2014-05-05 Thread Seth P
I get the following error when trying to create_all() in a sqlite database: TypeError: _compiler_dispatch() missing 1 required positional argument: 'visitor' Looking at annotation.py and visitors.py, all instances of _compiler_dispatch() do indeed appear to expect a 'visitor' argument, which

Re: [sqlalchemy] Problem with _compiler_dispatch() call?

2014-05-05 Thread Michael Bayer
need to see the calling code on that, sounds like you might be using an API incorrectly. e.g. a short script which when run, produces this error - could be in table defs etc. On May 5, 2014, at 3:07 PM, Seth P spadow...@gmail.com wrote: I get the following error when trying to create_all()

[sqlalchemy] Re: Problem with _compiler_dispatch() call?

2014-05-05 Thread Seth P
Of course you are right. My problem code was basically the PythonEnum class in https://groups.google.com/d/topic/sqlalchemy/5yvdhl9ErMo/discussion. Deleting the *(m.name for m in enum_class), from the __init__ call seems to have fixed the problem. Thanks again. Seth On Monday, May 5, 2014