def SelectCamera(self, uuid):
json = {"uuid": uuid, "control-mode": "exclusive"}
res = request.run_main('post', self.selectCamera_url, json=json)
print(res)
status = res['status']
if status == False:
time.sleep(2)
self.closeStream(uuid)
res1 = request.run_main('post', self.selectCamera_url, json=json)
if res1['status'] == True:
print('selectCamera操作成功1')
else:
print(res1)
else:
print('selectCamera操作成功2')
def test_16_pageApproveItem(self):
'''团队业绩明细-审批明细'''
sql_user_id = "SELECT user_id FROM t_activity_order WHERE activity_id = '{}'".format(
result[0]['id'])
results = self.mysql.fetchAll(sql_user_id)
pageApproveItem = self.pageApproveItem
json_pageApproveItem['activityId'] = result[0]['id']
json_pageApproveItem['approveUserId'] = results[0]['user_id']
pageApproveItem_res = request.run_main(
'post',
url=pageApproveItem,
headers=headers_Sunscreen_h5_Two,
json=json_pageApproveItem)
json_res_pageApproveItem = pageApproveItem_res
try:
self.assertEqual(json_res_pageApproveItem["success"], True)
self.assertEqual(json_res_pageApproveItem['code'], '200')
self.assertEqual(
json_res_pageApproveItem["data"]["list"][0]['result'], '通过')
print('团队业绩明细-审批明细测试用例通过: %s' %
json_res_pageApproveItem["success"])
except Exception as e:
print("团队业绩明细-审批明细测试用例不通过%s" % json.dumps(
json_res_pageApproveItem, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_pageApproveItem, indent=2, ensure_ascii=False))
def startToGrab(self, uuid):
json = {"uuid": uuid, "rgb": False}
res = request.run_main('post', self.startToGrab_url, json=json)
if res['status'] == True:
print('startToGrab操作成功')
else:
print(res)
def test_01_AddReward(self):
'''后台添加活动奖励'''
global activityName
activityName = "姬存希活动奖励yuan{0}".format(random.randint(6, 999999))
print("活动名称：" + activityName)
AddReward = self.AddReward
json_AddReward['name'] = activityName
json_AddReward['content'] = ''.join(
random.sample(string.ascii_letters + string.digits, 50))
json_AddReward['desc'] = ''.join(
random.sample(string.ascii_letters + string.digits, 50))
res = request.run_main('post',
url=AddReward,
headers=self.headers_Sunscreen_web,
json=json_AddReward)
json_AddReward_res = res
try:
self.assertEqual(json_AddReward_res["success"], True)
self.assertEqual(json_AddReward_res['code'], '200')
print('后台添加活动奖励测试用例通过: %s' % json_AddReward_res["success"])
except Exception as e:
print("后台添加活动奖励测试用例不通过%s" %
json.dumps(json_AddReward_res, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_AddReward_res, indent=2, ensure_ascii=False))
def detail(self, uuid):
json1 = {"uuid": uuid}
res = request.run_main('post', self.detail_url, json=json1)
if res['status'] == True:
print('detail操作成功')
else:
print(res)
print(json.dumps(res, indent=2, ensure_ascii=False))
def test_4_addFamily(self):
val = ''.join(random.sample(string.ascii_letters + string.digits, 60))
headers = {
"token":globals()["token"]
}
data = {
'familyName':'{}号家庭'.format(random.randint(6, 999999)),
'familyDescribe':val,
'file':'//img.mukewang.com/5de711c50951202612000676.jpg'
}
print("备注："+val)
res = request.run_main('post', url=self.addFamily, data=data, headers=headers)
json_res = res
print(json.dumps(json_res, indent=2, ensure_ascii=False))
self.assertEqual(json_res["description"], " 操作成功", msg="操作失败")
def test_06_User_info(self):
'''获取用户报名信息'''
User_info = self.User_info.format(result[0]['id'])
res = request.run_main('post',
url=User_info,
headers=headers_Sunscreen_h5_City)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('获取用户报名信息测试用例通过: %s' % json_res["success"])
except Exception as e:
print("获取用户报名信息测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_03_Slideshow(self):
'''首页轮播进入活动校验'''
Slideshow = self.Slideshow.format(result[0]['id'])
res = request.run_main('post',
url=Slideshow,
headers=headers_Sunscreen_h5_City)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('首页轮播进入活动校验测试用例通过： %s' % json_res["success"])
except Exception as e:
print("首页轮播进入活动校验测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_03_enableAutoApprove(self):
'''开启自动审批'''
enableAutoApprove = self.enableAutoApprove.format(result[0]['id'])
res = request.run_main('get',
url=enableAutoApprove,
headers=self.headers_Sunscreen_web)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('奖励活动开启自动审批测试用例通过: %s' % json_res["success"])
except Exception as e:
print("奖励活动开启自动审批测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_14_report(self):
'''团队业绩-总业绩'''
report = self.report.format(result[0]['id'])
report_res = request.run_main('post',
url=report,
headers=headers_Sunscreen_h5_Two)
json_report = report_res
try:
self.assertEqual(json_report["success"], True)
self.assertEqual(json_report['code'], '200')
print('团队业绩-总业绩测试用例通过: %s' % json_report["success"])
except Exception as e:
print("团队业绩-总业绩测试用例不通过%s" %
json.dumps(json_report, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_report, indent=2, ensure_ascii=False))
def test_11_page(self):
'''活动订单分页列表'''
page = self.page
res_page = request.run_main('post',
url=page,
headers=headers_Sunscreen_h5_Two,
json=json_page)
json_res_page = res_page
try:
self.assertEqual(json_res_page["success"], True)
self.assertEqual(json_res_page['code'], '200')
print('活动订单分页列表测试用例通过: %s' % json_res_page["success"])
except Exception as e:
print("活动订单分页列表测试用例不通过%s" %
json.dumps(json_res_page, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res_page, indent=2, ensure_ascii=False))
def test_17_report(self):
'''抢购活动列表'''
activity_page = self.activity_page
activity_page_res = request.run_main('post',
url=activity_page,
headers=headers_Sunscreen_h5_Two,
json=json_activity_page)
json_res_activity_page = activity_page_res
try:
self.assertEqual(json_res_activity_page["success"], True)
self.assertEqual(json_res_activity_page['code'], '200')
print('抢购活动列表测试用例通过: %s' % json_res_activity_page["success"])
except Exception as e:
print("抢购活动列表测试用例不通过%s" % json.dumps(
json_res_activity_page, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_activity_page, indent=2, ensure_ascii=False))
def test_1_test_login(self):
rows = handle.get_rows()
for i in range(rows):
data = handle.get_rows_value(i + 2)
is_run = data[2]
if is_run == 'yes':
method = data[6]
log_url = data[5]
json1 = eval(data[7])
headers = eval(data[9]) # 字符串转化字典类型
res = request.run_main(method, url=log_url, headers=headers, json=json1)
json_res = res
print(json.dumps(json_res, indent=2, ensure_ascii=False))
message=json_res["description"]
try:
self.assertEqual(message, " 登陆成功")
handle.excel_write_data(i+2, 15, "测试通过")
except Exception as e:
handle.excel_write_data(i+2, 15, "测试失败")
raise e
def test_3_login(self):
headers = {
"Content-Type": "application/json"
}
index = 1
rows = handle.get_rows(index)
for i in range(rows):
data = handle.get_rows_value( i + 2, index)
userAccount = data[0]
if userAccount == user:
userPassword = data[1]
json1 = {
"userAccount": userAccount,
"userPassword": userPassword
}
res = request.run_main('post', url=self.login, headers=headers, json=json1)
json_res = res
globals()["token"]=json_res["data"]["token"]
print(json.dumps(json_res, indent=2, ensure_ascii=False))
self.assertEqual(json_res["description"], " 登陆成功", msg="登陆失败")
def test_10_generate_two(self):
'''二级一键生成采购单'''
generate = self.generate
json_generate['activityId'] = result[0]['id']
res_generate = request.run_main('post',
url=generate,
headers=headers_Sunscreen_h5_Two,
json=json_generate)
json_res_generate = res_generate
try:
self.assertEqual(json_res_generate["success"], True)
self.assertEqual(json_res_generate['code'], '200')
print('二级一键生成采购单测试用例通过: %s' % json_res_generate["success"])
except Exception as e:
print("二级一键生成采购单测试用例不通过%s" %
json.dumps(json_res_generate, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_generate, indent=2, ensure_ascii=False))
def test_18_operate(self):
'''推送ERP'''
sql = "SELECT id FROM t_activity_order WHERE activity_id = '{}'".format(
result[0]['id'])
results = self.mysql.fetchAll(sql)
push1 = self.push.format(results[0]['id'])
push_res = request.run_main('get',
url=push1,
headers=headers_Sunscreen_web_uat)
json_res_push = push_res
try:
self.assertEqual(json_res_push["success"], True)
self.assertEqual(json_res_push['code'], '200')
print(f'推送ERP测试用例通过：{json_res_push["success"]}')
except Exception as e:
print(
f"推送ERP测试用例不通过: {json.dumps(json_res_push, indent=2, ensure_ascii=False)}"
)
raise e
logger.debug("this= %r",
json.dumps(json_res_push, indent=2, ensure_ascii=False))
def test_15_pageApprove(self):
'''团队业绩明细分页列表'''
pageApprove = self.pageApprove
json_pageApprove['activityId'] = result[0]['id']
pageApprove_res = request.run_main('post',
url=pageApprove,
headers=headers_Sunscreen_h5_Two,
json=json_pageApprove)
json_res_pageApprove = pageApprove_res
try:
self.assertEqual(json_res_pageApprove["success"], True)
self.assertEqual(json_res_pageApprove['code'], '200')
print('团队业绩明细分页列表测试用例通过: %s' % json_res_pageApprove["success"])
except Exception as e:
print(
"团队业绩明细分页列表测试用例不通过%s" %
json.dumps(json_res_pageApprove, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_pageApprove, indent=2, ensure_ascii=False))
def testrun_case(self, data):
#获取mock全部数据
# rows = handle.get_rows()
# for i in range(rows):
# data = handle.get_rows_value(i + 2)
cookie = None
get_cookie = None
header = None
is_run = data[2]
if is_run == 'yes':
method = data[6]
log_url = data[5]
json1 = eval(data[7])
headers = eval(data[9])
res = request.run_main(method,
url=log_url,
headers=headers,
json=json1)
json_res = res
print(json.dumps(json_res, indent=2, ensure_ascii=False))
def test_01_Save(self):
'''后台添加活动'''
global activityName
# activityName = emoji.emojize('姬存希活动yuan{0} :thumbs_up:').format(random.randint(6, 999999))
activityName = "姬存希活动yuan{0}".format(random.randint(6, 999999))
print("活动名称：" + activityName)
json_Save['activityName'] = activityName
res = request.run_main('post',
url=self.SaveUrl,
headers=headers_Sunscreen_web_uat,
json=json_Save)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('后台添加活动测试用例通过: %s' % json_res["success"])
except Exception as e:
print("后台添加活动测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_04_apply(self):
'''市级代理活动报名'''
json_apply['receiverName'] = GenPass()
json_apply['activityId'] = result[0]['id']
json_apply['receiverPhone'] = random.choice([
'139', '188', '185', '136', '158', '151'
]) + "".join(random.choice("0123456789") for i in range(8))
res = request.run_main('post',
url=self.applyurl,
headers=headers_Sunscreen_h5_City,
json=json_apply)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('市级代理活动报名测试用例通过： %s' % json_res["success"])
except Exception as e:
print("市级代理活动报名测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_02_publish(self):
'''活动上架'''
Activityname = activityName
sql = "SELECT id FROM t_activity_info WHERE activity_name = '{}'".format(
Activityname)
global result
result = self.mysql.fetchAll(sql)
publish = self.publish.format(result[0]['id'])
res = request.run_main('get',
url=publish,
headers=headers_Sunscreen_web_uat)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('活动上架测试用例通过: %s' % json_res["success"])
except Exception as e:
print("活动上架测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_05_pageApply(self):
'''活动管理报名记录'''
pageApply = self.pageApply
# print(result[0]['id'])
json_pageApply['activityId'] = result[0]['id']
res = request.run_main('post',
url=pageApply,
headers=headers_Sunscreen_web_uat,
json=json_pageApply)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
self.assertEqual(json_res["data"]["list"][0]['applyStatusDesc'],
'已报名')
print('报名记录测试用例通过: %s' % json_res["success"])
except Exception as e:
print("报名记录测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_02_OpenActivity(self):
'''活动上架'''
Activityname = activityName
sql = "SELECT id FROM reward_info WHERE reward_name = '{}'".format(
Activityname)
global result
result = self.mysql.fetchAll(sql)
openActivity = self.openActivity.format(result[0]['id'])
self.mysql.close()
res = request.run_main('get',
url=openActivity,
headers=self.headers_Sunscreen_web)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('奖励活动开启测试用例通过: %s' % json_res["success"])
except Exception as e:
print("奖励活动开启测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_09_agree_two(self):
'''二级审批通过'''
sql = "SELECT id,province_id FROM t_activity_apply_info WHERE activity_id = '{}'".format(
result[0]['id'])
results = self.mysql.fetchAll(sql)
json_Two['activityId'] = result[0]['id']
# json_agree['applyId']=results[0]['id']
json_Two['applyUserId'] = results[0]['province_id']
res = request.run_main('post',
url=self.agree,
headers=headers_Sunscreen_h5_Two,
json=json_Two)
json_res = res
try:
self.assertEqual(json_res["success"], True)
self.assertEqual(json_res['code'], '200')
print('二级审批通过测试用例通过: %s' % json_res["success"])
except Exception as e:
print("二级审批通过测试用例不通过%s" %
json.dumps(json_res, indent=2, ensure_ascii=False))
raise e
logger.debug("this= %r",
json.dumps(json_res, indent=2, ensure_ascii=False))
def test_13_operate(self):
'''操作订单审批通过或不通过'''
operate = self.operate
sql = "SELECT id FROM t_activity_order WHERE activity_id = '{}'".format(
result[0]['id'])
results = self.mysql.fetchAll(sql)
json_operate['orderIdList'][0] = results[0]['id']
operate_res = request.run_main('post',
url=operate,
headers=headers_Sunscreen_web_uat,
json=json_operate)
json_res_operate = operate_res
try:
self.assertEqual(json_res_operate["success"], True)
self.assertEqual(json_res_operate['code'], '200')
print('操作订单审批通过或不通过测试用例通过: %s' % json_res_operate["success"])
except Exception as e:
print("操作订单审批通过或不通过测试用例不通过%s" %
json.dumps(json_res_operate, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_operate, indent=2, ensure_ascii=False))
def test_12_saveVoucher(self):
'''保存支付凭证'''
saveVoucher = self.saveVoucher
sql = "SELECT id FROM t_activity_order WHERE activity_id = '{}'".format(
result[0]['id'])
results = self.mysql.fetchAll(sql)
json_saveVoucher['id'] = results[0]['id']
saveVoucher_res = request.run_main('post',
url=saveVoucher,
headers=headers_Sunscreen_h5_Two,
json=json_saveVoucher)
json_res_saveVoucher = saveVoucher_res
try:
self.assertEqual(json_res_saveVoucher["success"], True)
self.assertEqual(json_res_saveVoucher['code'], '200')
print('保存支付凭证测试用例通过: %s' % json_res_saveVoucher["success"])
except Exception as e:
print(
"保存支付凭证测试用例不通过%s" %
json.dumps(json_res_saveVoucher, indent=2, ensure_ascii=False))
raise e
logger.debug(
"this= %r",
json.dumps(json_res_saveVoucher, indent=2, ensure_ascii=False))
def test_2_register(self):
global user
user = random.randint(6, 999999)
play = GenPass()
pwd = md5_hb(play).Hashlib_md5()
json1 = {
"userAccount": user,
"userPassword": pwd
}
headers = {
"Content-Type": "application/json"
}
res = request.run_main('post', url=self.register_url, headers=headers, json=json1)
json_res = res
register = json_res["description"]
if register == " 注册成功":
register = json_res["description"]
else:
register = "注册失败,请重新注册"
print(json.dumps(json_res, indent=2, ensure_ascii=False))
array = [user, pwd, register]
handle.write_cell_content(array)
print("账号: "+ str(user))
print("密码：" + str(pwd))
def closeStream(self, uuid):
json = {"uuid": uuid}
res = request.run_main('post', self.closeStream_url, json=json)
print(res)
def getCameraList(self):
res = request.run_main('get', self.List_url)
res = res['data'][0]['uuid']
print('uuid:' + res)
return res
def test_01_warrant(self):
res = request.run_main('get', url=self.url, headers=headers_warrant)
json_res = res
print(json.dumps(json_res, indent=2, ensure_ascii=False))
