Re: [sqlalchemy] Re: How can I use and_ and or_ in the orm query ?

2012-05-11 Thread Michael Bayer
we have this exact usage described right in the ORM tutorial: http://docs.sqlalchemy.org/en/rel_0_7/orm/tutorial.html#common-filter-operators On May 11, 2012, at 5:55 AM, Jonathan Vanasco wrote: Dan Kuebrich messaged me off-list -- the filter() method seems to accept the output of and_ or_

[sqlalchemy] How should I do inheritance using DeclarativeReflectedBase?

2012-05-11 Thread Ignas Mikalajunas
Even though the latest version of the DeclarativeRefletive example includes some handling for inheritance, I still can not get it to work. I try doing (mostly modified example from

Re: [sqlalchemy] Mapper compilation errors in multi threaded web application using dynamic mapping to selects

2012-05-11 Thread Jochen Stenzel
(Sorry if this message appears twice in the list - I first sent it using an unregistered mail address.) Hello, thank you for your quick reply. is there a problem in mapping classes to selects ([1]) /within a function/? with multiple threads, where the mappers initialization may first

Re: [sqlalchemy] How should I do inheritance using DeclarativeReflectedBase?

2012-05-11 Thread Michael Bayer
On May 11, 2012, at 1:16 PM, Ignas Mikalajunas wrote: Even though the latest version of the DeclarativeRefletive example includes some handling for inheritance, I still can not get it to work. I try doing (mostly modified example from

Re: [sqlalchemy] Mapper compilation errors in multi threaded web application using dynamic mapping to selects

2012-05-11 Thread Michael Bayer
On May 11, 2012, at 1:31 PM, Jochen Stenzel wrote: (Sorry if this message appears twice in the list - I first sent it using an unregistered mail address.) Hello, thank you for your quick reply. is there a problem in mapping classes to selects ([1]) /within a function/? with

Re: [sqlalchemy] Mapper compilation errors in multi threaded web application using dynamic mapping to selects

2012-05-11 Thread Jochen Stenzel
Could it be I am not loading enough modules? Does all modules mean all modules of the application, or all modules to map successfully? yes the issue is very likely that more modules are being imported within non-main threads, and more mappers are coming in. if you get absolutely every

[sqlalchemy] Re: How can I use and_ and or_ in the orm query ?

2012-05-11 Thread Jonathan Vanasco
it's not in the api docs though - which tends to come up first on the keyword search and is the more obvious place to look. http://docs.sqlalchemy.org/en/rel_0_7/orm/query.html#sqlalchemy.orm.query.Query.filter