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"]