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 = []
