[sqlalchemy] Re: Mapping and querying multiple levels of foreign key'd tables

2008-03-05 Thread Christoph Haas
On Wed, Mar 05, 2008 at 08:31:12AM +0100, Christoph Haas wrote: Basically I have three tables like 'companies', 'departments' and 'employees'. I have already set up foreign keys and gave all of them one-to-many relationships. So a company has several departments. And each department has

[sqlalchemy] Re: Mapping and querying multiple levels of foreign key'd tables

2008-03-05 Thread Christoph Haas
Moin, Michael... thanks for your quick reply. On Wed, Mar 05, 2008 at 11:16:33AM -0500, Michael Bayer wrote: On Mar 5, 2008, at 4:14 AM, Christoph Haas wrote: Meanwhile I re-read http://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_joins explaining that a relation path

[sqlalchemy] Re: Mapping and querying multiple levels of foreign key'd tables

2008-03-05 Thread Michael Bayer
On Mar 5, 2008, at 1:00 PM, Christoph Haas wrote: But now I'm curious. Why do I get the ArgumentError if I try .filter(Company==my_company) while .filter(Company.id==my_company.id) works? I was comparing ORM objects directly instead of fields/ properties of a mapped object.