def testroutetestcontrl(self):
'''
test997 1: pickup ORDERS*1 ask confirm ORDERS*2 gen & send ORDERS*2
send confirm ORDERS*1 gen & send CONTRL*1
test997 2: receive CONTRL*1 confirm ORDERS*1 gen xml*1
receive ORDERS*2 ask confirm ORDERS*3 gen ORDERS*3
send confirm ORDERS*2 gen & send CONTRL*2
test997 3: receive CONTRL*2 confirm ORDERS*2 gen & send xml (to trash)
send ORDERS*3 (to trash)
send xml (to trash)
'''
lijst = utilsunit.getdir(os.path.join(botssys, 'outfile/confirm/edifact/*'))
self.failUnless(len(lijst) == 0)
lijst = utilsunit.getdir(os.path.join(botssys, 'outfile/confirm/trash/*'))
self.failUnless(len(lijst) == 6)
counter = 0
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status': 400, 'statust': DONE, 'idroute': 'testcontrl', 'confirmtype': 'ask-edifact-CONTRL', 'confirmasked': True}):
counter += 1
if counter == 1:
self.failUnless(not row[str('confirmed')])
self.failUnless(row[str('confirmidta')] == 0)
elif counter == 2:
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')] != 0)
else:
break
else:
self.failUnless(counter != 0)
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status': 310, 'statust': DONE, 'idroute': 'testcontrl', 'confirmtype': 'send-edifact-CONTRL', 'confirmasked': True}):
counter += 1
if counter <= 2:
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')] != 0)
else:
break
else:
self.failUnless(counter != 0)
def testroutetest997(self):
'''
test997 1: pickup 850*1 ask confirm 850*2 gen & send 850*2
send confirm 850*1 gen & send 997*1
test997 2: receive 997*1 confirm 850*1 gen xml*1
receive 850*2 ask confirm 850*3 gen 850*3
send confirm 850*2 gen & send 997*2
test997 3: receive 997*2 confirm 850*2 gen & send xml (to trash)
send 850*3 (to trash)
send xml (to trash)
'''
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/x12/*'))
self.failUnless(len(lijst)==0)
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/trash/*'))
self.failUnless(len(lijst)==6)
counter=0
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':400,'statust':DONE,'idroute':'test997','confirmtype':'ask-x12-997','confirmasked':True}):
counter += 1
if counter == 1:
self.failUnless(not row[1])
self.failUnless(row[2]==0)
elif counter == 2:
self.failUnless(row[1])
self.failUnless(row[2]!=0)
else:
break
else:
self.failUnless(counter!=0)
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':310,'statust':DONE,'idroute':'test997','confirmtype':'send-x12-997','confirmasked':True}):
counter += 1
if counter <= 2:
self.failUnless(row[1])
self.failUnless(row[2]!=0)
else:
break
else:
self.failUnless(counter!=0)
def testroutetestcontrl(self):
'''
test997 1: pickup ORDERS*1 ask confirm ORDERS*2 gen & send ORDERS*2
send confirm ORDERS*1 gen & send CONTRL*1
test997 2: receive CONTRL*1 confirm ORDERS*1 gen xml*1
receive ORDERS*2 ask confirm ORDERS*3 gen ORDERS*3
send confirm ORDERS*2 gen & send CONTRL*2
test997 3: receive CONTRL*2 confirm ORDERS*2 gen & send xml (to trash)
send ORDERS*3 (to trash)
send xml (to trash)
'''
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/edifact/*'))
self.failUnless(len(lijst)==0)
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/trash/*'))
self.failUnless(len(lijst)==6)
counter=0
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':400,'statust':DONE,'idroute':'testcontrl','confirmtype':'ask-edifact-CONTRL','confirmasked':True}):
counter += 1
if counter == 1:
self.failUnless(not row[str('confirmed')])
self.failUnless(row[str('confirmidta')]==0)
elif counter == 2:
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')]!=0)
else:
break
else:
self.failUnless(counter!=0)
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':310,'statust':DONE,'idroute':'testcontrl','confirmtype':'send-edifact-CONTRL','confirmasked':True}):
counter += 1
if counter <= 2:
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')]!=0)
else:
break
else:
self.failUnless(counter!=0)
def testroutetestmdn2(self):
lijst = utilsunit.getdir(
os.path.join(botssys, 'outfile/confirm/mdn2/*'))
self.failUnless(len(lijst) == 0)
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''', {
'status': 510,
'statust': DONE,
'idroute': 'testmdn2',
'confirmtype': 'ask-email-MDN',
'confirmasked': True
}):
self.failUnless(not row[1])
self.failUnless(row[2] == 0)
break
else:
self.failUnless(1 == 0)
def testroutetestmdn(self):
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/mdn/*'))
self.failUnless(len(lijst)==0)
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':210,'statust':DONE,'idroute':'testmdn','confirmtype':'send-email-MDN','confirmasked':True}):
self.failUnless(row[1])
self.failUnless(row[2]!=0)
break
else:
self.failUnless(1==0)
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''',
{'status':510,'statust':DONE,'idroute':'testmdn','confirmtype':'ask-email-MDN','confirmasked':True}):
self.failUnless(row[1])
self.failUnless(row[2]!=0)
break
else:
self.failUnless(1==0)
def testroutetestmdn2(self):
lijst = utilsunit.getdir(os.path.join(botssys, "outfile/confirm/mdn2/*"))
self.failUnless(len(lijst) == 0)
nr_rows = 0
for row in botslib.query(
"""SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
AND frommail != ''
ORDER BY idta DESC
""",
{
"status": 500,
"statust": DONE,
"idroute": "testmdn2",
"confirmtype": "ask-email-MDN",
"confirmasked": True,
},
):
nr_rows += 1
self.failUnless(not row[str("confirmed")])
self.failUnless(row[str("confirmidta")] == 0)
else:
self.failUnless(nr_rows == 1)
def testroutetestmdn(self):
lijst = utilsunit.getdir(os.path.join(botssys,
'outfile/confirm/mdn/*'))
self.failUnless(len(lijst) == 0)
nr_rows = 0
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
AND frommail != ''
ORDER BY idta DESC
''', {
'status': 220,
'statust': DONE,
'idroute': 'testmdn',
'confirmtype': 'send-email-MDN',
'confirmasked': True
}):
nr_rows += 1
print(row[str('idta')], row[str('confirmed')],
row[str('confirmidta')])
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')] != 0)
else:
self.failUnless(nr_rows == 1)
nr_rows = 0
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
AND frommail != ''
ORDER BY idta DESC
''', {
'status': 500,
'statust': DONE,
'idroute': 'testmdn',
'confirmtype': 'ask-email-MDN',
'confirmasked': True
}):
nr_rows += 1
self.failUnless(row[str('confirmed')])
self.failUnless(row[str('confirmidta')] != 0)
else:
self.failUnless(nr_rows == 1)
def testroutetestmdn2(self):
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/mdn2/*'))
self.failUnless(len(lijst)==0)
nr_rows = 0
for row in botslib.query(u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
AND frommail != ''
ORDER BY idta DESC
''',
{'status':500,'statust':DONE,'idroute':'testmdn2','confirmtype':'ask-email-MDN','confirmasked':True}):
nr_rows += 1
self.failUnless(not row['confirmed'])
self.failUnless(row['confirmidta']==0)
else:
self.failUnless(nr_rows==1)
def testrouteotherx12(self):
lijst = utilsunit.getdir(os.path.join(botssys,'outfile/confirm/otherx12/*'))
self.failUnless(len(lijst)==15)
def testroutetest997(self):
'''
test997 1: pickup 850; send 850 (ask confirm) and 997
test997 2: receive 997 and 850; send 997
test997 3: send 997 and 850 to trash
test997 4: receive 997; 997 to trash
'''
lijst = utilsunit.getdir(os.path.join(botssys,
'outfile/confirm/x12/*'))
self.failUnless(len(lijst) == 0)
lijst = utilsunit.getdir(
os.path.join(botssys, 'outfile/confirm/trash/*'))
self.failUnless(len(lijst) == 3)
counter = 0
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''', {
'status': 400,
'statust': DONE,
'idroute': 'test997',
'confirmtype': 'ask-x12-997',
'confirmasked': True
}):
counter += 1
if counter == 1:
self.failUnless(not row[1])
self.failUnless(row[2] == 0)
elif counter == 2:
self.failUnless(row[1])
self.failUnless(row[2] != 0)
else:
break
else:
self.failUnless(counter != 0)
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''', {
'status': 310,
'statust': DONE,
'idroute': 'test997',
'confirmtype': 'send-x12-997',
'confirmasked': True
}):
counter += 1
if counter <= 2:
self.failUnless(row[1])
self.failUnless(row[2] != 0)
else:
break
else:
self.failUnless(counter != 0)
def testrouteotherx12(self):
lijst = utilsunit.getdir(
os.path.join(botssys, 'outfile/confirm/otherx12/*'))
self.failUnless(len(lijst) == 15)
def testroutetest997(self):
'''
test997 1: pickup 850*1 ask confirm 850*2 gen & send 850*2
send confirm 850*1 gen & send 997*1
test997 2: receive 997*1 confirm 850*1 gen xml*1
receive 850*2 ask confirm 850*3 gen 850*3
send confirm 850*2 gen & send 997*2
test997 3: receive 997*2 confirm 850*2 gen & send xml (to trash)
send 850*3 (to trash)
send xml (to trash)
'''
lijst = utilsunit.getdir(os.path.join(botssys,
'outfile/confirm/x12/*'))
self.failUnless(len(lijst) == 0)
lijst = utilsunit.getdir(
os.path.join(botssys, 'outfile/confirm/trash/*'))
self.failUnless(len(lijst) == 6)
counter = 0
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''', {
'status': 400,
'statust': DONE,
'idroute': 'test997',
'confirmtype': 'ask-x12-997',
'confirmasked': True
}):
counter += 1
if counter == 1:
self.failUnless(not row['confirmed'])
self.failUnless(row['confirmidta'] == 0)
elif counter == 2:
self.failUnless(row['confirmed'])
self.failUnless(row['confirmidta'] != 0)
else:
break
else:
self.failUnless(counter != 0)
for row in botslib.query(
u'''SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
''', {
'status': 310,
'statust': DONE,
'idroute': 'test997',
'confirmtype': 'send-x12-997',
'confirmasked': True
}):
counter += 1
if counter <= 2:
self.failUnless(row['confirmed'])
self.failUnless(row['confirmidta'] != 0)
else:
break
else:
self.failUnless(counter != 0)
def testroutetestcontrl(self):
"""
test997 1: pickup ORDERS*1 ask confirm ORDERS*2 gen & send ORDERS*2
send confirm ORDERS*1 gen & send CONTRL*1
test997 2: receive CONTRL*1 confirm ORDERS*1 gen xml*1
receive ORDERS*2 ask confirm ORDERS*3 gen ORDERS*3
send confirm ORDERS*2 gen & send CONTRL*2
test997 3: receive CONTRL*2 confirm ORDERS*2 gen & send xml (to trash)
send ORDERS*3 (to trash)
send xml (to trash)
"""
lijst = utilsunit.getdir(os.path.join(botssys, "outfile/confirm/edifact/*"))
self.failUnless(len(lijst) == 0)
lijst = utilsunit.getdir(os.path.join(botssys, "outfile/confirm/trash/*"))
self.failUnless(len(lijst) == 6)
counter = 0
for row in botslib.query(
"""SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
""",
{
"status": 400,
"statust": DONE,
"idroute": "testcontrl",
"confirmtype": "ask-edifact-CONTRL",
"confirmasked": True,
},
):
counter += 1
if counter == 1:
self.failUnless(not row[str("confirmed")])
self.failUnless(row[str("confirmidta")] == 0)
elif counter == 2:
self.failUnless(row[str("confirmed")])
self.failUnless(row[str("confirmidta")] != 0)
else:
break
else:
self.failUnless(counter != 0)
for row in botslib.query(
"""SELECT idta,confirmed,confirmidta
FROM ta
WHERE status=%(status)s
AND statust=%(statust)s
AND idroute=%(idroute)s
AND confirmtype=%(confirmtype)s
AND confirmasked=%(confirmasked)s
ORDER BY idta DESC
""",
{
"status": 310,
"statust": DONE,
"idroute": "testcontrl",
"confirmtype": "send-edifact-CONTRL",
"confirmasked": True,
},
):
counter += 1
if counter <= 2:
self.failUnless(row[str("confirmed")])
self.failUnless(row[str("confirmidta")] != 0)
else:
break
else:
self.failUnless(counter != 0)