def excel_suite():
not_existed_tel = do_mysql.not_existed_tel()
register_excel = HandleExcel(DATA_COMMON_FILE_PATH, 'login')
register_excel_cases = register_excel.get_cases()
register_excel_re = re.sub(r'\${not_existed_tel}', not_existed_tel, str(register_excel_cases))
existed_tel = do_mysql.existed_tel()
register_cases = re.sub(r'\${existed_tel}', existed_tel, str(register_excel_re))
register_cases = eval(register_cases)
wb, ws = register_excel.load_excel()
wb.close()
return register_cases
def excel_suite():
register_excel = HandleExcel(DATA_COMMON_FILE_PATH, 'recharge') # 实例化对象
register_excel_cases = register_excel.get_cases() # 获取excel测试用例
register_cases = HandleContext.not_existed_tel(
HandleContext.investors_user_pwd(
HandleContext.investors_user_tel(
str(register_excel_cases)))) # 执行参数化替换
register_cases = eval(register_cases)
wb, ws = register_excel.load_excel()
wb.close()
return register_cases
def excel_suite():
register_excel = HandleExcel(DATA_COMMON_FILE_PATH, 'add') # 实例化对象
register_excel_cases = register_excel.get_cases() # 获取excel测试用例
register_cases = HandleContext.borrower_user_id(
HandleContext.manager_user_pwd(
HandleContext.manager_user_tel(
str(register_excel_cases)))) # 执行参数化替换
register_cases = eval(register_cases)
wb, ws = register_excel.load_excel()
wb.close()
return register_cases
