def query_deliver_resource_query_sql(cls, query_info, path):
base_sql = "select count(customer_id) from customer where true"
# 地区
if query_info["region"] != "全部" and query_info["region"] != "":
base_sql = base_sql + " and region_id='%s'" % (
query_info["region"])
# 部门
if query_info["deptId"] != "全部" and query_info["deptId"] != "":
base_sql = base_sql + " and department_id='%s'" % (
query_info["deptId"])
# 最后废弃人(从老师到废弃表中查询，自己废弃的记录，再来匹配，public状态的)
if query_info["workId"] != "全部" and query_info["workId"] != "":
customer_sql = "select customer_id from abandon_record where work_id='%s';" % (
query_info["workId"])
customer_id = Utility.get_connect_one(customer_sql, path)[0]
base_sql = base_sql + " and work_id in '%s'" % (customer_id)
# 状态 lastStatus
if query_info["status"] != "全部" and query_info["status"] != "":
base_sql = base_sql + " and last_status='%s'" % (
query_info["status"])
# 来源
if query_info["source"] != "全部" and query_info["source"] != "":
base_sql = base_sql + " and source='%s'" % (query_info["source"])
# 姓名
if query_info["cusInfo"] != "" and query_info["cusInfo"] == "小红旗":
info = "30DEFFB90BC0E5B38AF9118A5E8B2309"
base_sql = base_sql + " and name='%s'" % (info)
return Utility.get_connect_one(base_sql + ";", path)[0]
def get_login_decode(cls, base_url, session, login_path, decode_path):
# 登录
login_data = Utility.read_json(login_path)
login_url = base_url + login_data[0][0]["login_url"]
Service.login(session, login_url, login_data[0][1])
# 解密
decode_data = Utility.read_json(decode_path)
decode_url = base_url + decode_data[0][0]["decode_url"]
Service.decode(session, decode_url, decode_data[0][1])
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_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 training_resource_query_sql(cls, query_info, path):
base_sql = "select count(customer_id) from customer where pool_type!='public'"
if query_info["poolType"] != "全部" and query_info["poolType"] != "":
base_sql = "select count(customer_id) from customer where pool_type='%s'" % (
query_info["poolType"])
if query_info["lastStatus"] != "全部" and query_info["lastStatus"] != "":
status_sql = "select dict_key from dictionary_data where dict_type_id=1 and dict_value='%s'" % (
query_info["lastStatus"])
last_status = Utility.get_connect_one(status_sql, path)[0]
base_sql = base_sql + " and last_status='%s'" % (last_status)
if query_info["source"] != "全部" and query_info["source"] != "":
source_sql = "select dict_key from dictionary_data where dict_type_id=4 and dict_value='%s'" % (
query_info["source"])
source = Utility.get_connect_one(source_sql, path)[0]
base_sql = base_sql + " and source='%s'" % (source)
if query_info["s_time"] != "" and query_info["e_time"] != "":
base_sql = base_sql + \
" and create_time between '%s' and '%s'" % (
query_info["s_time"], query_info["e_time"])
elif query_info["s_time"] == "" and query_info["e_time"] != "":
base_sql = base_sql + \
" and create_time before '%s'" % (query_info["e_time"])
elif query_info["s_time"] != "" and query_info["e_time"] == "":
base_sql = base_sql + \
" and create_time after '%s'" % (query_info["s_time"])
# 咨询师
if query_info["workId"] != "全部" and query_info["workId"] != "":
consult_sql = "select work_id from employee where employee_name='%s';" % (
query_info["workId"])
consult = Utility.get_connect_one(consult_sql, path)[0]
base_sql = base_sql + " and work_id='%s'" % (consult)
if query_info["cusInfo"] != "" and query_info["cusInfo"] == "一瓢":
info = "1A5EF59031E0FDEB"
base_sql = base_sql + " and name='%s'" % (info)
return Utility.get_connect_one(base_sql + ";", path)[0]
def allot_resource_query_sql(cls, query_info, path):
base_sql = "select count(customer_id) from customer where work_id='0' and allot_time =''"
if query_info["source"] != "全部" and query_info["source"] != "":
source_sql = "select dict_key from dictionary_data where dict_type_id=4 and dict_value='%s'" % (
query_info["source"])
source = Utility.get_connect_one(source_sql, path)[0]
base_sql = base_sql + " and source='%s'" % (source)
if query_info["info"] != "" and query_info["info"] == "软件小达人":
info = "BF4051071EFC93BE29B8A46D5F3C97CD"
base_sql = base_sql + " and name='%s'" % (info)
return Utility.get_connect_one(base_sql + ";", path)[0]
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 get_role_info(cls, path, role_data):
# 读表格
book = Utility.read_excell(path)
role_sheet = book.sheet_by_name("roles")
user_info = {}
user_list = []
# 遍历每一行
for i in range(1, role_sheet.nrows):
# 读取 角色 判断账号
role_info = role_sheet.cell(i, 1).value.strip()
# 找到要找的角色
if role_data in role_info:
# 读取账号、密码
url = role_sheet.cell(i, 3).value
user_datas = role_sheet.cell(i, 4).value.splitlines()
for data in user_datas:
# “=”切割
param = data.split("=")
user_info[param[0].strip()] = param[1].strip()
user_list.append(url)
user_list.append(user_info)
return user_list
else:
return None
def sql_query_allocating_resource(cls, query_info, path):
base_sql = Utility.read_json(path)
# "source": "专属", "info": ""
# 00
if query_info["source"] == "" and query_info["region"] == "":
return base_sql["1"]
# 01
elif query_info["source"] == "" and query_info["region"] != "":
condition = Service.judge_cusInfo(query_info["info"])
if condition == 1:
return base_sql["201"][0] % (query_info["info"])
elif condition == 2:
return base_sql["202"][0] % (query_info["info"])
elif condition == 3:
return base_sql["203"][0] % (query_info["info"])
# 10
elif query_info["source"] != "" and query_info["region"] == "":
return base_sql["3"]
# 11
elif query_info["source"] != "" and query_info["region"] != "":
condition = Service.judge_cusInfo(query_info["info"])
if condition == 1:
return base_sql["401"][0] % (query_info["source"],
query_info["info"])
elif condition == 2:
return base_sql["402"][0] % (query_info["source"],
query_info["info"])
elif condition == 3:
return base_sql["403"][0] % (query_info["source"],
query_info["info"])
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 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_tracking_resource(self, url, tracking_resource_info, tracking_resource_sql, expect):
# 调用之前，先查看数据库的记录数
recode_count = Utility.get_connect_one(tracking_resource_sql["sql"], "../../config/data_base")
# 数据准备
tracking_resource_url = self.base_url + url["tracking_resource_url"]
tracking_resource_url_resp = TrainingResource.tracking_resource(
self.session, tracking_resource_url, tracking_resource_info
)
print(tracking_resource_url_resp.text)
# 响应无内容，在数据库添加记录判断
recode_count_again = Utility.get_connect_one(tracking_resource_sql["sql"], "../../config/data_base")
# 电话断言
if recode_count_again[0] > recode_count[0]:
actual = "tracking-resource-pass"
else:
actual = "tracking-resource-fail"
self.assertEqual(actual, 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_submit(self, url, submit_info, expect):
submit_url = self.base_url + url["submit_url"]
# 提交前，看数量
sql = "select count(work_id) from customer where work_id='%s'" % (
submit_info["workId"])
count_work_id = Utility.get_connect_one(sql, '../../config/data_base')
submit_resp = Transferee.submit_trans(self.session, submit_url,
submit_info)
# 提交后
count_work_id_submit = Utility.get_connect_one(
sql, '../../config/data_base')
# 无响应，数据库查询
if count_work_id_submit[0] >= count_work_id[0]:
actual = "submit-pass"
else:
actual = "submit-fail"
self.assertEqual(actual, 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_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 sql_query_trans_feree(cls, query_info, path):
base_sql = Utility.read_json(path)
# 0000
if query_info["workId"] == "" and query_info["region"] == "" and query_info["source"] == "" and \
query_info["status"] == "" :
return base_sql["1"]
# "select count(customer_id) from customer;"
# 0011
elif query_info["workId"] == "" and query_info["region"] == "" and query_info["source"] != "" and \
query_info["status"] != "" :
return base_sql["2"] % (query_info["source"], query_info["status"])
# "select count(customer_id) from customer where source='%s' and last_status='%s';"%(query_info["source"], query_info["status"])
# 0101
elif query_info["workId"] == "" and query_info["region"] != "" and query_info["source"] == "" and \
query_info["status"] != "" :
return base_sql["3"] % (query_info["region"], query_info["status"])
# "select count(customer_id) from customer where region='%s' and last_status='%s';"%(query_info["region"], query_info["status"])
# 0110
elif query_info["workId"] == "" and query_info["region"] != "" and query_info["source"] != "" and \
query_info["status"] == "":
return base_sql["4"] % (query_info["region"], query_info["source"])
# "select count(customer_id) from customer where region='%s' and source='%s';"%(query_info["region"], query_info["source"])
# 1001
elif query_info["workId"] != "" and query_info["region"] == "" and query_info["source"] == "" and \
query_info["status"] != "":
return base_sql["5"] % (query_info["workId"], query_info["status"])
# "select count(customer_id) from customer where work_id='%s' and status='%s';"%(empName_work_id, query_info["status"])
# 1010
elif query_info["workId"] != "" and query_info["region"] == "" and query_info["source"] != "" and \
query_info["status"] == "":
return base_sql["6"] % (query_info["workId"], query_info["source"])
# "select count(customer_id) from customer where work_id='%s' and source='%s';"%(empName_work_id, query_info["source"])
# 1100
elif query_info["workId"] != "" and query_info["region"] != "" and query_info["source"] == "" and \
query_info["status"] == "":
return base_sql["7"] % (query_info["workId"], query_info["region"])
# "select count(customer_id) from customer where work_id='%s' and region='%s';"%(empName_work_id, query_info["region"])
# 1111
elif query_info["workId"] != "" and query_info["region"] != "" and query_info["source"] != "" and \
query_info["status"] != "":
return base_sql["8"] % (query_info["workId"], query_info["region"],
query_info["source"], query_info["status"])
def get_excell_data(cls, path, sheet_name, type_name, *clos):
# 读取表格
book = Utility.read_excell(path)
# 得到具体工作表
sheet_target_name = book.sheet_by_name(sheet_name)
# 定义 返回的列表
test_case_list_directory = []
# 遍历读取
for i in range(1, sheet_target_name.nrows):
type_clos = sheet_target_name.cell(i, 0).value
if type_name in type_clos:
# 空字典
test_case_list = []
clos_dict = {}
# 具体列
url_clos = sheet_target_name.cell(i, clos[0]).value
param_clos = sheet_target_name.cell(i, clos[1]).value
value_clos_expect = sheet_target_name.cell(
i, clos[2]).value.strip()
# 添加网址
clos_dict["url"] = url_clos
if param_clos != "无参数":
value_clos_datas = param_clos.splitlines()
step_dict = {}
for clos_data in value_clos_datas:
# 排除空行
if clos_data:
# 切割，用"="
data_split = clos_data.split("=")
# = 左边为键，右边为值
step_dict[
data_split[0].strip()] = data_split[1].strip()
# 添加参数
clos_dict["step"] = step_dict
# 添加预期
clos_dict["expect"] = value_clos_expect
# 添加列表
test_case_list.append(clos_dict)
test_case_list_directory.append(test_case_list)
return test_case_list_directory
def update_deliver_resource_query_sql(cls, query_info, path):
base_sql = "select count(customer_id) from customer where true"
# 地区
if query_info["regionId"] != "全部" and query_info["regionId"] != "":
base_sql = base_sql + " and region_id='%s'" % (
query_info["regionId"])
# 部门
if query_info["deptId"] != "全部" and query_info["deptId"] != "":
base_sql = base_sql + " and department_id='%s'" % (
query_info["deptId"])
# 咨询师
if query_info["workId"] != "全部" and query_info["workId"] != "":
base_sql = base_sql + " and work_id='%s'" % (query_info["workId"])
return Utility.get_connect_one(base_sql + ";", path)[0]
def sql_query_common_resource_pool(cls, query_info, path):
base_sql = Utility.read_json(path)
# 000
if query_info["workId"] == "全部" and query_info[
"lastStatus"] == "全部" and query_info["source"] == "全部":
return base_sql["1"]
# 011
elif query_info["workId"] == "全部" and query_info[
"lastStatus"] != "" and query_info["source"] != "":
return base_sql["2"] % (query_info["lastStatus"],
query_info["source"])
# 101
elif query_info["workId"] != "全部" and query_info[
"lastStatus"] == "" and query_info["source"] != "全部":
return base_sql["3"] % (query_info["workId"], query_info["source"])
# 110
elif query_info["workId"] != "全部" and query_info[
"lastStatus"] != "全部" and query_info["source"] == "":
return base_sql["4"] % (query_info["workId"],
query_info["lastStatus"])
def test_query_trans_feree(self, url, query_trans_feree_info, expect):
# 数据准备
query_trans_feree_url = self.base_url + url["query_trans_feree_url"]
query_trans_feree_resp = Transferee.query_trans_feree(
self.session, query_trans_feree_url, query_trans_feree_info)
query_result = query_trans_feree_resp.json()
# 拼接sql
sql = Service.sql_query_trans_feree(
query_trans_feree_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_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)
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)
import re
import unittest
import requests
from parameterized import parameterized
from interface.common.training_resource.TrainingResource import TrainingResource
from interface.config.try_to_encode_and_decode_woniu import WoniuBoss
from interface.util.Service import Service
from interface.util.Utility import Utility
open_training_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/open_transferee_data")
training_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/training_resource_data")
add_training_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/add_training_resource_data")
abandon_training_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/abandon_training_resource_data")
show_resume_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/show_resume_training_resource_data")
tracking_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/tracking_resource_data")
Modify_resource_data = Utility.read_json(
"../../test_data/training_resource/training_resource_module/Modify_resource_data")
import unittest
from parameterized import parameterized
from interface.common.training_resource.Transferee import Transferee
from interface.util.Service import Service
from interface.util.Utility import Utility
import re
import requests
# 数据
open_transferee_data = Utility.read_json(
"../../test_data/training_resource/transferee_module/open_transferee_data")
trans_feree_data = Utility.read_json(
"../../test_data/training_resource/transferee_module/trans_feree_data")
show_resume_data = Utility.read_json(
"../../test_data/training_resource/transferee_module/show_resume_data")
switch_page_data = Utility.read_json(
"../../test_data/training_resource/transferee_module/switch_page_data")
submit_data = Utility.read_json(
"../../test_data/training_resource/transferee_module/submit_data")
'''培训资源模块 子模块 转让责任人'''
class TransfereeTest(unittest.TestCase):
# 自定义，登录、解密
def setUp(self):
self.session = requests.session()
import re
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
from interface.util.Utility import Utility
open_common_resource_pool_data = Utility.read_json(
"../../test_data/training_resource/common_resource_pool_module/open_common_resource_pool_data"
)
query_common_resource_pool_data = Utility.read_json(
"../../test_data/training_resource/common_resource_pool_module/query_common_resource_pool_data"
)
claim_data = Utility.read_json(
"../../test_data/training_resource/common_resource_pool_module/claim_data")
class CommonResourcePoolTest(unittest.TestCase):
# 开始
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)
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
from interface.util.Utility import Utility
open_advisory_department = Utility.read_json(
"../../test_data/training_resource/report_center_data/open_advisory_department_data"
)
'''报表中心子模块，咨询部'''
class AdvisoryDepartmentTest(unittest.TestCase):
# 自定义，初始化driver，窗口最大化，隐式等待
def setUp(self):
self.session = requests.session()
self.base_url = Utility.read_json("../../config/data_base")["BASEURL"]
# 登陆（admin）、解密
login_path = "../../test_data/login_data/login_data"
decode_path = "../../test_data/login_data/decode_data"
Service.get_login_decode(self.base_url, self.session, login_path,
decode_path)
# 用例，打开分配资源页面
@parameterized.expand(open_advisory_department)
def test_open_advisory_department(self, url, expect):
open_advisory_department_url = self.base_url + url[
"open_allocating_resource_url"]
open_advisory_department_resp = Service.get_no_arguments(
self.session, open_advisory_department_url)
if "分配资源" in open_allocating_resource_resp.text:
def sql_query_training_resource(cls, query_info, path):
base_sql = Utility.read_json(path)
# 1111111
if query_info["poolType"] == "" and query_info["empName"] == "" and query_info["lastStatus"] == "" and \
query_info["source"] == "" and query_info["s_time"] == "" and query_info["e_time"] == "" and \
query_info["cusInfo"] == "" :
return base_sql["1"]
# 1112222
elif query_info["poolType"] == "" and query_info["empName"] == "" and query_info["lastStatus"] == "" and \
query_info["source"] != "" and query_info["s_time"] != "" and query_info["e_time"] != "" and \
query_info["cusInfo"] != "" :
return base_sql["2"] % (query_info["source"],
query_info["cusInfo"],
query_info["s_time"], query_info["e_time"])
# 1221122
elif query_info["poolType"] == "" and query_info["empName"] != "" and query_info["lastStatus"] != "" and \
query_info["source"] == "" and query_info["s_time"] == "" and query_info["e_time"] != "" and \
query_info["cusInfo"] != "" :
# 判断用户信息 类别
condition = Service.judge_cusInfo(query_info["cusInfo"])
empName_work_id = Utility.get_connect_one(
"select work_id from employee where employee_name='%s'" %
(query_info["empName"]), '../../config/data_base')
if condition == 1:
return base_sql["3"][0] % (
empName_work_id, query_info["lastStatus"], empName_work_id,
query_info["e_time"])
elif condition == 2:
return base_sql["3"][1] % (
empName_work_id, query_info["lastStatus"], empName_work_id,
query_info["e_time"])
elif condition == 3:
return base_sql["3"][2] % (
empName_work_id, query_info["lastStatus"], empName_work_id,
query_info["e_time"])
# 1222211
elif query_info["poolType"] == "" and query_info["empName"] != "" and query_info["lastStatus"] != "" and \
query_info["source"] != "" and query_info["s_time"] != "" and query_info["e_time"] == "" and \
query_info["cusInfo"] == "" :
empName_work_id = Utility.get_connect_one(
"select work_id from employee where employee_name='%s'" %
(query_info["empName"]), '../../config/data_base')
return base_sql["4"] % (empName_work_id, query_info["lastStatus"],
query_info["source"], query_info["s_time"])
# 2121212
elif query_info["poolType"] != "" and query_info["empName"] == "" and query_info["lastStatus"] != "" and \
query_info["source"] == "" and query_info["s_time"] != "" and query_info["e_time"] == "" and \
query_info["cusInfo"] != "":
condition = Service.judge_cusInfo(query_info["cusInfo"])
if condition == 1:
return base_sql["5"][0] % (
query_info["poolType"], query_info["lastStatus"],
query_info["cusInfo"], query_info["s_time"])
elif condition == 2:
return base_sql["5"][1] % (
query_info["poolType"], query_info["lastStatus"],
query_info["cusInfo"], query_info["s_time"])
elif condition == 3:
return base_sql["5"][2] % (
query_info["poolType"], query_info["lastStatus"],
query_info["cusInfo"], query_info["s_time"])
# 2122121
elif query_info["poolType"] != "" and query_info["empName"] == "" and query_info["lastStatus"] != "" and \
query_info["source"] != "" and query_info["s_time"] == "" and query_info["e_time"] != "" and \
query_info["cusInfo"] == "":
return base_sql["6"] % (query_info["poolType"],
query_info["lastStatus"],
query_info["source"], query_info["e_time"])
# 2211221
elif query_info["poolType"] != "" and query_info["empName"] != "" and query_info["lastStatus"] == "" and \
query_info["source"] == "" and query_info["s_time"] != "" and query_info["e_time"] != "" and \
query_info["cusInfo"] == "":
empName_work_id = Utility.get_connect_one(
"select work_id from employee where employee_name='%s'" %
(query_info["empName"]), '../../config/data_base')
return base_sql["7"] % (query_info["poolType"], empName_work_id,
query_info["s_time"], query_info["e_time"])
# 2212112
elif query_info["poolType"] != "" and query_info["empName"] != "" and query_info["lastStatus"] == "" and \
query_info["source"] != "" and query_info["s_time"] == "" and query_info["e_time"] == "" and \
query_info["cusInfo"] != "":
condition = Service.judge_cusInfo(query_info["cusInfo"])
empName_work_id = Utility.get_connect_one(
"select work_id from employee where employee_name='%s'" %
(query_info["empName"]), '../../config/data_base')
if condition == 1:
return base_sql["8"][0] % (
query_info["poolType"], empName_work_id,
query_info["source"], query_info["cusInfo"])
elif condition == 2:
return base_sql["8"][1] % (
query_info["poolType"], empName_work_id,
query_info["source"], query_info["cusInfo"])
elif condition == 3:
return base_sql["8"][2] % (
query_info["poolType"], empName_work_id,
query_info["source"], query_info["cusInfo"])
import requests
import unittest
from parameterized import parameterized
from interface.util.Service import Service
from interface.util.Utility import Utility
open_allocating_resource_data = Utility.read_json(
"../../test_data/training_resource/allocating_resource_module/open_allocating_resource_data")
allocating_resource_data = Utility.read_json(
"../../test_data/training_resource/allocating_resource_module/query_allocating_resource_data")
commit_allocating_resource_data = Utility.read_json(
"../../test_data/training_resource/allocating_resource_module/commit_allocating_resource_data")
'''培训资源子模块，分配资源'''
class AllocatingResourceTest(unittest.TestCase):
# 自定义，初始化driver，窗口最大化，隐式等待
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)
# 用例，打开分配资源页面
@parameterized.expand(open_allocating_resource_data)
def test_open_allocating_resource(self, url, expect):
def setUp(self):
self.session = requests.session()
self.base_url = Utility.read_json("../../config/data_base")["BASEURL"]