def test_c003_product_verify(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute(
"select uuid from product t where t.partner_id=190 and t.partner_type=0100 order by create_time desc;"
)
product_id = cur.fetchone()[0]
url = "http://sp.ejw.cn/sp/v1/productverify"
params = {
"partnerId": 190,
"productId": product_id,
"productType": "group",
"verifyType": 1,
"createUser": 24,
"partnerType": "0100"
}
product_search = requests.post(url,
data=json.dumps(params),
headers=headers)
product_name_act = json.loads(product_search.text)
print(product_name_act)
if product_name_act == 1:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核： 已发送审核邀请")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核： 审核中断")
def test_c001_product_search(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute("select t.product_name from product t where t.partner_type=0010 and sale_flag=1 and partner_id=190")
product_name = cur.fetchone()[0]
url_01 = "http://sp.ejw.cn/sp/v1/sproductauth?partnerId=190&cpPartnerId=&productType=&productName="
url = url_01 + product_name
product_search = requests.get(url, headers=headers)
product_name_act = json.loads(product_search.text)["products"][0]["partnerName"]
# print(product_name_act)
if product_name == product_name_act:
print("# 店铺管理-产品管理-产品上下架管理-发布产品-产品名称查询： 产品信息查询成功")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品-产品名称查询： 该服务商没有相应的产品，请先新增产品再发布")
def test_c007_product_verify(self):
# 连接ps数据库
conn1 = MySQL().connect_ps1('conn')
cur1 = conn1.cursor()
cur1.execute(
"select uuid from product t where t.partner_id=190 and t.partner_type=0010 and sale_flag=0 order by create_time desc")
products = cur1.fetchone()[0]
url = "http://sp.ejw.cn/platform/v1/productauth"
params = {"authType": 1, "spId": "190", "cpId": "190", "products": [products]}
product_verify = requests.post(url, data=json.dumps(params), headers=headers)
if product_verify.status_code == 200:
print("授权成功")
else:
print("授权失败")
def test_c004_product_verify(self):
conn = MySQL().connect_platform1('conn')
cur = conn.cursor()
cur.execute(
"select verify_id from product_verify where partner_id=190 and product_type='group' ORDER BY gmt_modified desc")
url_02 = str(cur.fetchone()[0])
url_01 = "http://sp.ejw.cn/platform/v1/productverify/"
url = url_01 + url_02
product_search = requests.delete(url, headers=headers)
product_name_act = json.loads(product_search.text)
print(product_name_act)
if product_name_act == 1:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核取消： 已取消审核邀请")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核取消： 取消审核中断")
def test_c003_product_verify(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute(
"select uuid from product t where t.partner_id=190 and t.partner_type=0100 order by create_time desc;")
product_id = cur.fetchone()[0]
url = "http://sp.ejw.cn/sp/v1/productverify"
params = {"partnerId": 190, "productId": product_id, "productType": "group", "verifyType": 1,
"createUser": 24, "partnerType": "0100"}
product_search = requests.post(url, data=json.dumps(params), headers=headers)
product_name_act = json.loads(product_search.text)
print(product_name_act)
if product_name_act == 1:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核： 已发送审核邀请")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核： 审核中断")
def test_a002_role_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute('select case_id from class_case_info t where t.sp_id = "' + sql_data + '"')
total = str(cur.fetchall()[0][0])
print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfo/'
url = url_01 + total
print(url)
case_delete_act = requests.delete(url, headers=headers).text
print(case_delete_act)
case_delete_exp = 1
if case_delete_exp == case_delete_act:
print("案例删除成功")
def test_c004_product_verify(self):
conn = MySQL().connect_platform1('conn')
cur = conn.cursor()
cur.execute(
"select verify_id from product_verify where partner_id=190 and product_type='group' ORDER BY gmt_modified desc"
)
url_02 = str(cur.fetchone()[0])
url_01 = "http://sp.ejw.cn/platform/v1/productverify/"
url = url_01 + url_02
product_search = requests.delete(url, headers=headers)
product_name_act = json.loads(product_search.text)
print(product_name_act)
if product_name_act == 1:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核取消： 已取消审核邀请")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品审核取消： 取消审核中断")
def test_b003_jn_search(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute('select policy_Name from marketing_policy t where t.sp_id = "' + sql_data + '"')
total = str(cur.fetchall()[0][0])
# print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicys?spId=190&policyState=&pageNo=1&pageSize=10&policyName='
url = url_01 + total
# print(url)
case_search_act = requests.get(url, headers=headers).text
# print(type(case_search_act))
if total in case_search_act:
print("案例名称查询信息成功")
else:
print("案例名称查询信息失败")
def test_c005_product_serach(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute(
"select product_name from product t where t.partner_id=190 and t.partner_type=0100 order by create_time desc")
productName = str(cur.fetchone()[0])
url_01 = "http://sp.ejw.cn/sp/v1/sp/190/products?productType=&pageSize=10&pageNo=1&productName="
url = url_01 + productName
print(url)
product_search = requests.get(url, headers=headers)
# print(product_search.text)
product_name_act = json.loads(product_search.text)["products"][0]["productName"]
# print(type(product_name_act))
if product_name_act == productName:
print(productName + '查询成功')
else:
print(productName + '查询失败')
def test_a002_role_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute('select case_id from class_case_info t where t.sp_id = "' +
sql_data + '"')
total = str(cur.fetchall()[0][0])
print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfo/'
url = url_01 + total
print(url)
case_delete_act = requests.delete(url, headers=headers).text
print(case_delete_act)
case_delete_exp = 1
if case_delete_exp == case_delete_act:
print("案例删除成功")
def test_c010_product_verify(self):
conn = MySQL().connect_platform1('conn')
cur = conn.cursor()
cur.execute("select cp_id,auth_id from product_auth where sp_id=190")
product_name = str(cur.fetchone()[0])
product_name_01 = str(cur.fetchone()[1])
print(product_name_01)
url_01 = "http://sp.ejw.cn/os/v1/partners?partnerId="
url = url_01 + product_name
try:
product_seach = requests.get(url, headers=headers).status_code
if product_seach == 200:
print("授权单号" + product_name_01 + "查询正常")
else:
print("授权单号" + product_name_01 + "没有查询到该信息")
except:
print("查询数据列表为空")
def test_c010_product_verify(self):
conn = MySQL().connect_platform1('conn')
cur = conn.cursor()
cur.execute("select cp_id,auth_id from product_auth where sp_id=190")
product_name = str(cur.fetchone()[0])
product_name_01 = str(cur.fetchone()[1])
print(product_name_01)
url_01 = "http://sp.ejw.cn/os/v1/partners?partnerId="
url = url_01 + product_name
try:
product_seach = requests.get(url, headers=headers).status_code
if product_seach == 200:
print("授权单号" + product_name_01 + "查询正常")
else:
print("授权单号" + product_name_01 + "没有查询到该信息")
except:
print("查询数据列表为空")
def test_c001_product_search(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute(
"select t.product_name from product t where t.partner_type=0010 and sale_flag=1 and partner_id=190"
)
product_name = cur.fetchone()[0]
url_01 = "http://sp.ejw.cn/sp/v1/sproductauth?partnerId=190&cpPartnerId=&productType=&productName="
url = url_01 + product_name
product_search = requests.get(url, headers=headers)
product_name_act = json.loads(
product_search.text)["products"][0]["partnerName"]
# print(product_name_act)
if product_name == product_name_act:
print("# 店铺管理-产品管理-产品上下架管理-发布产品-产品名称查询： 产品信息查询成功")
else:
print("# 店铺管理-产品管理-产品上下架管理-发布产品-产品名称查询： 该服务商没有相应的产品，请先新增产品再发布")
def test_a003_role_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute('select case_name from class_case_info t where t.sp_id = "' + sql_data + '"')
total = str(cur.fetchall()[0][0])
print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfos?spId=190&caseState=&pageSize=10&pageNo=1&caseName='
url = url_01 + total
print(url)
case_search_act = requests.get(url, headers=headers).text
print(type(case_search_act))
if total in case_search_act:
print("案例名称查询信息成功")
else:
print("案例名称查询信息失败")
def test_b002_jn_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute('select policy_id from marketing_policy t where t.sp_id = "' + sql_data + '"')
total = str(cur.fetchall()[0][0])
# print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicy/'
url = url_01 + total
# print(url)
case_delete_act = requests.delete(url, headers=headers).text
# print(type(case_delete_act))
case_delete_exp = 1
if case_delete_exp == int(case_delete_act):
print("案例删除成功")
else:
print("案例删除失败")
def test_c005_product_serach(self):
conn = MySQL().connect_ps1('conn')
cur = conn.cursor()
cur.execute(
"select product_name from product t where t.partner_id=190 and t.partner_type=0100 order by create_time desc"
)
productName = str(cur.fetchone()[0])
url_01 = "http://sp.ejw.cn/sp/v1/sp/190/products?productType=&pageSize=10&pageNo=1&productName="
url = url_01 + productName
print(url)
product_search = requests.get(url, headers=headers)
# print(product_search.text)
product_name_act = json.loads(
product_search.text)["products"][0]["productName"]
# print(type(product_name_act))
if product_name_act == productName:
print(productName + '查询成功')
else:
print(productName + '查询失败')
def test_a003_role_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute(
'select case_name from class_case_info t where t.sp_id = "' +
sql_data + '"')
total = str(cur.fetchall()[0][0])
print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/classcaseinfos?spId=190&caseState=&pageSize=10&pageNo=1&caseName='
url = url_01 + total
print(url)
case_search_act = requests.get(url, headers=headers).text
print(type(case_search_act))
if total in case_search_act:
print("案例名称查询信息成功")
else:
print("案例名称查询信息失败")
def test_b003_jn_search(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute(
'select policy_Name from marketing_policy t where t.sp_id = "' +
sql_data + '"')
total = str(cur.fetchall()[0][0])
# print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicys?spId=190&policyState=&pageNo=1&pageSize=10&policyName='
url = url_01 + total
# print(url)
case_search_act = requests.get(url, headers=headers).text
# print(type(case_search_act))
if total in case_search_act:
print("案例名称查询信息成功")
else:
print("案例名称查询信息失败")
def test_b002_jn_del(self):
conn = MySQL().connect_mall1('conn')
cur = conn.cursor()
sql_data = '190'
# 查询出当前要删除案例的id信息
cur.execute(
'select policy_id from marketing_policy t where t.sp_id = "' +
sql_data + '"')
total = str(cur.fetchall()[0][0])
# print(total)
url_01 = 'http://sp.ejw.cn/mall/v1/marketingpolicy/'
url = url_01 + total
# print(url)
case_delete_act = requests.delete(url, headers=headers).text
# print(type(case_delete_act))
case_delete_exp = 1
if case_delete_exp == int(case_delete_act):
print("案例删除成功")
else:
print("案例删除失败")
def test_c007_product_verify(self):
# 连接ps数据库
conn1 = MySQL().connect_ps1('conn')
cur1 = conn1.cursor()
cur1.execute(
"select uuid from product t where t.partner_id=190 and t.partner_type=0010 and sale_flag=0 order by create_time desc"
)
products = cur1.fetchone()[0]
url = "http://sp.ejw.cn/platform/v1/productauth"
params = {
"authType": 1,
"spId": "190",
"cpId": "190",
"products": [products]
}
product_verify = requests.post(url,
data=json.dumps(params),
headers=headers)
if product_verify.status_code == 200:
print("授权成功")
else:
print("授权失败")