def testchangepwdexcel(xlsfile=xlsfile1):
printtitle('START CHANGPWD')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
token = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
oldpwd=api_sheet.cell_value(i,3)
newpwd=api_sheet.cell_value(i,4)
ex_code = api_sheet.cell_value(i,5)
#print ex_code
ex_message=api_sheet.cell_value(i,6)
#print ex_message
#print newpwd
datatemp={'uid':uid,'oldpwd':oldpwd,'newpwd':newpwd,\
'token':token,'secretkey':secretkey}
#print data1
url='/user/changepwd'
testcodework(datatemp, url, ex_code)
def testorderlistexcel(xlsfile=xlsfile1):
printtitle('START testorderlistexcel')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
token = api_sheet.cell_value(i,1)
secretkey = api_sheet.cell_value(i,2)
orderType=api_sheet.cell_value(i,3) #租车订单数字ID
offset=api_sheet.cell_value(i,4)
ex_code = api_sheet.cell_value(i,5)
#print ex_code
ex_message=api_sheet.cell_value(i,6)
#print ex_message
#print newpwd
datatemp={'uid':uid,'orderType':orderType,'offset':offset,\
'token':token,'secretkey':secretkey}
#print data1
url='/order/list'
testcodework(datatemp, url, ex_code)
def testordercancheexcel(xlsfile=xlsfile1):
printtitle('START testordercancheexcel')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
token = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
id=api_sheet.cell_value(i,3) #租车订单数字ID
ex_code = api_sheet.cell_value(i,4)
#print ex_code
ex_message=api_sheet.cell_value(i,5)
#print ex_message
#print newpwd
datatemp={'uid':uid,'id':id,\
'token':token,'secretkey':secretkey}
#print data1
url='/order/canclecheck'
testcodework(datatemp, url, ex_code)
def testordercancleexcel(xlsfile=xlsfile1):
printtitle("START ordercancle")
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1, nrows):
uid = api_sheet.cell_value(i, 0) # 分别迭代表格中的client_id，password，sign和ex_code
# print mobile
token = api_sheet.cell_value(i, 1)
# print password
secretkey = api_sheet.cell_value(i, 2)
id = api_sheet.cell_value(i, 3) # 租车订单数字ID
ex_code = api_sheet.cell_value(i, 4)
# print ex_code
ex_message = api_sheet.cell_value(i, 5)
# print ex_message
# print newpwd
datatemp = {"uid": uid, "id": id, "token": token, "secretkey": secretkey}
# print data1
url = "/order/cancle"
testcodework(datatemp, url, ex_code)
def testwaldaybookexcel(xlsfile=xlsfile1):
printtitle('START testwaldaybookexcel')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
ncols=api_sheet.ncols
print ncols
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
token = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
offset=api_sheet.cell_value(i,3)
ex_code = api_sheet.cell_value(i,4)
ex_message=api_sheet.cell_value(i,5)
#print ex_message
datatemp={'uid':uid,'token':token,'secretkey':secretkey,'offset':offset}
#print data1
url='/wallet/daybook'
testcodework(datatemp, url, ex_code)
def testinvoidelexcel(xlsfile=xlsfile1):
printtitle('START TESTlogout')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
token = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
invoiceTitleId=api_sheet.cell_value(i,3)
ex_code = api_sheet.cell_value(i,4)
#print ex_code
ex_message=api_sheet.cell_value(i,5)
#print ex_message
datatemp={'uid':uid,'token':token,'secretkey':secretkey,'invoiceTitleId':invoiceTitleId}
#print data1
url='/invoice/deltitle'
testcodework(datatemp, url, ex_code)
def testloginexcel(xlsfile=xlsfile1):
printtitle('START testlogin')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
mobile = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
password = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
ex_code = api_sheet.cell_value(i,3)
#print ex_code
ex_message=api_sheet.cell_value(i,4)
#print ex_message
datatemp = {'mobile':mobile,'passwd':password,'secretkey':secretkey} #三个参数的值作为请求接口时要带上的数据
url='/user/login'
testcodework(datatemp, url, ex_code)
def testmisgetarea(xlsfile=xlsfile1):
printtitle('START testmisgetarea')
book = xlrd.open_workbook(xlsfile)
api_sheet = book.sheet_by_index(0)
nrows = api_sheet.nrows
for i in range(1,nrows):
uid = api_sheet.cell_value(i,0) # 分别迭代表格中的client_id，password，sign和ex_code
#print mobile
token = api_sheet.cell_value(i,1)
#print password
secretkey = api_sheet.cell_value(i,2)
cityId=api_sheet.cell_value(i,3)
ex_code = api_sheet.cell_value(i,4)
ex_message=api_sheet.cell_value(i,5)
#print ex_message
datatemp={'uid':uid,'token':token,'secretkey':secretkey,'cityId':cityId}
#print data1
url='/mis/getareas'
testcodework(datatemp, url, ex_code)