--- a/iro/controller/viewinterface.py	Sat Jan 28 04:03:46 2012 +0100
+++ b/iro/controller/viewinterface.py	Sat Jan 28 12:24:40 2012 +0100
@@ -1,7 +1,5 @@
 # -*- coding: utf-8 -*-
 from ..model.decorators import vUser, vRoute, dbdefer, vTyp
-from ..model.schema import User, Userright, Offer
-from sqlalchemy import and_
 from ..validate import validate, vBool, vHash, vTel, vEmail
 
 class Interface(object):
@@ -122,7 +120,8 @@
         providerlist[list]: Eine Liste aller möglichen Provider
 
         '''
-        offers = session.query(Userright.offer_name).join(Offer,User).filter(and_(User.name==user.name,Offer.typ==typ))
+        user = session.merge(user)
+        offers = user.routes(typ)
         return [u[0] for u in offers]
         
     @validate(kwd="typ", func=vTyp)
@@ -141,7 +140,8 @@
 
 
         '''
-        offers = session.query(Userright.offer_name).join(Offer,User).filter(and_(User.name==user.name,Offer.typ==typ,Userright.isDefault==True))
+        user = session.merge(user)
+        offers = user.routes(typ, isDefault=True)
         return [u[0] for u in offers]
 
     @vUser