From 7251a413002768b8544964c7d7197e0bb4748423 Mon Sep 17 00:00:00 2001 From: Evan Broder Date: Thu, 17 Jul 2008 17:46:32 +0000 Subject: [PATCH] Reconfigure some models for convenience * Add a default sort on expenditures and transfers, since that's almost always what's wanted * Eagerly load users related to expenditures and transfers, since it's cheap and generally wanted --- bluechips/model/__init__.py | 16 +++++++++++----- 1 file changed, 11 insertions(+), 5 deletions(-) diff --git a/bluechips/model/__init__.py b/bluechips/model/__init__.py index 12e28d8..8601d32 100644 --- a/bluechips/model/__init__.py +++ b/bluechips/model/__init__.py @@ -99,8 +99,11 @@ class Transfer(object): orm.mapper(User, users) -orm.mapper(Expenditure, expenditures, properties={ - 'spender': orm.relation(User, backref='expenditures') +orm.mapper(Expenditure, expenditures, order_by=expenditures.c.date.desc(), + properties={ + 'spender': orm.relation(User, + backref='expenditures', + lazy=False) }) orm.mapper(Split, splits, properties={ @@ -113,13 +116,16 @@ orm.mapper(Subitem, subitems, properties={ 'user': orm.relation(User) }) -orm.mapper(Transfer, transfers, properties={ +orm.mapper(Transfer, transfers, order_by=transfers.c.date.desc(), + properties={ 'debtor': orm.relation(User, primaryjoin=(transfers.c.debtor_id==\ - users.c.id)), + users.c.id), + lazy=False), 'creditor': orm.relation(User, primaryjoin=(transfers.c.creditor_id==\ - users.c.id)) + users.c.id), + lazy=False) }) __all__ = ['users', 'expenditures', 'splits', 'subitems', 'transfers', -- 2.45.2