sweet. many thanks. i will give this a try On Feb 14, 7:46 am, Christopher Arndt <[email protected]> wrote: > steve schrieb: > > > for my objects, i am trying to associate an user with each item. to > > restrict users to their own items, one would typically add > > "filter(MyObjClass.user_id==request.identity["user"].user_id)" to all > > the queries. could we enforce this from the model instead? i feel > > like eventually someone would forget the extra filter statement. > > Just add a class method to your mapped model class that runs the query > you want and use this in the controller. Example (untested): > > class Items(object): > @classmethod > def user_items(cls, user=None): > if user is None: > user = request.identity['user'] > return session.query(cls).filter(cls.user_id=user.user_id) > > and in your controller: > > @expose() > def item_list(self): > return dict(items=Items.user_items()) > > Chris
-- You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.
