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 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_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_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_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_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_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_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(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_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_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_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_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)
