78 with self.session() as session: |
78 with self.session() as session: |
79 o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms") |
79 o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms") |
80 session.add(o) |
80 session.add(o) |
81 |
81 |
82 with self.session() as session: |
82 with self.session() as session: |
83 self.assertEqual(session.typs.all(),[('sms',),]) |
83 self.assertEqual(Offer.typs(session).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 session.add(o) |
88 o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2") |
88 o=Offer(name="s3", provider="sipgate", route="basic", typ="sms2") |
89 session.add(o) |
89 session.add(o) |
90 |
90 |
91 with self.session() as session: |
91 with self.session() as session: |
92 self.assertEqual(session.typs.order_by(Offer.typ).all(),[('sms',),('sms2',)]) |
92 self.assertEqual(Offer.typs(session).order_by(Offer.typ).all(),[('sms',),('sms2',)]) |
93 |
93 |
94 def testOfferRoutes(self): |
94 def testOfferRoutes(self): |
95 with self.session() as session: |
95 with self.session() as session: |
96 o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms") |
96 o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms") |
97 session.add(o) |
97 session.add(o) |