def test_c004_shareParamUrl(self):
taskid = task_create.test_c002_create_task(self)
sql = 'select sub_task_id,read_count from share_sub_task_info where task_id=' + str(taskid) + ' and create_user_id=' + str(userId)
# 查询用户分享任务的子id
conn = MySQL().connect_content_fair()
cur1 = conn.cursor()
cur1.execute(sql)
result_sql = cur1.fetchall()
subTaskId = result_sql[0][0]
start_read = result_sql[0][1]
url01 = 'http://user.ejw.cn/saas_contentfair/v1/sub-task/'
url = url01 + str(subTaskId)
shareParamUrl = requests.put(url, headers=header)
result_code = shareParamUrl.status_code
if response_code == result_code:
#print("用户中心_获取分享链接成功")
jsonData = {}
jsonData = shareParamUrl.json()
shareParamUrl = jsonData['shareParamUrl']
# 复制链接，进行分享任务操作
share_task = requests.get(shareParamUrl, headers=header)
result_code2 = share_task.status_code
if response_code == result_code2:
# 查询子任务的阅读数
conn = MySQL().connect_content_fair()
cur1 = conn.cursor()
cur1.execute(sql)
result_sql = cur1.fetchall()
end_read = result_sql[0][1]
if end_read - start_read == 1:
print("任务分享成功，用户任务阅览数+1")
else:
print("任务分享失败，用户任务阅览数", end_read)
else:
print("用户中心_获取分享链接失败")
def test_d003_pay(self):
try:
conn = MySQL().connect_order()
cur = conn.cursor()
sql = "select b.pay_id,a.sp_order_id,a.amount_Price, b.sp_order_stage_no, a.sp_product_code, a.sp_product_name, a.sp_product_spec_name from sp_order_info a, pay_stage_info b where a.order_state=1 and a.sp_partner_id=" + spId + " and b.pay_state=5 and a.sp_order_id=b.sp_order_id;"
cur.execute(sql)
ordering = cur.fetchone()[0:7]
pay_id = str(ordering[0])
sp_order_id = str(ordering[1])
amountPrice = ordering[2]
spOrderStageNo = ordering[3]
productCode = ordering[4]
productName = str(ordering[5])
productSpecName = ordering[6]
url = "http://cu.ejw.cn/platform/v1/order/" + sp_order_id + "/arbitrate/" + pay_id
print(url)
params = {"amountPrice": int(amountPrice), "spOrderStageNo": spOrderStageNo, "orderType": "1",
"productCode": productCode,
"productName": productName, "productSpecName": productSpecName, "spName": spName,
"spId": int(spId),
"cuName": cuComName, "orderCompId": int(cuComId), "orderEmpId": int(cuEmpId),
"cuEmpName": cuEmpName,
"applyDesc": "自动化-服务商不同意退款，已购产品货物没有送达"}
result_act = requests.post(url, data=json.dumps(params), headers=headers)
# print(result_act.text)
result_exp = 200
self.assertEqual(result_exp, result_act.status_code, msg='发送仲裁失败')
log.info("企业后台-订单管理-标准订单管理-申请仲裁: " + sp_order_id + "申请仲裁成功")
log_exp.info(result_exp)
log_act.info(result_act)
except TypeError:
log.info("没有找到需要仲裁的订单")
def test_c011_order_pay(self):
global log, log_exp, log_act
log_exp = Logger(logger="服务商平台_预期结果").getlog()
log_act = Logger(logger="服务商平台_实际结果").getlog()
log = Logger(logger="服务商平台").getlog()
try:
conn = MySQL().connect_order()
cur = conn.cursor()
sql = "select sp_order_id,order_id,pay_price from sp_order_info where sp_partner_id=" + spId + " and order_state=0"
print(sql)
cur.execute(sql)
ordering = cur.fetchone()[0:3]
sp_order_id = ordering[0]
order_id = ordering[1]
pay_price = ordering[2]
url = "http://sp.ejw.cn/order/v1/sp/" + spId + "/order/" + sp_order_id + "/paystageinfo"
print(url)
params = {"spEmpId": int(spEmpId), "spEmpName": "蒋涛", "orderId": order_id,
"spCusContractUrl": "https://bj.bcebos.com/v1/hnjing-test/d45fdb0150674e5baa969192921ad626.rar",
"stages": [{"spOrderStageNo": 1, "payDesc": "aaaa", "payAmount": int(pay_price)}]}
result_act = requests.post(url, data=json.dumps(params), headers=headers).status_code
result_exp = 200
self.assertEqual(result_exp, result_act, msg='接单失败')
log.info("接单成功")
except TypeError:
log.info("没有找到需要接单的订单")
def test_h001_search(self):
try:
conn = MySQL().connect_platform()
cur = conn.cursor()
sql = "select examine_auth_id from refund_examine where examine_state=0 and order_comp_id=" + cuComId
cur.execute(sql)
ordering = cur.fetchone()[0:1]
examine_auth_id = str(ordering[0])
print(examine_auth_id)
url = "http://admin.ejw.cn/platform/v1/arbitrate/" + examine_auth_id + "?curEmpId=" + adminEmpId
params = {
"examineState": 1,
"examineSuggest": "",
"refundAmount": 1,
"examineEmpId": int(adminEmpId),
"examineEmpName": cuEmpName,
"spOrderStageNo": 1,
"orderEmpId": int(cuEmpId),
"orderCompId": int(cuComId),
"useCost": 0,
"refundFee": 0
}
print(params)
result_act = requests.put(url,
data=json.dumps(params),
headers=headers)
# print(result_act.text)
result_exp = 200
self.assertEqual(result_exp, result_act.status_code, msg='发送仲裁失败')
log.info("申请仲裁成功")
except TypeError:
log.info("没有找到需要仲裁的订单")
def test_c003station(self):
# 连接数据库
conn = MySQL().connect_emp_os()
cur = conn.cursor()
cur.execute('select station_id,station_name from station ')
station = cur.fetchone()[0:2]
station_id = str(station[0])
station_name = station[1]
url_bj = "http://emp.hnjing.com/emp_os/v1/station/"
url = url_bj + station_id
# 编辑后名称
stationName01 = ''.join(
random.sample(['1', '4', '3', '2', '5', '6'], 3))
stationName02 = '测试岗位林'
stationName = stationName02 + stationName01
params = {
"stationName": stationName,
"stationType": "0",
"departmentId": 95,
"modifier": oper_id
}
station_bj = requests.put(url,
data=json.dumps(params),
headers=headers)
result_bj = json.loads(station_bj.text)
values = result_bj["rowNum"]
result_exp = 1
self.assertEqual(result_exp, values)
log.info(stationName + "编辑岗位成功")
def test_c013_order_pay(self):
try:
conn = MySQL().connect_order()
cur = conn.cursor()
sql = "select b.pay_id,b.refund_Amount, b.sp_order_id from sp_order_info a, pay_stage_info b where a.order_state=1 and a.sp_partner_id=" + spId + " and b.pay_state=4 and a.sp_order_id=b.sp_order_id;"
cur.execute(sql)
ordering = cur.fetchone()[0:3]
sp_order_id = str(ordering[2])
refund_Amount = str(ordering[1])
pay_id = str(ordering[0])
url = "http://sp.ejw.cn/order/v1/partner/" + spId + "/order/" + sp_order_id + "/paystageinfo/" + pay_id
params = {
"nodeSuggest": "服务商不同意退款",
"payState": "5",
"spEmpId": spEmpId,
"spEmpName": "蒋涛",
"spPartnerName": "竞网自动化勿删",
"refundAmount": refund_Amount,
"useCost": "0.00",
"refundFee": "0.00"
}
result_act = requests.put(url,
data=json.dumps(params),
headers=headers).status_code
result_exp = 200
self.assertEqual(result_exp, result_act, msg='商家不退款失败')
log.info("工单管理-退款审核-商家不同意退款")
except TypeError:
log.info("没有找到不退款的订单")
def test_c003_order(self):
try:
conn = MySQL().connect_mall()
cur = conn.cursor()
sql = "select product_spec_uuid from shoping_info where sp_id=" + spId + " and emp_id=" + cuEmpId + " and comp_id=" + cuComId
cur.execute(sql)
uuid = cur.fetchone()[0]
url = "http://cu.ejw.cn/order/v1/cu/" + cuComId + "/order"
params = {
"order": {"cuPartnerName": cuComName, "cuEmpId": int(cuEmpId), "cuEmpName": cuEmpName,
"systemType": "0",
"resSystem": "1", "orderDesc": "自动化测试订单功能"},
"deliveryAddr": {"recName": "2222222000", "recPhone": "15000000000", "recPost": "333333",
"recAddr": "山东 济南 槐荫区 33333333333333333333333333333333", "deliveryDesc": ""},
"usePlatCouponInfo": [], "spOrderInfos": [
{"spSpecUuid": uuid, "amount": 1, "payType": "0", "invoiceType": "1",
"cusContractUrl": "https://bj.bcebos.com/v1/hnjing-test/c25ab9a8aadb41e7881ebcb9dceb2814.rar",
"otherContractUrl": "", "compQualifyInfos": [{"quaName": "成年人专用",
"quaImages": "https://bj.bcebos.com/v1/hnjing-test/d26a9fa28b6146b3ad27c1a228a5f885.jpg"}],
"useSkuCouponInfo": []}]}
result = requests.post(url, data=json.dumps(params), headers=headers)
result_exp_pro = 200
self.assertEqual(result_exp_pro, result.status_code, msg="请求参数异常或加入购物车失败")
log_exp.info(result_exp_pro)
log_act.info(result.text)
except TypeError:
log.info("数据库中没有需要下订单的数据")
def test_d001_spsq_dsh(self):
conn = MySQL().connect_platform()
cur = conn.cursor()
cur.execute(
'select record_id,auth_id from product_auth where `status`= 3')
cur_data = cur.fetchone()
# print(type(cur_data))
result_exp = 200
if cur_data is None:
# print("执行A部分")
self.assertNotEqual(result_exp, cur_data, msg="没有需要授权的产品")
log.info("没有需要授权的产品")
else:
# print("执行B部分")
record_id = cur_data[0]
auth_id = cur_data[1]
print(record_id, auth_id)
url_01 = 'http://admin.ejw.cn/platform/v1/productauth/'
url = url_01 + str(record_id) + '/platformverify'
paramas = {"status": 5}
result = requests.put(url,
data=json.dumps(paramas),
headers=headers)
result_act = result.status_code
self.assertEqual(result_exp, result_act, msg="产品授权-审核不通过")
log.info("产品授权-审核通过")
def test_c001_search(self):
conn = MySQL().connect_platform()
cur = conn.cursor()
cur.execute('select type_id from qualify_type ORDER BY type_id DESC;')
sql_result = cur.fetchone()[0:1]
typeId = sql_result[0]
# 随机生成社会信用代码
tempName_01 = ''.join(
random.sample(['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'],
4))
tempName_02 = '自资名称'
tempName = tempName_01 + tempName_02
url = 'http://admin.ejw.cn/platform/v1/qualifytemplate'
paramas = {
"typeId":
typeId,
"tempName":
tempName,
"tempImage":
"http://hnjing-test.bj.bcebos.com/v1/hnjing-test/34b04a41698c4dc28627a19d44801011.jpg"
}
# 发送服务商接口请求
zzmb = requests.post(url, data=json.dumps(paramas), headers=headers)
result_exp = 200
result_act = zzmb.status_code
# 判断当前返回码及字段值
self.assertEqual(result_exp, result_act, msg="新增模板失败，请检查失败原因")
log.info("系统管理-平台配置-资质模块设置-新增资质模块成功")
def test_p003_search(self):
try:
# 连接到数据库ps1（分支产品库）
conn = MySQL().connect_ps()
# 定义一个游标赋值给变量cur，cur才有权限去执行数据库
cur = conn.cursor()
# 数据库中查询供应商id为502，产品状态为1（已上架）、审核状态为空或下架审核不通过
cur.execute(
'select cp_product_code,cp_product_name,cp_partner_id from cp_product where sale_flag = 1 and cp_partner_id = "' + cpComId + '" and examine_state=1')
# 定义查询数据库表中3个字段 cpProductCode，ProductName,partnerId
cur_data = cur.fetchone()[0:3]
print(cur_data, type(cur_data))
# 第一个字段赋给变量sp_product_code
cpProductCode = cur_data[0]
# 第二个字段赋给变量ProductName
ProductName = cur_data[1]
# 第三个字段赋给变量partnerId
partnerId = cur_data[2]
# 打印查询出来的cpProductCode，ProductName这2个字段内容
print(cpProductCode, ProductName)
# url地址
url_01 = 'http://cp.ejw.cn/cp/v1/partner/'
url_02 = url_01 + str(partnerId) + '/product/' + str(cpProductCode) + '/release?curEmpId='
url = url_01 + str(partnerId) + '/product/' + str(cpProductCode) + '/off?curEmpId=' + str(cpEmpId)
# 发送上架审核接口请求
result_act = requests.put(url, headers=headers).text
# 设置预期返回1
result_exp = 1
# 判断实际返回码是否与预期的一致
self.assertEqual(result_exp, int(result_act))
log_exp.info(result_exp)
log_act.info(result_act)
log.info(ProductName + "产品下架提交成功")
except TypeError:
log.info("没有需要下架的产品数据")
def test_c007_product_verify(self):
# 连接ps数据库
conn1 = MySQL().connect_platform()
cur1 = conn1.cursor()
sql = "select auth_id, record_id from product_auth t where t.sp_id=" + spId + " and t.`status`=0"
cur1.execute(sql)
try:
result_data = cur1.fetchone()[0:2]
auth_id = result_data[0]
record_id = result_data[1]
print(auth_id, record_id)
url_01 = "http://sp.ejw.cn/platform/v1/productauth/"
url = url_01 + str(record_id) + "?curEmpId=2121"
print(url)
params = {"contractId": auth_id, "contractName": "script.rar",
"contractBeginDate": "2018-07-13T00:00:00+08:00",
"contractValidDate": "2018-07-31T23:59:59+08:00",
"contractSpFile": "https://bj.bcebos.com/v1/hnjing-test/890d51e8ec26441da124f4f009cff36f.rar?authorization=bce-auth-v1%2Fed6cb82c3c054636aec25bdbc65d7c10%2F2018-07-13T01%3A51%3A01Z%2F-1%2F%2Ffcdc2fb8500561d8a195514e0d324075dd7c820a1fe7706defcd281460680773"}
result_act = requests.put(url, data=json.dumps(params), headers=headers)
log_act.info(result_act)
result_exp = 1
self.assertEqual(result_exp, int(result_act.text), msg="数据异常，产品授权不通过")
log.info("提交合同成功-待供应商审核")
except TypeError:
log.info("没有需要授权的产品信息")
def test_c004_search(self):
try:
# 连接到数据库ps1（分支产品库）
conn = MySQL().connect_ps()
# 定义一个游标赋值给变量cur，cur才有权限去执行数据库
cur = conn.cursor()
# 数据库中查询服务商id为502，审核状态为1的产品
cur.execute(
'select sp_product_code from sp_product where sale_flag = 1 and sp_partner_id = 502 and examine_state = 0')
spProductCode = str(cur.fetchall()[0][0])
url_01 = 'http://sp.ejw.cn/platform/v1/product/'
url = url_01 + spProductCode + '/canel-verify'
# 发送下架取消接口请求
result_act = requests.delete(url, headers=headers).text
# 设置预期设为1
result_exp = 1
# 判断实际返回码是否与预期的一致
self.assertEqual(result_exp, int(result_act))
print(result_act)
global log, log_exp, log_act
log_exp = Logger(logger="服务商平台_预期结果").getlog()
log_act = Logger(logger="服务商平台_实际结果").getlog()
log = Logger(logger="服务商平台").getlog()
log_exp.info(result_exp)
log_act.info(result_act)
log.info(spProductCode + "下架审核取消操作成功")
except LookupError:
print("没有需要下架的方案数据")
def test_p004_search(self):
try:
# 连接到数据库ps1（分支产品库）
conn = MySQL().connect_ps()
# 定义一个游标赋值给变量cur，cur才有权限去执行数据库
cur = conn.cursor()
# 数据库中查询供应商id为502，产品状态为1（已上架），审核状态为0（待下架审核）
cur.execute(
'select cp_product_code from cp_product where sale_flag = 1 and cp_partner_id = "' + cpComId + '" and examine_state = 0')
# 将查询出来的企业ID值赋值给变量cpProductCode
result_sql = cur.fetchone()[0:1]
cpProductCode = str(result_sql[0])
# 产品编号打印出来，以便于核对是否正确
log.info(cpProductCode)
# 拼接请求地址
url_01 = 'http://cp.ejw.cn/platform/v1/product/'
url = url_01 + str(cpProductCode) + '/canel-verify?curEmpId=' + str(cpEmpId)
# 打印请求地址，以便于核对请求地址是否拼接正确
log.info(url)
# 请求结果存入变量result_act
result_act = requests.delete(url, headers=headers).text
# 打印实际返回结果，以便于核对是否正确
log.info(result_act)
# 设置预期设为1
result_exp = 1
# 判断实际返回的内容是否与预期的一致
self.assertEqual(result_exp, int(result_act))
log_exp.info(result_exp)
log_act.info(result_act)
log.info(cpProductCode + "产品下架审核取消操作成功")
except TypeError:
log.info("没有需要取消产品下架审核的数据")
def test_b004_search(self):
conn = MySQL().connect_platform()
cur = conn.cursor()
cur.execute("select record_id from product_auth where `status`=3;")
cur_data = cur.fetchone()
# print(cur_data)
if cur_data == None:
result_exp = None
self.assertEqual(result_exp, cur_data)
log.info("产品运营-产品授权审核-待审核-没有需要审核的产品信息")
else:
record_id = str(cur_data[0])
paramas = {"status": 5}
url_01 = 'http://admin.ejw.cn/platform/v1/productauth/'
url = url_01 + record_id + '/platformverify?curEmpId=' + adminEmpId
# print(url)
# 发送服务商接口请求
qykh_test_01 = requests.put(url,
data=json.dumps(paramas),
headers=headers)
# print(qykh_test_01.text)
result_act = qykh_test_01.status_code
result_exp = 200
# 判断当前返回码及字段值
self.assertEqual(result_exp, result_act, msg='审核失败：没有存在的企业或其它参数错误')
log.info("产品运营-产品授权审核-待审核-产品授权审核成功")
def test_p002_search(self):
try:
# 连接到数据库ps1（分支产品库）
conn = MySQL().connect_ps()
# 定义一个游标赋值给变量cur，cur才有权限去执行数据库
cur = conn.cursor()
# 数据库中查询供应商id为502，产品状态为0（已下架），审核状态为0（待上架审核）
cur.execute(
'select cp_product_code,cp_product_name,cp_partner_id from cp_product where sale_flag = 0 and cp_partner_id = "' + cpComId + '" and examine_state = 0')
# url地址，将产品编号设置为变量，将数据库查询出来的产品编号赋值给变量spProductCode
# 将查询出来的企业ID值赋值给变量cpProductCode
cpProductCode = str(cur.fetchall()[0][0])
# 拼接请求地址
url_01 = 'http://cp.ejw.cn/platform/v1/product/'
url = url_01 + str(cpProductCode) + '/canel-verify?curEmpId=' + str(cpEmpId)
# 打印请求地址，以便于核对请求地址是否拼接正确
print(url)
# 请求结果存入变量result_act
result_act = requests.delete(url, headers=headers).text
# 打印实际返回结果，以便于核对是否正确
print(result_act)
# 设置预期设为1
result_exp = 1
# 判断实际返回的内容是否与预期的一致
self.assertEqual(result_exp, int(result_act))
log_exp.info(result_exp)
log_act.info(result_act)
log.info(cpProductCode + "产品上架审核取消操作成功")
except LookupError:
log.info("没有需要取消上架产品的数据")
def test_a001oragn(self):
# 连接openapi数据库获取已授权的企业
conn = MySQL().connect_open_api()
cur1 = conn.cursor()
cur1.execute('select partner_id from app_comp_auth where status = 1')
partner1 = cur1.fetchall()
# 连接empos数据库获取已关联机构企业
conn = MySQL().connect_emp_os()
cur2 = conn.cursor()
cur2.execute('select partner_id from organ where deleted = 1')
partner2 = cur2.fetchall()
# 获取已授权但未关联机构的企业
vaules = tuple(set(partner1) - set(partner2))
partner_id = str(vaules[0][0])
# 连接openapi库获取企业名称
conn = MySQL().connect_open_api()
cur3 = conn.cursor()
cur3.execute(
'select partner_name from os_partner where partner_id = "' +
partner_id + '" ')
partnername = cur3.fetchone()[0]
shortEname01 = "zidong"
shortEname02 = ''.join(
random.sample(['a', 'b', 'c', 'd', 'e', 'f', 'p', 'u'], 3))
shortEname = shortEname01 + shortEname02
shortname = partnername[0:5]
url = "http://emp.hnjing.com/emp_os/v1/organ"
params = {
"organName": partnername,
"sharesType": 0,
"oragnShortName": shortname,
"oragnShortEname": shortEname,
"partnerId": partner_id,
"creator": oper_id
}
organ_add = requests.post(url,
data=json.dumps(params),
headers=headers)
result_add = json.loads(organ_add.text)
result = result_add["rowNum"]
result_exp = 1
self.assertEqual(result_exp, result)
log.info(partnername + "新增机构成功")
def test_a002_role_del(self):
# 设置案例名称
conn = MySQL().connect_mall()
cur = conn.cursor()
# 查询出当前要删除案例的id信息
cur.execute('select case_id from class_case_info t where t.sp_id = "' + spId + '"')
case_id = str(cur.fetchall()[0][0])
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfo/'
url = url_01 + case_id
result_act = requests.delete(url, headers=headers).text
result_exp = 1
self.assertEqual(result_exp, int(result_act), msg="删除失败")
log.info("案例删除成功")
def test_a003_case_search(self):
conn = MySQL().connect_mall()
cur = conn.cursor()
# 查询出当前要删除案例的id信息
sql = "select case_name from class_case_info t where t.sp_id =" + spId
cur.execute(sql)
case_name = str(cur.fetchall()[0][0])
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfos?spId=' + spId + '&caseState=&pageSize=10&pageNo=1&caseName='
url = url_01 + case_name
result_act = requests.get(url, headers=headers).text
# print(case_name, result_act)
self.assertIn(case_name, result_act, msg="案例查询失败")
log.info(case_name + "查询成功")
def test_b002_cpmc_search(self):
# 连接数据库创建一个游标对象
conn = MySQL().connect_ps()
cur = conn.cursor()
sql = "select cp_product_name from cp_product t where t.cp_partner_id = " + cpComId
cur.execute(sql)
sql_result = cur.fetchone()[0:1]
cp_product_name = sql_result[0]
# 请求查询参数
url = "http://cp.ejw.cn/ps/v1/cpproducts?pageNum=1&pageSize=20&_sort=modifyDate%2Cdesc&cpPartnerId="+cpComId+"&cpProductName="+cp_product_name
# url = 'http://cp.ejw.cn/ps/v1/cpproducts?pageNum=1&pageSize=20&_sort=modifyDate%2Cdesc&cpPartnerId=502&cpProductName=%E8%87%AA%E5%8A%A8%E5%8C%96'
result_all = requests.get(url, headers=headers).text
self.assertIn(cp_product_name, result_all, "预期结果与实际结果不一致")
log.info("已存在的产品名称验证成功")
def test_d001_pay(self):
global log, log_exp, log_act
log_exp = Logger(logger="企业平台_预期结果").getlog()
log_act = Logger(logger="企业平台_实际结果").getlog()
log = Logger(logger="企业平台").getlog()
try:
# 获取当前已加入购物车的spid
conn_mail = MySQL().connect_mall()
cur_mail = conn_mail.cursor()
sql = "select sp_id from shoping_info where comp_id =" + cuComId + " and emp_id= " + cuEmpId + " and sp_id=" + spId
cur_mail.execute(sql)
result_sql = cur_mail.fetchone()[0:1]
sp_id = result_sql[0]
print(sp_id)
# 查询需要付款的订单
conn = MySQL().connect_order()
cur = conn.cursor()
sql = "select b.sp_order_id,b.sp_order_stage_no from sp_order_info a, pay_stage_info b where a.sp_partner_id=" + sp_id + " and a.sp_order_id=b.sp_order_id and b.pay_state=0;"
print(sql)
cur.execute(sql)
ordering = cur.fetchone()[0:2]
sp_order_id = str(ordering[0])
sp_order_stage_no = str(ordering[1])
url = "http://cu.ejw.cn/order/v1/cu/" + cuComId + "/pay/" + sp_order_id + "/stage/" + sp_order_stage_no
# print(url)
params = {"cuPartnerName": "湖南竞网智赢网络技术有限公司", "cuEmpId": int(cuEmpId), "cuEmpName": "竞网企业", "cuAccountPwd": "a123456",
"cuEntrustUrl": "", "cuAccountId": "1829615000103289", "cuAccountName": "湖南竞网智赢网络技术有限公司"}
result_act = requests.post(url, data=json.dumps(params), headers=headers)
print(result_act.text)
result_exp = 200
self.assertEqual(result_exp, result_act.status_code, msg='接单失败')
log.info("企业后台-订单管理-标准订单管理-付款")
log_exp.info(result_exp)
log_act.info(result_act.text)
except TypeError:
log.info("没有找到需要付款的订单")
def test_c003_search(self):
try:
# 连接到数据库ps1（分支产品库）
conn = MySQL().connect_ps()
# 定义一个游标赋值给变量cur，cur才有权限去执行数据库
cur = conn.cursor()
# 数据库中查询服务商id为502，审核状态为-1的产品
cur.execute(
'select sp_product_code,sp_product_name from sp_product where sale_flag = 1 and sp_partner_id = 502 and examine_state = -1'
)
# 定义查询数据库表中2个字段sp_product_code，sp_product_name
cur_data = cur.fetchone()[0:2]
# 第一个字段赋给变量sp_product_code
spProductCode = str(cur_data[0])
# 第二个字段赋给变量sp_product_name
productName = cur_data[1]
# 打印查询出来的sp_product_code，sp_product_name这2个字段内容
print(spProductCode, productName)
# url地址
url = 'http://sp.ejw.cn/sp/v1/verify-saleflag'
# 参数信息
params = {
"spPartnerId": 502,
"spProductCode": spProductCode,
"productType": "group",
"verifyType": 2,
"createUser": 164,
"productName": productName,
"partnerName": "竞网自动化勿删"
}
# 发送上架审核接口请求
result_act = requests.post(url,
data=json.dumps(params),
headers=headers)
# 设置预期返回码200
result_exp = 200
# 实际返回码
result_act_act = result_act.status_code
# 判断实际返回码是否与预期的一致
self.assertEqual(result_exp, result_act_act)
global log, log_exp, log_act
log_exp = Logger(logger="服务商平台_预期结果").getlog()
log_act = Logger(logger="服务商平台_实际结果").getlog()
log = Logger(logger="服务商平台").getlog()
log_exp.info(result_exp)
log_act.info(result_act_act)
log.info(productName + "下架提交成功")
except LookupError:
print("没有需要下架的方案数据")
def test_b002_jn_del(self):
try:
conn = MySQL().connect_mall()
cur = conn.cursor()
# 查询出当前要删除案例的id信息
cur.execute('select policy_id from marketing_policy t where t.sp_id = "' + spId + '"')
jinnang = str(cur.fetchall()[0][0])
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicy/'
url = url_01 + jinnang
case_delete_act = requests.delete(url, headers=headers).text
case_delete_exp = 1
self.assertEqual(case_delete_exp, int(case_delete_act), msg="案例删除失败")
log.info(jinnang + "删除成功")
except LookupError:
print("没有需要删除的锦囊数据")
def test_b001_search(self):
try:
conn = MySQL().connect_portal()
cur = conn.cursor()
cur.execute("select partner_name from partner where `status`=0")
parnername = str(cur.fetchone()[0])
url_01 = 'http://admin.ejw.cn/portal/v1/partners?sort=%7B%22gmtCreate%22%3A%22desc%22%7D&status=0&pageNo=1&pageSize=10&partnerName='
url = url_01 + parnername
# 发送服务商接口请求
qykh_test_01 = requests.get(url, headers=headers)
qykh_test = qykh_test_01.text
# 判断当前返回码及字段值
self.assertIn(parnername, qykh_test, msg="没有查询到此用户信息")
log.info("企业客户管理-存在的用户查询成功")
except TypeError:
log.info("企业客户管理没有用户信息")
def test_a004_search(self):
conn = MySQL().connect_os()
cur = conn.cursor()
cur.execute(
"select partner_name from partner where partner_type = 0110;")
sql_result = cur.fetchone()[0:1]
parnername = sql_result[0]
url_01 = 'http://admin.ejw.cn/os/v1/partners?pageNo=1&pageSize=10&partnerType=0010%2C0011%2C0100%2C0101%2C0111%2C0110&partnerName='
url = url_01 + parnername
print(url)
# 发送服务商接口请求
qykh_test_01 = requests.get(url, headers=headers)
qykh_test = qykh_test_01.text
print(qykh_test)
self.assertIn(parnername, qykh_test, "查询的日志结果不一致")
log.info("合作伙伴管理-存在的信息查询成功")
def test_b003_jn_search(self):
try:
conn = MySQL().connect_mall()
cur = conn.cursor()
# 查询出当前要删除案例的id信息
cur.execute('select policy_Name from marketing_policy t where t.sp_id = "' + spId + '"')
result_exp = str(cur.fetchall()[0][0])
url_01 = "http://sp.ejw.cn/mall/v1/marketingpolicys?spId=" + spId + "&policyState=&pageNo=1&pageSize=10&policyName="
url = url_01 + result_exp
result_act = requests.get(url, headers=headers).text
self.assertIn(result_exp, result_act, msg="案例名称查询失败")
log.info("查询营销锦囊成功，返回营销锦囊记录，营销锦囊名称为：" + result_exp)
log_exp.info(result_exp)
log_act.info(result_act)
except TypeError:
log.info("查询列表数据为空")
def test_c005_product_serach(self):
conn = MySQL().connect_ps()
cur = conn.cursor()
sql = "select sp_product_name from sp_product t where t.sp_partner_id=" + spId + " order by create_date desc"
cur.execute(sql)
productName = str(cur.fetchone()[0])
log_exp.info(productName)
url_01 = "http://sp.ejw.cn/ps/v1/spproducts?buyType=&_sort=modifyDate%2Cdesc&pageSize=20&pageNum=1&spPartnerId=" \
+ spId + "&spProductName="
url = url_01 + productName
product_search = requests.get(url, headers=headers)
# print(product_search.text)
result_act = product_search.text
log_act.info(result_act)
self.assertIn(productName, result_act, msg="查询的产品名字不存在")
log.info("已有产品名称查询成功")
def test_e004employ(self):
# 连接数据库获取employee_id
conn = MySQL().connect_emp_os()
cur = conn.cursor()
cur.execute(
'select employee_id from employee where employee_name like "自动化测试%" and deleted = 1 and status != 2 '
)
employee_id = str(cur.fetchone()[0])
url_del = "http://emp.hnjing.com/emp_os/v1/employee/"
url = url_del + employee_id
emp_del = requests.delete(url, headers=headers)
result_del = json.loads(emp_del.text)
values = result_del["rowNum"]
result_exp = 1
self.assertEqual(result_exp, values)
log.info("员工离职")
def test_b003_jn_search(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '502'
# 查询出当前要删除案例的id信息
cur.execute(
'select policy_Name from marketing_policy t where t.sp_id = "' +
sql_data + '"')
result_exp = str(cur.fetchall()[0][0])
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicys?spId=502&policyState=&pageNo=1&pageSize=10&policyName='
url = url_01 + result_exp
result_act = requests.get(url, headers=headers).text
log_exp.info(result_exp)
log_act.info(result_act)
self.assertIn(result_exp, result_act, msg="案例名称查询失败")
log.info("案例名称查询成功")
def test_b002_shop(self):
try:
conn = MySQL().connect_mall()
cur = conn.cursor()
cur.execute(
'select rec_id from shoping_info t where t.sp_id = "' + spId + '" and t.emp_id= "' + cuEmpId + '"')
rec_id = str(cur.fetchone()[0])
url = "http://cu.ejw.cn/mall/v1/shopingcart/" + rec_id
result = requests.delete(url, headers=headers)
result_exp = "1"
self.assertEqual(result_exp, result.text, msg="企业平台删除购物车订单，删除失败")
log.info("企业平台删除购物车订单：操作成功")
log_exp.info(result_exp)
log_act.info(result.text)
except TypeError:
log.info("没有需要删除的购物车商品")
def test_b007_search(self):
try:
conn = MySQL().connect_portal()
cur1 = conn.cursor()
cur1.execute(
'select partner_id from partner where `status`=2 ORDER BY gmt_create DESC;'
)
par_result = cur1.fetchone()
partner_id = par_result[0]
url_01 = "http://admin.ejw.cn/portal/v1/partnerall/"
url = url_01 + str(partner_id)
result_act = requests.delete(url, headers=headers).status_code
result_exp = 200
self.assertEqual(result_exp, result_act, msg="返回响应码不一致，请检查是否有错")
log.info("用户运营-企业客户管理-企业审核不通过-删除通过")
except TypeError:
log.info("数据库查询信息为空,没有需要删除的企业客户")