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)
Exemple #5
0
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)
Exemple #7
0
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)