From b61fda425d4498482f172afbfab0fed9ebf3f3c8 Mon Sep 17 00:00:00 2001 From: Evan Broder Date: Sun, 13 Jul 2008 14:57:19 +0000 Subject: [PATCH] Explicitly specify the primary join for transfer.{debtor,creditor} --- bluechips/model/__init__.py | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/bluechips/model/__init__.py b/bluechips/model/__init__.py index 26686ff..0b6485c 100644 --- a/bluechips/model/__init__.py +++ b/bluechips/model/__init__.py @@ -7,11 +7,6 @@ from bluechips.model import types def init_model(engine): """Call me before using any of the tables or classes in the model""" - ## Reflected tables must be defined and mapped here - #global reflected_table - #reflected_table = sa.Table("Reflected", meta.metadata, autoload=True, - # autoload_with=engine) - #orm.mapper(Reflected, reflected_table) sm = orm.sessionmaker(autoflush=True, transactional=True, bind=engine) @@ -116,8 +111,12 @@ orm.mapper(Subitem, subitems, properties={ }) orm.mapper(Transfer, transfers, properties={ - 'debtor': orm.relation(User), - 'creditor': orm.relation(User) + 'debtor': orm.relation(User, + primaryjoin=(transfers.c.debtor_id==\ + users.c.id)), + 'creditor': orm.relation(User, + primaryjoin=(transfers.c.creditor_id==\ + users.c.id)) }) __all__ = [users, expenditures, splits, subitems, transfers, -- 2.45.2