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(): 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, '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
import unittest import os from libs.ddt import ddt, data from scripts.handle_excel import HandleExcel from scripts.handle_config import config_read_file from scripts.constant import DATA_DIR from scripts.handle_requests import HandleRequest from scripts.handle_log import logger from scripts.handle_context import HandleContext # 读取excel do_excel = HandleExcel( os.path.join(DATA_DIR, config_read_file.get_value("excel", "case_excel")), "register") all_cases = do_excel.get_cases() @ddt class TestRegister(unittest.TestCase): """ 定义一个测试注册的测试类 """ @classmethod def setUpClass(cls): cls.resp = HandleRequest() logger.info("******************************************************") logger.info("{0}".format("开始执行用例")) @classmethod def tearDownClass(cls): cls.resp.close()
# @Author : YoYo import os import unittest from libs.ddt import ddt, data from scripts.constant_url import DATA_FILE_PATH, RESULT_EXCEL_FILE_PATH from scripts.handle_excel import HandleExcel from scripts.handle_log import Logging from scripts.handle_webservice_request import WebServiceRequests from suds.client import WebFault # 获取用例数据列表 handle_excel = HandleExcel() excel = handle_excel.get_exist_excel(DATA_FILE_PATH) cases = handle_excel.get_cases("send_msg") @ddt class TestSendMCode(unittest.TestCase): """发送验证码接口测试""" @classmethod def setUpClass(cls): cls.request = WebServiceRequests() cls.my_excel = HandleExcel() cls.my_excel.get_exist_excel( os.path.join(RESULT_EXCEL_FILE_PATH, "my_result.xlsx")) cls.case_list = [] @classmethod def tearDownClass(cls):
import unittest from suds.client import WebFault from libs.ddt import ddt, data from scripts.constant_url import DATA_FILE_PATH, RESULT_EXCEL_FILE_PATH from scripts.handle_context import Context from scripts.handle_excel import HandleExcel from scripts.handle_log import Logging from scripts.handle_webservice_request import WebServiceRequests from scripts.handle_mysql import HandleMySql # 获取用例数据列表 handle_excel = HandleExcel() excel = handle_excel.get_exist_excel(DATA_FILE_PATH) cases = handle_excel.get_cases("register") @ddt class TestUnRegister(unittest.TestCase): """注册接口测试""" @classmethod def setUpClass(cls): cls.request = WebServiceRequests() cls.my_excel = HandleExcel() cls.my_excel.get_exist_excel( os.path.join(RESULT_EXCEL_FILE_PATH, "my_result.xlsx")) cls.case_list = [] @classmethod def tearDownClass(cls):
import unittest from suds.client import WebFault from libs.ddt import ddt, data from scripts.constant_url import DATA_FILE_PATH, RESULT_EXCEL_FILE_PATH from scripts.handle_context import Context from scripts.handle_excel import HandleExcel from scripts.handle_log import Logging from scripts.handle_webservice_request import WebServiceRequests from scripts.handle_mysql import HandleMySql # 获取用例数据列表 handle_excel = HandleExcel() excel = handle_excel.get_exist_excel(DATA_FILE_PATH) cases = handle_excel.get_cases("verifyUserAuth") @ddt class TestVerifyUserAuth(unittest.TestCase): """注册接口测试""" @classmethod def setUpClass(cls): setattr(Context, "db_name", "user_db") cls.request = WebServiceRequests() cls.my_excel = HandleExcel() cls.handle_sql = HandleMySql() cls.my_excel.get_exist_excel( os.path.join(RESULT_EXCEL_FILE_PATH, "my_result.xlsx")) cls.case_list = []