On Jan 3, 2013, at 12:51 PM, sjo...@congressus.nl wrote: > Hi, > > I have one set of tables and I want to automate the insertion of the > company_id in queries at certain tables. So I need to define in the models > which tables are effected, no worries there, but where do I need to implement > the query manipulation? The SQLAlchemy object is shared between different > requests (as the configuration remains te same). But the session is > different, as the company_id differs between sessions. > > Where and how do I implement the query manipulation?!
its not clear what usage pattern you're looking for here. Lets start with the obvious, putting "company_id" in a query: session.query(SomeObject).filter(SomeObject.company_id == 5) easy enough. Now what exactly do you want it to look like? Like, session_one.query(SomeClassOne) -> automatically put company_id = 8 session_two.query(SomeClassTwo) -> automatically put company_id = 15 ? if I'm given "session_one" and "SomeClassOne", what is the "company_id" for that ? There's a pattern for auto-querying of a certain column at http://www.sqlalchemy.org/trac/wiki/UsageRecipes/PreFilteredQuery . But this doesn't get into how to determine where the custom criterion would come from. -- 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.