from models.soap import SoapMethods
class SQLActivateDeal:
def getDealForActivate(self):
s = 'SELECT ar.extclientid, ag.legalcontractnum, ag.charactseller, ag.statusagrid ' \
'FROM alf_registercontractlog ar ' \
'JOIN privateclients pc on pc.extclientprivid = ar.extclientid ' \
'JOIN agreements ag on ag.clientprivid = pc.clientprivid ' \
'WHERE ar.activate = 0 ' \
'AND ar.errorcode = 0 AND ag.statusagrid = 1 and ag.charactseller is not null ' \
'AND ag.legalcontractnum = ag.charactseller ' \
'AND ROWNUM = 1'
return s
def checkDealForActivateStatus(self, charactseller):
bind = {"charactseller": str(charactseller)}
s = 'select ag.statusagrid ' \
'from IC.Agreements ag ' \
'where ag.legalcontractnum = :bind' #+ str(cardNumber)
cur = {"s": s, "bind": bind}
return cur
if __name__ == '__main__':
obj = SoapMethods()
#print(obj.openXlsFile('D:\Python\SOAP\delivery12.xlsx'))
print(obj.dbConnect(db='ISCARDT2_AIX').execute(SQLActivateDeal().getDealForActivate()).fetchall())
t = SQLActivateDeal().checkDealForActivateStatus(630007040)
cur = obj.dbConnect(db='ISCARDT2_AIX').execute(t["s"], bind=str(t["bind"]["charactseller"])).fetchall()
print(cur)
class SQLActivateCard:
def getCardForActivate(self):
s = 'select c.cardnum as cardNumber, pr.cidentcode as taxid, pr.pnumber as passportNumber, pr.mobilephone as phoneNumber ' \
'from IC.Cards c ' \
'join IC.Agreements ag on ag.contractid = c.contractid ' \
'join IC.Privateclients pr on ag.clientprivid = pr.clientprivid ' \
'where c.cardstatusid = 1 and rownum = 1'
return s
def checkCardForActivateStatus(self, cardNumber):
bind = {"cardNumber": str(cardNumber)}
s = 'select c.cardstatusid ' \
'from IC.Cards c ' \
'where c.cardnum = :bind' #+ str(cardNumber)
cur = {"s": s, "bind": bind}
return cur
if __name__ == '__main__':
obj = SoapMethods()
#print(obj.openXlsFile('D:\Python\SOAP\delivery12.xlsx'))
print(
obj.dbConnect(db='ISCARDT2_AIX').execute(
SQLActivateCard().getCardForActivate()).fetchall())
t = SQLActivateCard().checkCardForActivateStatus(4226051550023777)
cur = obj.dbConnect(db='ISCARDT2_AIX').execute(
t["s"], bind=str(t["bind"]["cardNumber"])).fetchall()
print(cur)
from models.soap import SoapMethods
from sql.sql_activateCardDeal import SQLActivateDeal
obj = SoapMethods()
sql = SQLActivateDeal()
#test_set = obj.openConfig()["testSet"]["getCards"] # набор данных для теста с test_data.json
param = obj.openConfig()["testSet"]["card"]
wsdl = obj.openConfig()["wsdl"][param]
connect = obj.dbConnect("ISCARDT2_AIX")
def test_activateCardDeal():
#res = obj.connectToWebService(wsdl).service.activateCardDeal(contragentId='2942575', dealNo='650121251')
sql_res = connect.execute(sql.getDealForActivate()).fetchall()
res = obj.connectToWebService(wsdl).service.activateCardDeal(
contragentId=sql_res[0][0], dealNo=sql_res[0][1])
t = sql.checkDealForActivateStatus(sql_res[0][1])
r = connect.execute(t["s"],
bind=str(t["bind"]["charactseller"])).fetchall()[0]
assert str(r[0]) == '0'
obj.closeDBConnect(connect)
print(res)
#assert len(res) == 0