def setUp(self):
self.session = requests.session()
self.base_url = Utility.read_json("../../config/data_base")["BASEURL"]
# 登陆（咨询主管：郑雪姣）、解密
counselor_login_path = "../../test_data/login_data/counselor_login_data"
decode_path = "../../test_data/login_data/decode_data"
Service.get_login_decode(self.base_url, self.session, counselor_login_path, decode_path)
def setUp(self):
self.session = requests.session()
self.base_url = self.base_url = Utility.read_json("../../config/data_base")["BASEURL"]
# 登陆（咨询主管：李毅）、解密
teacher_login_path = "../../test_data/login_data/teacher_manage_login_data"
decode_path = "../../test_data/login_data/decode_data"
Service.get_login_decode(self.base_url, self.session, teacher_login_path, decode_path)
def setUp(self):
self.session = requests.session()
# 登陆、解密
Service.get_login(
self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "咨询主管")
Service.get_decode(
self.session, "C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/decode.xlsx",
"decode", 2, 4, 7)
def test_query_allocation_resource(self, param):
resp = Service.post_arguments(self.session, param["url"], param["step"])
sql_count = Service.allot_resource_query_sql(param["step"], "../config/data_base")
if int(resp.json()["totalRow"]) == sql_count:
actual = "query-success"
else:
actual = "query-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_login_decode(self, param):
Service.post_arguments(self.session, login_info[0], login_info[1])
decode_resp = Service.post_arguments(self.session, param["url"],
param["step"])
if decode_resp.text == "yes":
actual = "decode-success"
else:
actual = "decode-fail"
self.assertEqual(actual, param["expect"])
def setUp(self):
self.session = requests.session()
self.base_url = Utility.read_json("../../config/data_base")["BASEURL"]
# 登录
login_data = Utility.read_json("../../test_data/login_data/login_data")
login_url = self.base_url + login_data[0][0]["login_url"]
Service.login(self.session, login_url, login_data[0][1])
# 解密
decode_data = Utility.read_json("../../test_data/login_data/decode_data")
decode_url = self.base_url + decode_data[0][0]["decode_url"]
Service.decode(self.session, decode_url, decode_data[0][1])
def test_update_deliver_resource(self, param):
sql_count_one = Service.update_deliver_resource_query_sql(
param["step"], "../config/data_base")
Service.post_arguments(self.session, param["url"], param["step"])
sql_count_two = Service.update_deliver_resource_query_sql(
param["step"], "../config/data_base")
# 断言
if sql_count_two > sql_count_one:
actual = "update-success"
else:
actual = "update-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_open_page(self, param):
open_page_resp = Service.get_no_arguments(self.session, param["url"])
if "BOSS系统" in open_page_resp.text:
actual = "open-page-pass"
else:
actual = "open-page-fail"
self.assertEqual(actual, param["expect"])
def test_scale_allocation_resource(self, param):
resp = Service.post_arguments(self.session, param["url"], param["step"])
if "success" == resp.text:
actual = "scale-allot-success"
else:
actual = "scale-allot-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_commit_allocating_resource(self, url, commit_allocating_resource_info, expect):
open_allocating_resource_url = self.base_url + url["commit_allocating_resource_info"]
# 提交前，看数量
sql = "select count(work_id) from customer where work_id='%s'" % (commit_allocating_resource_info["work_id"])
count_work_id = Utility.get_connect_one(sql, '../../config/data_base')
# 响应为空
Service.post_arguments(self.session, open_allocating_resource_url, commit_allocating_resource_info)
# 提交后
count_work_id_commit = Utility.get_connect_one(sql, '../../config/data_base')
# 无响应，数据库查询
if count_work_id_commit[0] >= count_work_id[0]:
actual = "commit-allocating-resource-pass"
else:
actual = "commit-allocating-resource-fail"
self.assertEqual(actual, expect)
def test_open_allocating_resource(self, url, expect):
open_allocating_resource_url = self.base_url + url["open_allocating_resource_url"]
open_allocating_resource_resp = Service.get_no_arguments(self.session, open_allocating_resource_url)
if "分配资源" in open_allocating_resource_resp.text:
actual = "open-allocating-resource-pass"
else:
actual = "open-allocating-resource-fail"
self.assertEqual(actual, expect)
def test_claim(self, url, claim_info, expect):
claim_url = self.base_url + url["claim_url"]
# 提交前，看数量
sql = "select count(work_id) from customer where pool_type='public'"
count_sql = Utility.get_connect_one(sql, '../../config/data_base')
# 无响应
Service.post_arguments(self.session, claim_url, claim_info)
# 提交后
count_sql_again = Utility.get_connect_one(sql,
'../../config/data_base')
# 无响应，数据库查询
if count_sql_again[0] <= count_sql[0]:
# 响应断言
actual = "claim-pass"
else:
actual = "claim-pass"
self.assertEqual(actual, expect)
def test_open_training_resource(self, param):
resp = Service.get_no_arguments(self.session, param["url"])
if "培训资源" in resp.text:
actual = "open-training-success"
else:
actual = "open-training-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_page_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
if int(resp.json()["pageNumber"]) == int(param["step"]["pageIndex"]):
actual = "page-success"
else:
actual = "page-fail"
self.assertEqual(actual, param["expect"])
def test_login(self, param):
login_resp = Service.post_arguments(self.session, param["url"],
param["step"])
if login_resp.text == "success":
actual = "login-success"
else:
actual = "login-fail"
self.assertEqual(actual, param["expect"])
def test_claim_public_resource(self, param):
resp = Service.post_arguments(self.session, param["url"], param["step"])
if re.match('\d+', resp.text):
actual = "claim-public-success"
else:
actual = "claim-public-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_claim_public_resource(self, param):
resp = Service.get_no_arguments(self.session, param["url"])
if "公共资源" in resp.text:
actual = "claim-public-success"
else:
actual = "open-public-source-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_open_common_resource_pool(self, url, expect):
open_common_resource_pool_url = self.base_url + url[
"open_common_resource_pool_url"]
open_common_resource_pool_resp = Service.get_no_arguments(
self.session, open_common_resource_pool_url)
if "公共资源池" in open_common_resource_pool_resp.text:
actual = "open-common-resource-pool-pass"
else:
actual = "open-common-resource-pool-fail"
self.assertEqual(actual, expect)
def test_add_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
if "新增成功" in resp.text:
actual = "add-training-success"
else:
actual = "add-training-fail"
# 断言
self.assertEqual(actual, param["expect"])
def test_abandon_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
# 响应文本
if "废弃资源完成" in resp.text:
actual = "abandon-success"
else:
actual = "abandon-fail"
self.assertEqual(actual, param["expect"])
def test_open_tracking_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
# 解密、日期格式（创建日期）
result = Utility.get_secret(resp.text).split("&")[1]
if re.match('20\d{2}-\d{2}-\d{2} \d{2}:\d{2}', result):
actual = "open-tracking-success"
else:
actual = "open-tracking-fail"
self.assertEqual(actual, param["expect"])
def test_tracking_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
# 响应文本
if "修改成功" in resp.text:
actual = "modify-success"
else:
actual = "modify-fail"
self.assertEqual(actual, param["expect"])
def test_target_tracking_training_resource(self, param):
resp = Service.post_arguments(self.session, param["url"],
param["step"])
sql = "select tracking_times from customer where customer_id = '%s'" % (
param["step"]["id"])
count_one = Utility.get_connect_one(sql, "../config/data_base")[0]
if count_one == len(resp.json()):
actual = "target-tracking-success"
else:
actual = "target-tracking-fail"
self.assertEqual(actual, param["expect"])
def test_query_common_resource_pool(self, url,
query_common_resource_pool_info,
expect):
# 数据准备，调用
query_common_resource_pool_url = self.base_url + url[
"query_common_resource_pool_url"]
query_common_resource_pool_resp = Service.post_arguments(
self.session, query_common_resource_pool_url,
query_common_resource_pool_info)
query_common_resp_result = query_common_resource_pool_resp.json()
# 查询数据库
sql = Service.sql_query_common_resource_pool(
query_common_resource_pool_info,
"../../config/query_common_resource_pool_sql")
sql_result = Utility.get_connect_one(sql, "../../config/data_base")
# 响应数据数量
if sql_result[0] == query_common_resp_result["totalRow"]:
actual = "query-common-resource-pass"
else:
actual = "query-common-resource-fail"
self.assertEqual(actual, expect)
def test_query_allocating_resource(self, url, allocating_resource_info, expect):
# 数据准备
query_allocating_resource_url = self.base_url + url["query_allocating_resource_url"]
query_allocating_resource_resp = Service.post_arguments(
self.session, query_allocating_resource_url, allocating_resource_info)
query_result = query_allocating_resource_resp.json()
# 拼接sql
sql = Service.sql_query_trans_feree(allocating_resource_info, "../../config/transferee_query_sql")
# 调用数据库
sql_result = Utility.get_connect_one(sql, "../../config/data_base")
# print(sql_result)
# 断言
if sql_result[0] == query_result["totalRow"]:
actual = "query-trans-feree-pass"
else:
actual = "query-trans-feree-pass"
self.assertEqual(actual, expect)
def test_tracking_training_resource(self, param):
sql = "select count(tracking_record_id) from tracking_record"
count_one = Utility.get_connect_one(sql, "../config/data_base")[0]
resp = Service.post_arguments(self.session, param["url"],
param["step"])
# 解密、日期格式（创建日期）
count_two = Utility.get_connect_one(sql, "../config/data_base")[0]
if resp.text == "newStudent" or count_two > count_one:
actual = "tracking-success"
else:
actual = "tracking-fail"
self.assertEqual(actual, param["expect"])
def test_query_training_resource(self, url, query_training_resource_info, decode_info, expect):
# 数据准备
query_training_resource_url = self.base_url + url["query_training_resource_url"]
query_training_resource_resp = TrainingResource.query_training_resource(
self.session, query_training_resource_url, query_training_resource_info)
query_result = query_training_resource_resp.json()
# 拼接sql
sql = Service.sql_query_training_resource(decode_info, "../../config/base_sql")
# 调用数据库
sql_result = Utility.get_connect_one(sql, "../../config/data_base")
# 断言
if sql_result[0] == query_result["totalRow"] and WoniuBoss.decode(
decode_info["cusInfo"]) == query_result["list"][0]["name"]:
actual = "query-training-resource-pass"
else:
actual = "query-training-resource-fail"
self.assertEqual(actual, expect)
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
# 登录页
open_deliver_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"deliver_resource", "open", 2, 4, 7)
query_deliver_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"deliver_resource", "query", 2, 4, 7)
update_deliver_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"deliver_resource", "update", 2, 4, 7)
class DeliverResourceTest(unittest.TestCase):
# 自定义, 咨询主管账户
def setUp(self):
self.session = requests.session()
# 登陆、解密
Service.get_login(
self.session,
"C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx",
"管理员")
Service.get_decode(
self.session,
import requests
from parameterized import parameterized
from interface.util.Service import Service
import unittest
# 打开首页
roles = Service.get_role_info(
"C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "讲师")
# 首页
open_page_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"open_page", "open", 2, 4, 7)
# 登录页
login_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"login", "login", 2, 4, 7)
# 解密
decode_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"decode", "decode", 2, 4, 7)
# 登陆账户
login_info = Service.get_role_info(
"C:/Users/wang/Desktop/woniuboss4.0/interface/config/roles.xlsx", "咨询主管")
class LoginTest(unittest.TestCase):
import re
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
from interface.util.Utility import Utility
# 登录页
open_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "open", 2, 4, 7)
add_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "add", 2, 4, 7)
query_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "query", 2, 4, 7)
page_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "paging", 2, 4, 7)
open_tracking_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "oTracking", 2, 4, 7)
tracking_training_resource_data = Service.get_excell_data(
"C:/Users/wang/Desktop/woniuboss4.0/interface/test_data/testCase.xlsx",
"training-resource", "save", 2, 4, 7)
