def test02case(self): u'''用例2:错误密码登录''' data = readExcel().get_excel_info('login', 3) self.info = RunMain().run_main('post', url, data) ss = json.loads(self.info) # 将响应转换为字典格式 self.assertEqual(ss['code'], 200) self.assertEqual(ss['message'], '登录成功')
def test01case(self): u'''用例1:登录正常系''' data = readExcel().get_excel_info('login', 2) #获取用例数据值,转换成为map类型 self.info = RunMain().run_main('post', url, data) ss = json.loads(self.info) # 将响应转换为字典格式 self.assertEqual(ss['code'], 200) self.assertEqual( ss['message'], '登录成功', )
def signa(): cls = readExcel().get_xls('userCase.xlsx', 'test') str = cls[0] print(str.get('case_name'))
""" import unittest import paramunittest import urllib.parse #导入相应的方法 from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility from common.configDB import DB #实例化参数 readconfig = ReadConfig() optionAgree_xls = readExcel().get_xls('userCase.xlsx', 'optionAgree') util = Utility() db = DB() @paramunittest.parametrized(*optionAgree_xls) class addProjectAudit(unittest.TestCase): #实例化Excel表中的数据 def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result:
import unittest import paramunittest import urllib.parse import time # 导入相应的方法 from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility from common.configDB import DB # 实例化参数 readconfig = ReadConfig() addProjectAudit_xls = readExcel().get_xls('userCase.xlsx', 'addProjectAudit') util = Utility() db = DB() # 准备数据 # del_sql = "delete from m_project_member where p_id=673 and user_id=15" # query_sql = "select * from m_project_member where p_id=673 and user_id=15" file = "../testFile/sqlFile/m_project_member" f = open(file, "r") read_data = f.readlines() @paramunittest.parametrized(*addProjectAudit_xls) class addProjectAudit(unittest.TestCase): # 实例化Excel表中的数据 def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name:
import unittest import paramunittest import urllib.parse import time # 导入相应的方法 from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility from common.configDB import DB # 实例化参数 readconfig = ReadConfig() collectProjectInfo_xls = readExcel().get_xls('userCase.xlsx', 'collectProjectInfo') util = Utility() db = DB() @paramunittest.parametrized(*collectProjectInfo_xls) class collectProjectInfo(unittest.TestCase): # 实例化Excel表中的数据 def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result:
import selenium import unittest import urllib.parse import paramunittest from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility readconfig = ReadConfig() getStatement_xls = readExcel().get_xls('userCase.xlsx', 'getStatement') util = Utility() @paramunittest.parametrized(*getStatement_xls) class testGetStatement(unittest.TestCase): def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result: :param path: :param expect_content: :return: """ self.case_no = str(case_no)
import requests import json import unittest from testFile.get_cookie import Get_Cookie from common.configHttp import RunMain import paramunittest from testFile.geturlParams import geturlParams from testFile.readExcel import readExcel url = geturlParams().get_Url() # 获取拼接到的url login_xls = readExcel().get_xls('userCase.xlsx', 'tian') @paramunittest.parametrized(*login_xls) class testUserTian(unittest.TestCase): def setParameters(self, case_name, path, query, method): self.case_name = case_name self.path = path self.query = query self.method = method def description(self): self.case_name def setUp(self): print(self.case_name + '测试前准备,看看我有咩有被执行!!!!') print('获取cookie') response1 = requests.get(url='http://127.0.0.1:9999/login', data={ "name": "xiaoming", "pwd": "111"
读取Excel中的测试用例,使用unittest来进行断言 """ import unittest import paramunittest import urllib.parse import time from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility from common.configDB import DB readconfig = ReadConfig() taskTypeInfo_xls = readExcel().get_xls('userCase.xlsx','taskTypeInfo') util = Utility() db=DB() headers = {'token':readconfig.get_token('token'),'userid':readconfig.get_userid('userid')} @paramunittest.parametrized(*taskTypeInfo_xls) class testTaskTypeInfo(unittest.TestCase): def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result: :param path: :param expect_content:
import json import unittest import sys sys.path.append("./") from common.configHttp import runMain import testFile.getUrlParams as getUrlParams import urllib.parse import paramunittest import testFile.readExcel as readExcel url = getUrlParams.getUrlParams().get_Url() login_xls = readExcel.readExcel().get_xls("userCase.xlsx", "login") @paramunittest.parametrized(*login_xls) class testUserLogin(unittest.TestCase): def setParameters(self, case_name, path, query, method): self.case_name = str(case_name) self.path = str(path) self.query = str(query) self.method = str(method) def description(self): self.case_name def setUp(self): print(self.case_name + "测试开始前准备") def tearDown(self):
""" 读取Excel中的测试用例,使用unittest来进行断言 """ import unittest import paramunittest import urllib.parse from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility readconfig = ReadConfig() Info_xls = readExcel().get_xls('userCase.xlsx', 'Info') util = Utility() # 调用我们的geturlParams获取我们拼接的url # url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'') @paramunittest.parametrized(*Info_xls) class testInfo(unittest.TestCase): def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result:
# @Time : 2020/3/6 14:39 # @Author : Mysunshine # @File : test01case.py # 读取userCase.xlsx中的用例,使用unittest来进行断言校验 import json import unittest from common.configHttp import RunMain import paramunittest from testFile import geturlParams import urllib.parse from testFile import readExcel url = geturlParams.geturlParams().get_Url() # login_xls返回值为嵌套列表 login_xls = readExcel.readExcel().get_xls('userCase.xlsx', 'login') headers = {'Content-Type': 'application/json'} # @paramunittest.parametrized参数化 @paramunittest.parametrized(*login_xls) class testUserLogin(unittest.TestCase): def setParameters(self, case_name, path, query, method): """ set params :param case_name:获取表格中case_name :param path:获取表格中path :param query:获取表格中query :param method:获取表格中method :return: """
""" 读取Excel中的测试用例,使用unittest来进行断言 """ import unittest import paramunittest import urllib.parse from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility readconfig = ReadConfig() checkDataTime_xls = readExcel().get_xls('userCase.xlsx', 'checkDataTime') util = Utility() # 调用我们的geturlParams获取我们拼接的url # url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'') @paramunittest.parametrized(*checkDataTime_xls) class TestcheckDataTime(unittest.TestCase): def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result:
# from testFile import get_token from testFile import geturlParams from testFile import readConfig from testFile import readExcel import urllib.parse from testFile import get_token #paramunittest是unittest实现参数化的一个专门的模块,可以传入多组参数,自动生成多个用例 # import paramunittest from ddt import ddt, data, unpack url = geturlParams.geturl_Now().get_url() #调用我们的geturlParams获取我们拼接的URL get_token = get_token.get_token() #实例化获取登录凭证 print(url) #读取Excel中的内容。获得列表数据,列表里的每一组就是一个用例 caselist_xls = readExcel.readExcel().get_xls('caselist.xlsx', 'Flash') # print(caselist_xls) #参数化获取的Excel数据 @paramunittest.parametrized(*caselist_xls) #列表里的每一组就是一个用例 class testFlash(unittest.TestCase): def setParameters(self, case_name, method, path, data): #初始化参数 """ set params :param case_name: :param path :param data :param method :return: """
""" 读取Excel中的测试用例,使用unittest来进行断言 """ import unittest import paramunittest import urllib.parse from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility readconfig = ReadConfig() index_xls = readExcel().get_xls('userCase.xlsx', 'index') util = Utility() # 调用我们的geturlParams获取我们拼接的url # url = geturlParams().get_url(readConfig.get_http('baseurl_first'),'') @paramunittest.parametrized(*index_xls) class testindex(unittest.TestCase): def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: :param expect_result:
import paramunittest import urllib.parse import time # 导入相应的方法 from testFile.geturlParams import geturlParams from testFile.readConfig import ReadConfig from testFile.readExcel import readExcel from common.configHttp import RunMain from common.util import Utility from common.configDB import DB from common.log import Logger # 实例化参数 readconfig = ReadConfig() getCollect_xls = readExcel().get_xls('userCase.xlsx', 'getCollect') util = Utility() db = DB() log = Logger().get_logger() @paramunittest.parametrized(*getCollect_xls) class getCollect(unittest.TestCase): # 实例化Excel表中的数据 def setParameters(self, case_no, case_name, path, parameter, method, expect_result, expect_content): """ :param case_no: :param case_name: :param parameter: :param method: