48 apikey='abcdef123456789' |
48 apikey='abcdef123456789' |
49 with self.session() as session: |
49 with self.session() as session: |
50 u=User(name='test',apikey=apikey) |
50 u=User(name='test',apikey=apikey) |
51 session.add(u) |
51 session.add(u) |
52 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
52 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
53 j = Job(hash='a1',info='i',status='sended') |
53 j = Job(info='i',status='sended') |
54 m = Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.30, offer=o, job=j) |
54 m = Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.30, offer=o, job=j) |
55 u.rights.append(Userright(o)) |
55 u.rights.append(Userright(o)) |
56 u.jobs.append(j) |
56 u.jobs.append(j) |
57 session.add(m) |
57 session.add(m) |
58 |
58 |
64 apikey='abcdef123456789' |
64 apikey='abcdef123456789' |
65 with self.session() as session: |
65 with self.session() as session: |
66 u=User(name='test',apikey=apikey) |
66 u=User(name='test',apikey=apikey) |
67 session.add(u) |
67 session.add(u) |
68 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
68 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
69 j = Job(hash='a1',info='i',status='sended') |
69 j = Job(info='i',status='sended') |
70 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.30, offer=o)) |
70 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.30, offer=o)) |
71 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
71 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
72 u.rights.append(Userright(o)) |
72 u.rights.append(Userright(o)) |
73 u.jobs.append(j) |
73 u.jobs.append(j) |
74 |
74 |
80 apikey='abcdef123456789' |
80 apikey='abcdef123456789' |
81 with self.session() as session: |
81 with self.session() as session: |
82 u=User(name='test',apikey=apikey) |
82 u=User(name='test',apikey=apikey) |
83 session.add(u) |
83 session.add(u) |
84 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
84 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
85 j = Job(hash='a1',info='i',status='sended') |
85 j = Job(info='i',status='sended') |
86 j.messages.append(Message(recipient='0123456789', isBilled=True, date=datetime.now() , price=0.30, offer=o)) |
86 j.messages.append(Message(recipient='0123456789', isBilled=True, date=datetime.now() , price=0.30, offer=o)) |
87 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
87 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
88 u.rights.append(Userright(o)) |
88 u.rights.append(Userright(o)) |
89 u.jobs.append(j) |
89 u.jobs.append(j) |
90 |
90 |
98 u=User(name='test',apikey=apikey) |
98 u=User(name='test',apikey=apikey) |
99 session.add(u) |
99 session.add(u) |
100 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
100 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
101 u.rights.append(Userright(o)) |
101 u.rights.append(Userright(o)) |
102 |
102 |
103 j = Job(hash='a1',info='i',status='sended') |
103 j = Job(info='i',status='sended') |
104 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
104 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now() , price=0.4, offer=o)) |
105 u.jobs.append(j) |
105 u.jobs.append(j) |
106 |
106 |
107 j = Job(hash='a2',info='a',status='sended') |
107 j = Job(info='a',status='sended') |
108 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.4, offer=o)) |
108 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.4, offer=o)) |
109 u.jobs.append(j) |
109 u.jobs.append(j) |
110 |
110 |
111 with self.session() as session: |
111 with self.session() as session: |
112 u=session.merge(u) |
112 u=session.merge(u) |
121 u=User(name='test',apikey=apikey) |
121 u=User(name='test',apikey=apikey) |
122 session.add(u) |
122 session.add(u) |
123 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
123 o = Offer(name='sipgate_basic',provider="sipgate",route="basic",typ="sms") |
124 u.rights.append(Userright(o)) |
124 u.rights.append(Userright(o)) |
125 |
125 |
126 j = Job(hash='a2',info='a',status='sended') |
126 j = Job(info='a',status='sended') |
127 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.4, offer=o)) |
127 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.4, offer=o)) |
128 u.jobs.append(j) |
128 u.jobs.append(j) |
129 |
129 |
130 o = Offer(name='sipgate_gold',provider="sipgate",route="gold",typ="sms") |
130 o = Offer(name='sipgate_gold',provider="sipgate",route="gold",typ="sms") |
131 u.rights.append(Userright(offer=o)) |
131 u.rights.append(Userright(offer=o)) |
132 |
132 |
133 j = Job(hash='a3',info='a',status='sended') |
133 j = Job(info='a',status='sended') |
134 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.5, offer=o)) |
134 j.messages.append(Message(recipient='0123456789', isBilled=False, date=datetime.now(), price=0.5, offer=o)) |
135 u.jobs.append(j) |
135 u.jobs.append(j) |
136 |
136 |
137 with self.session() as session: |
137 with self.session() as session: |
138 u=session.merge(u) |
138 u=session.merge(u) |