tests/db.py
branchdevel
changeset 211 3fc1f400c107
parent 208 5da0f00ef872
equal deleted inserted replaced
210:3763babd5e10 211:3fc1f400c107
   107         
   107         
   108         with self.session() as session:
   108         with self.session() as session:
   109             self.assertEqual([o.name for o in Offer.routes(session, "sms2").order_by(Offer.name)],["s3"])
   109             self.assertEqual([o.name for o in Offer.routes(session, "sms2").order_by(Offer.name)],["s3"])
   110             self.assertEqual([o.name for o in Offer.routes(session, "sms").order_by(Offer.name)],["s2","sipgate_basic"])
   110             self.assertEqual([o.name for o in Offer.routes(session, "sms").order_by(Offer.name)],["s2","sipgate_basic"])
   111 
   111 
       
   112     def testOfferProviders(self):
       
   113         with self.session() as session:
       
   114             o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms")
       
   115             session.add(o)
       
   116         
       
   117         with self.session() as session:
       
   118             self.assertEqual([o.provider for o in Offer.providers(session, "sms").order_by(Offer.provider)],["sipgate"])
       
   119 
       
   120         with self.session() as session:
       
   121             o=Offer(name="s2", provider="sipgate2", route="basic", typ="sms")
       
   122             session.add(o)
       
   123             o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2")
       
   124             session.add(o)
       
   125         
       
   126         with self.session() as session:
       
   127             self.assertEqual([o.provider for o in Offer.providers(session, "sms2").order_by(Offer.provider)],["sipgate"])
       
   128             self.assertEqual([o.provider for o in Offer.providers(session, "sms").order_by(Offer.provider)],["sipgate","sipgate2"])
   112 
   129 
   113 class Has_RightTests(DBTestCase):
   130 class Has_RightTests(DBTestCase):
   114     '''test User.has_right'''
   131     '''test User.has_right'''
   115     def testSimple(self):
   132     def testSimple(self):
   116         '''test a very simple case'''
   133         '''test a very simple case'''