I am attempting to upgrade from sqlalchemy 0.3.11 to current release 0.4.1 and i am getting the following error:

/ recs = session.query(PurchaseOrder).filter_by(description = 'Shipped').all() File "C:\Python24\Lib\site-packages\sqlalchemy\orm\query.py", line 322, in filter_by clauses = [self._joinpoint.get_property(key, resolve_synonyms=True).compare(operator.eq, value) File "C:\Python24\Lib\site-packages\sqlalchemy\orm\mapper.py", line 192, in get_property raise exceptions.InvalidRequestError("Mapper '%s' has no property '%s'" % (str(self), key)) InvalidRequestError: Mapper 'Mapper|PurchaseOrder|purchaseorder' has no property 'description' / I am trying to query a column in a related table with the following query: recs = session.query(PurchaseOrder).filter_by(description = 'Shipped').all()

This query works in 0.3.11.

Is there a new setting when defining relationships that I need to set so that it looks at the related table columns when running a filter_by or am i missing something simple?

Here is my simplified example classes, table definitions, and mappings:

class PurchaseOrder(object) : pass class OrderStatus(object) : pass

purchaseorder_table = sqlalchemy.Table( 'purchaseorder', metadata, sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True), sqlalchemy.Column('createdate', sqlalchemy.TIMESTAMP), sqlalchemy.Column('statusid', sqlalchemy.Integer, sqlalchemy.ForeignKey('testing.orderstatus.statusid')), schema = 'testing')

orderstatus_table = sqlalchemy.Table( 'orderstatus', metadata, sqlalchemy.Column('statusid', sqlalchemy.Integer, primary_key=True), sqlalchemy.Column('description', sqlalchemy.VARCHAR), schema = 'testing')

orm.mapper(PurchaseOrder, purchaseorder_table, properties={ 'orderstatus' : orm.relation(OrderStatus)})

orm.mapper(OrderStatus, orderstatus_table)

Thanks, Curtis