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 --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---