def checkResult(self): url = geturlParams().get_url(readconfig.get_http('baseurl_first'), self.request_path) # 调用我们的geturlParams获取我们拼接的url new_url = url + self.request_data data = dict(urllib.parse.parse_qsl( urllib.parse.urlsplit( new_url).query)) # 将一个完整的URL中的name=&password=转换为{'username':'******','password':'******'} # 调用util进行加密 page = util.md5_join_b64(data.get("page", "")) type = util.md5_join_b64(data.get("type", "")) # # 把加密后的值在替换到相应的位置 data["page"] = page data["type"] = type info = RunMain().run_main(self.request_method, url,data=data) # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 ss = info.json() # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 if self.case_name == 'taskTypeInfo_success': # 如果case_name是login,说明合法,返回的code应该为200 self.assertEqual(self.expect_code, ss['code']) # 数据库断言,判断taskTypeInfo响应列表的长度是否与m_project查询的长度一致 now_time=time.time() sql="SELECT * FROM `m_project` WHERE `expire_time` > {} AND `stat` = 1 AND `type` IN ('21') ORDER BY create_time desc LIMIT 0,15".format(now_time) # 加数据库 res = db.check_user(sql) len01=len(res) self.assertEqual(len01,len(ss["data"])) if self.case_name == 'taskTypeInfo_error': # 同上 self.assertEqual(self.expect_code, ss['code'])
def chechResult(self): url = geturlParams().get_url(readconfig.get_http('baseurl_first'), self.request_path) # 调用我们的geturlParams获取我们拼接的url new_url = url + self.request_data data = dict(urllib.parse.parse_qsl( urllib.parse.urlsplit( new_url).query)) # 将一个完整的URL中的name=&password=转换为{'username':'******','password':'******'} info = RunMain().run_main(self.request_method, url, data) # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 ss = info.json() # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 if self.case_name == 'addProjectAudit_success': # 如果case_name是login,说明合法,返回的code应该为200 self.assertEqual(self.expect_code, ss['code']) # 数据表断言,检查接口是否新增成功,是否写入到表 self.assertTrue(db.check_user(read_data[1].replace("\n",""))) if self.case_name == 'addProjectAudit_error': # 同上 self.assertEqual(self.expect_code, ss['code'])
def chechResult(self): url = geturlParams().get_url( readconfig.get_http('baseurl_first'), self.request_path) # 调用我们的geturlParams获取我们拼接的url new_url = url + self.request_data data = dict( urllib.parse.parse_qsl(urllib.parse.urlsplit(new_url).query) ) # 将一个完整的URL中的name=&password=转换为{'username':'******','password':'******'} info = RunMain().run_main( self.request_method, url, data, files=None) # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 ss = info.json() # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 if self.case_name == 'optionAgree_success': # 如果case_name是login,说明合法,返回的code应该为200 self.assertEqual(self.expect_code, ss['code']) if self.case_name == 'optionAgree_error': # 同上 self.assertEqual(self.expect_code, ss['code'])
def checkResult(self): url = geturlParams().get_url( readconfig.get_http('baseurl_first'), self.request_path) # 调用我们的geturlParams获取我们拼接的url new_url = url + self.request_data data = dict( urllib.parse.parse_qsl(urllib.parse.urlsplit(new_url).query) ) # 将一个完整的URL中的name=&password=转换为{'username':'******','password':'******'} # 调用util进行加密 username = util.md5_join_b64(data.get("p_id", "")) user_pwd = util.md5_join_b64(data.get("user_id", "")) # # 把加密后的值在替换到相应的位置 data["p_id"] = username data["user_id"] = user_pwd info = RunMain().run_main( self.request_method, url, data, files=None) # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 ss = info.json() # 根据Excel中的method调用run_main来进行requests请求,并拿到响应 if self.case_name == 'getStatement_success': # 如果case_name是login,说明合法,返回的code应该为200 self.assertEqual(self.expect_code, ss['code']) if self.case_name == 'getStatement_error': # 同上 self.assertEqual(self.expect_code, ss['code'])
# -*- coding: utf-8 -*- # @Time : 2019/10/22 9:44 # @Author : Ji # @File : test01case.py import json import unittest import HTMLTestRunner from common.configHttp import RunMain from testFile import geturlParams from testFile.readExcel import readExcel from testFile.getpathInfo import get_Path from BeautifulReport import BeautifulReport url = geturlParams.geturlParams().get_Url() # 调用我们的geturlParams获取我们拼接的URL class testUserLogin(unittest.TestCase): def setUp(self): print("测试用例: {0}...".format(self._testMethodName)) pass 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'], '登录成功', )
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"
# -*- coding: utf-8 -*- # @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: