from mock import Mock
from libs import ddt
from common.Excel_handler import ExcelHandler
from common.Request_handler import RequestsHandle
from common.Logger_handler import LoggerHandler
from config.setting import config #小技巧：直接导入实例对象，避免路径被修改导致报错
from common.db_handler import DbHandler
from middleware.helper import generate_mobile
"""初始化日志处理器"""
logger=LoggerHandler()
"""读取"注册"表单中的数据"""
excel_handler = ExcelHandler(config.data_path())
data = excel_handler.sheet_readAll(config.read_yaml()["Excel_handler"]["sheet_register"]) # 从yaml中读取"注册"表单名称
@ddt.ddt
class TestRegister(unittest.TestCase):
def setUp(self) -> None: #前置条件
""" 连接数据库"""
self.db = DbHandler(host=config.read_yaml()["Database"]["host"], port=config.read_yaml()["Database"]["port"],
user=config.read_yaml()["Database"]["user"], password=config.read_yaml()["Database"]["password"],
charset=config.read_yaml()["Database"]["charset"], database=config.read_yaml()["Database"]["database"])
print("正在准备测试数据")
def tearDown(self) -> None: #后置条件
""" 关闭数据库游标和连接"""
self.db.close()
print("测试用例执行完毕")
import json
from mock import Mock
from decimal import Decimal
from common.db_handler import DbHandler
from libs import ddt
from common.Excel_handler import ExcelHandler
from common.Request_handler import RequestsHandle
from common.Logger_handler import LoggerHandler
from config.setting import config #小技巧：直接导入实例对象，避免路径被修改导致报错
from middleware.helper import Context, replace_label
"""初始化日志处理器"""
logger = LoggerHandler()
"""读取"新增项目"表单中的数据"""
excel_handler = ExcelHandler(config.data_path())
data = excel_handler.sheet_readAll(config.read_yaml()["Excel_handler"]
["sheet_loan_add"]) # 从yaml中读取"新增项目"表单名称
@ddt.ddt
class TestLoanAdd(unittest.TestCase):
def setUp(self) -> None: #前置条件
""" 连接数据库"""
self.db = DbHandler(
host=config.read_yaml()["Database"]["host"],
port=config.read_yaml()["Database"]["port"],
user=config.read_yaml()["Database"]["user"],
password=config.read_yaml()["Database"]["password"],
charset=config.read_yaml()["Database"]["charset"],
database=config.read_yaml()["Database"]["database"])
"""新增项目和登录的用例关联（或者用例依赖）"""
# 充值、新增项目、投资使用同一测试账号
import json
from mock import Mock
from decimal import Decimal
from common.db_handler import DbHandler
from libs import ddt
from common.Excel_handler import ExcelHandler
from common.Request_handler import RequestsHandle
from common.Logger_handler import LoggerHandler
from config.setting import config #小技巧：直接导入实例对象，避免路径被修改导致报错
from middleware.helper import Context, replace_label
"""初始化日志处理器"""
logger = LoggerHandler()
"""读取"投资"表单中的数据"""
excel_handler = ExcelHandler(config.data_path())
data = excel_handler.sheet_readAll(
config.read_yaml()["Excel_handler"]["sheet_invest"]) # 从yaml中读取"投资"表单名称
@ddt.ddt
class TestInvest(unittest.TestCase):
def setUp(self) -> None: #前置条件
""" 连接数据库"""
self.db = DbHandler(
host=config.read_yaml()["Database"]["host"],
port=config.read_yaml()["Database"]["port"],
user=config.read_yaml()["Database"]["user"],
password=config.read_yaml()["Database"]["password"],
charset=config.read_yaml()["Database"]["charset"],
database=config.read_yaml()["Database"]["database"])
"""投资和登录的用例关联（或者用例依赖）,而且充值、新增项目、投资使用同一测试账号"""
"""获取登录时生成的token"""
import json
from mock import Mock
from decimal import Decimal
from common.db_handler import DbHandler
from libs import ddt
from common.Excel_handler import ExcelHandler
from common.Request_handler import RequestsHandle
from common.Logger_handler import LoggerHandler
from config.setting import config #小技巧：直接导入实例对象，避免路径被修改导致报错
from middleware.helper import Context, replace_label
"""初始化日志处理器"""
logger = LoggerHandler()
"""读取"充值"表单中的数据"""
excel_handler = ExcelHandler(config.data_path())
data = excel_handler.sheet_readAll(
config.read_yaml()["Excel_handler"]["sheet_recharge"]) # 从yaml中读取"充值"表单名称
@ddt.ddt
class TestRecharge(unittest.TestCase):
def setUp(self) -> None: #前置条件
""" 连接数据库"""
self.db = DbHandler(
host=config.read_yaml()["Database"]["host"],
port=config.read_yaml()["Database"]["port"],
user=config.read_yaml()["Database"]["user"],
password=config.read_yaml()["Database"]["password"],
charset=config.read_yaml()["Database"]["charset"],
database=config.read_yaml()["Database"]["database"])
"""充值和登录的用例关联（或者用例依赖）"""
# 充值、新增项目、投资使用同一测试账号
import unittest
import json
from mock import Mock
from libs import ddt
from common.Excel_handler import ExcelHandler
from common.Request_handler import RequestsHandle
from common.Logger_handler import LoggerHandler
from config.setting import config #小技巧：直接导入实例对象，避免路径被修改导致报错
"""初始化日志处理器"""
logger = LoggerHandler()
"""读取"登录"表单中的数据"""
excel_handler = ExcelHandler(config.data_path())
data = excel_handler.sheet_readAll(
config.read_yaml()["Excel_handler"]["sheet_login"]) # 从yaml中读取"登录"表单名称
@ddt.ddt
class TestLogin(unittest.TestCase):
def setUp(self) -> None: #前置条件
print("正在准备测试数据")
def tearDown(self) -> None: #后置条件
print("测试用例执行完毕")
"""将 *data 当中的一组测试数据赋值到 data 这个参数"""
@ddt.data(*data)
def test_login(self, test_data):
"""