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 existed_tel(cls, data):
existed_tel_pattern = r'\${existed_tel}'
context_data = cls.judge_replace(existed_tel_pattern, do_mysql.existed_tel(), data)
return context_data