from class_0423.common.http_requests import http_requests from class_0423.common.do_excel import do_excel from class_0423.common.constants import excel_name, addloan_sheet from class_0423.common.regulax import regulax from class_0423.common.do_mysql import DoMysql from class_0423.common.log_config import log_config from ddt import ddt, data import unittest import json log = log_config(__name__) @ddt class addLoanTestcase(unittest.TestCase): case = do_excel(excel_name, addloan_sheet) cases = case.read() @classmethod def setUpClass(cls): cls.session = http_requests() cls.mysql = DoMysql() cls.datafill = do_excel(excel_name, addloan_sheet) @data(*cases) def test_addLoan(self, case): log.info("测试标题:{}".format(case.title)) if case.data.find("$(memberId)") > -1: sql = "SELECT MAX(id) FROM future.member " data = self.mysql.fetch_One(sql)["MAX(id)"] + 1 case.data = case.data.replace("$(memberId)", str(data))
def setUpClass(cls): cls.session = http_requests() cls.mysql = DoMysql() cls.datafill = do_excel(excel_name, addloan_sheet)
from class_0423.common.http_requests import http_requests from class_0423.common.do_excel import do_excel from class_0423.common.constants import excel_name, register_sheet from class_0423.common.do_mysql import DoMysql from class_0423.common.regulax import regulax from class_0423.common.log_config import log_config from ddt import ddt, data import unittest import json log = log_config(__name__) @ddt class registerTestcase(unittest.TestCase): case = do_excel(excel_name, register_sheet) cases = case.read() @classmethod def setUpClass(cls): cls.session = http_requests() cls.mysql = DoMysql() cls.datafill = do_excel(excel_name, register_sheet) @data(*cases) def test_register(self, case): log.info("测试标题:{}".format(case.title)) if case.check_sql: case.check_sql = regulax(case.check_sql) before = self.mysql.fetch_One(case.check_sql)["MAX(id)"] if case.data.find("136$(mobilephone)") > -1:
def setUpClass(cls): cls.session = http_requests() cls.datafill = do_excel(excel_name, login_sheet)
# @File : login_testcase.py from class_0423.common.http_requests import http_requests from class_0423.common.do_excel import do_excel from class_0423.common.constants import excel_name, login_sheet from class_0423.common.log_config import log_config from ddt import ddt, data from class_0423.common.regulax import regulax import unittest import json log = log_config(__name__) @ddt class loginTestcase(unittest.TestCase): case = do_excel(excel_name, login_sheet) cases = case.read() @classmethod def setUpClass(cls): cls.session = http_requests() cls.datafill = do_excel(excel_name, login_sheet) @data(*cases) def test_login(self, case): log.info("测试标题:{}".format(case.title)) case.data = regulax(case.data) resp = self.session.Session(case.method, case.url, case.data) self.datafill.write(resp.text, case.caseid + 1, 7) try: self.assertEqual((json.loads(case.expected)["status"]),
# @Author: xiaoxiao # @File : recharge_case.py from class_0423.common.http_requests import http_requests from class_0423.common.do_excel import do_excel from class_0423.common.constants import excel_name,recharge_sheet from class_0423.common.regulax import regulax from class_0423.common.do_mysql import DoMysql from class_0423.common.log_config import log_config from ddt import ddt,data import unittest import json log=log_config(__name__) @ddt class rechargeTestcase(unittest.TestCase): case = do_excel(excel_name,recharge_sheet) cases=case.read() @classmethod def setUpClass(cls): cls.session=http_requests() cls.mysql=DoMysql() cls.datafill = do_excel(excel_name, recharge_sheet) @data(*cases) def test_recharge(self,case): log.info("测试标题:{}".format(case.title)) case.data = regulax(case.data) if case.check_sql: case.check_sql = regulax(case.check_sql) before=self.mysql.fetch_One(case.check_sql)["leaveamount"] resp=self.session.Session(case.method,case.url,case.data) self.datafill.write(resp.text,case.caseid + 1, 7)
# @File : audit_testcase.py from class_0423.common.http_requests import http_requests from class_0423.common.do_excel import do_excel from class_0423.common.constants import excel_name,audit_sheet from class_0423.common.log_config import log_config from class_0423.common.regulax import regulax,Regulax from class_0423.common.do_mysql import DoMysql from ddt import ddt,data import unittest import json log=log_config(__name__) @ddt class auditTestcase(unittest.TestCase): case = do_excel(excel_name,audit_sheet) cases=case.read() @classmethod def setUpClass(cls): cls.session=http_requests() cls.mysql=DoMysql() cls.datafill=do_excel(excel_name,audit_sheet) @data(*cases) def test_audit(self,case): log.info("测试标题:{}".format(case.title)) if case.data.find("$(memberId)") > -1: sql = "SELECT MAX(id) FROM future.member " data = self.mysql.fetch_One(sql)["MAX(id)"] + 1 case.data = case.data.replace("$(memberId)", str(data)) if case.data.find("$(loanId)")>-1: sql="SELECT MAX(id) FROM future.loan"