82 with self.session() as session: |
82 with self.session() as session: |
83 self.assertEqual(session.typs.all(),[('sms',),]) |
83 self.assertEqual(session.typs.all(),[('sms',),]) |
84 |
84 |
85 with self.session() as session: |
85 with self.session() as session: |
86 o=Offer(name="s2", provider="sipgate", route="basic", typ="sms") |
86 o=Offer(name="s2", provider="sipgate", route="basic", typ="sms") |
|
87 session.add(o) |
87 o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2") |
88 o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2") |
88 session.add(o) |
89 session.add(o) |
89 |
90 |
90 with self.session() as session: |
91 with self.session() as session: |
91 self.assertEqual(session.typs.order_by(Offer.typ).all(),[('sms',),('sms2',)]) |
92 self.assertEqual(session.typs.order_by(Offer.typ).all(),[('sms',),('sms2',)]) |
|
93 |
|
94 def testOfferRoutes(self): |
|
95 with self.session() as session: |
|
96 o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms") |
|
97 session.add(o) |
|
98 |
|
99 with self.session() as session: |
|
100 self.assertEqual([o.name for o in Offer.routes(session, "sms").order_by(Offer.name)],["sipgate_basic"]) |
|
101 |
|
102 with self.session() as session: |
|
103 o=Offer(name="s2", provider="sipgate", route="basic", typ="sms") |
|
104 session.add(o) |
|
105 o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2") |
|
106 session.add(o) |
|
107 |
|
108 with self.session() as session: |
|
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"]) |
|
111 |
92 |
112 |
93 class Has_RightTests(DBTestCase): |
113 class Has_RightTests(DBTestCase): |
94 '''test User.has_right''' |
114 '''test User.has_right''' |
95 def testSimple(self): |
115 def testSimple(self): |
96 '''test a very simple case''' |
116 '''test a very simple case''' |