tests/db.py
branchdevel
changeset 203 b543ab9a9724
parent 202 3cc8cca036ab
child 205 02ae72e8bab9
equal deleted inserted replaced
202:3cc8cca036ab 203:b543ab9a9724
    19             session.add(u)
    19             session.add(u)
    20         
    20         
    21         with self.session() as session:
    21         with self.session() as session:
    22             u=session.merge(u)
    22             u=session.merge(u)
    23             self.assertEqual(u.routes('sms').all(),[('sipgate_basic',),])
    23             self.assertEqual(u.routes('sms').all(),[('sipgate_basic',),])
       
    24 
       
    25     def testRoutesNoDefault(self):
       
    26         '''test default routes'''
       
    27         with self.session() as session:
       
    28             u=User(name='test',apikey='abcdef123456789')
       
    29             o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms")
       
    30             u.rights.append(Userright(o)) 
       
    31             session.add(u)
       
    32         
       
    33         with self.session() as session:
       
    34             u=session.merge(u)
       
    35             self.assertEqual(u.routes('sms',default=True).all(),[])
       
    36 
       
    37     def testRoutesDefault(self):
       
    38         '''test default routes'''
       
    39         with self.session() as session:
       
    40             u=User(name='test',apikey='abcdef123456789')
       
    41             o=Offer(name="sipgate_basic", provider="sipgate", route="basic", typ="sms")
       
    42             u.rights.append(Userright(o,default=1)) 
       
    43             session.add(u)
       
    44 
       
    45         with self.session() as session:
       
    46             u=session.merge(u)
       
    47             self.assertEqual(u.routes('sms',default=True).all(),[('sipgate_basic',),])
       
    48 
       
    49     def testRoutesDefaultOrdering(self):
       
    50         '''test default routes ordering'''
       
    51         with self.session() as session:
       
    52             u=User(name='test',apikey='abcdef123456789')
       
    53             o=Offer(name="s1", provider="sipgate", route="basic", typ="sms")
       
    54             u.rights.append(Userright(o,default=3)) 
       
    55             o=Offer(name="s2", provider="sipgate", route="basic", typ="sms")
       
    56             u.rights.append(Userright(o,default=None)) 
       
    57             o=Offer(name="s3", provider="sipgate", route="basic", typ="sms")
       
    58             u.rights.append(Userright(o,default=1)) 
       
    59             session.add(u)
       
    60 
       
    61         with self.session() as session:
       
    62             u=session.merge(u)
       
    63             self.assertEqual(u.routes('sms',default=True).all(),[('s3',),('s1',)])
    24 
    64 
    25     def testProviders(self):
    65     def testProviders(self):
    26         '''test providers'''
    66         '''test providers'''
    27         with self.session() as session:
    67         with self.session() as session:
    28             u=User(name='test',apikey='abcdef123456789')
    68             u=User(name='test',apikey='abcdef123456789')