iro/model/schema.py
branchdevel
changeset 203 b543ab9a9724
parent 201 843a7bcecbc8
child 205 02ae72e8bab9
equal deleted inserted replaced
202:3cc8cca036ab 203:b543ab9a9724
   118         filters=[User.name == self.name,
   118         filters=[User.name == self.name,
   119                 Offer.typ == typ, 
   119                 Offer.typ == typ, 
   120                 ]
   120                 ]
   121         if default:
   121         if default:
   122             filters.append(Userright.default != None)
   122             filters.append(Userright.default != None)
   123         return object_session(self).query(Userright.offer_name).join(Offer,User).filter(and_(*filters))
   123         return object_session(self).query(Userright.offer_name).join(Offer,User).filter(and_(*filters)).order_by(Userright.default)
   124    
   124    
   125     def providers(self, typ, default = False):
   125     def providers(self, typ, default = False):
   126         '''return a query object for all possible providers for a given typ'''
   126         '''return a query object for all possible providers for a given typ'''
   127         filters=[User.name == self.name,
   127         filters=[User.name == self.name,
   128                 Offer.typ == typ, 
   128                 Offer.typ == typ,