def row():
row1 = []
for i in range(1, OperationExcel().getRows()):
if OperationExcel().getResult(i) == 'Y':
row1.append(i)
else:
pass
return row1
def setShopGroup_member_a():
dict1 = json.loads(OperationExcel().getRequestData(76))
dict1['bizData[resource_id]'] = getRead(key1='resource_id_4')
dict1['bizData[product_id]'] = getRead(key1='resource_id_4')
dict1['bizData[team_buy_id]'] = getRead(key1='team_buy_id')
dict1['bizData[team_buy_task_id]'] = getRead(key1='task_id')
return dict1
def setSvip_1():
dict1 = json.loads(OperationExcel().getRequestData(121))
dict1['bizData[resource_id]'] = getRead(key1='resource_id_9')
dict1['bizData[product_id]'] = getRead(key1='svip_id')
dict1['bizData[pre_get_info][product_id]'] = getRead(key1='svip_id')
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1='resource_id_9')
return dict1
def setShopArtifact_a():
dict1 = json.loads(OperationExcel().getRequestData(43))
dict1['bizData[resource_id]'] = getRead(key1='package_id')
dict1['bizData[pre_get_info][product_id]'] = getRead(key1='package_id')
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1='package_id')
dict1['bizData[referer][product_id]'] = getRead(key1='package_id')
return dict1
def setNewFace():
sj = "".join(random.sample('ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789', 6))
dict1 = json.loads(OperationExcel().getRequestData(237))
dict1['title'] = 'Pay_体验课' + sj
dict1['params[start_at]'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
return dict1
def setColumn_pub_c(row, keyid, cuid):
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['bizData[resource_id]'] = getRead(key1=keyid)
dict1['bizData[cu_id]'] = getRead(key1=cuid)
dict1['bizData[pre_get_info][product_id]'] = getRead(key1=keyid)
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1=keyid)
return dict1
def setNewFacehour(row, title, couid):
sj = "".join(random.sample('ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789', 6))
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['title'] = title + sj
dict1['course_id'] = getRead(key1=couid)
dict2 = json.dumps(dict1)
return dict2
def setSponFriends_a():
dict1 = json.loads(OperationExcel().getRequestData(53))
dict1['bizData[activity_id]'] = getRead(key1='activity_id_4')
dict1['bizData[goods_code]'] = getRead(key1='package_id_1')
dict1['bizData[upvote_user_id]'] = getRead(key1='upvote_user_id')
dict1['bizData[user_id]'] = getRead(key1='user_id')
return dict1
def setCreateCoupon():
dict1 = json.loads(OperationExcel().getRequestData(91))
dict1['title'] = 'Pay_优惠券' + str(random.randint(1, 99))
dict1['valid_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['invalid_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
return dict1
def setJumpMode_3():
dict1 = json.loads(OperationExcel().getRequestData(34))
dict1['bizData[resource_id]'] = getRead(key1='resource_id_3')
dict1['bizData[activity_id]'] = getRead(key1='activity_id_2')
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1='resource_id_3')
dict1['bizData[pre_get_info][activity_id]'] = getRead(key1='activity_id_2')
dict1['bizData[referer][resource_id]'] = getRead(key1='resource_id_3')
return dict1
def setColumnPublic(row, keyid):
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['bizData[resource_id]'] = getRead(key1=keyid)
dict1['bizData[pre_get_info][product_id]'] = getRead(key1=keyid)
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1=keyid)
dict1['bizData[referer][product_id]'] = getRead(key1=keyid)
dict1['bizData[referer][app_id]'] = getRead(key1='app_id')
return dict1
def setWXZapp_03(row):
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['shop_id'] = getRead(key1='shop_id')
dict1['uuid'] = getRead(key1='uuid')
dict1['app_id'] = getRead(key1='shop_id')
dict1['api_token'] = getRead(key1='api_token')
dict1['user_id'] = getRead(key1='Appuser_id')
return dict1
def setNewColumn(row, title):
'''新建专栏请求参数'''
s = 'ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789'
ss = random.sample(s, 6) #从s中随机取6个值
sj = "".join(ss)
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['params[name]'] = title + sj
return dict1
def setGroup_coupon():
dict1 = json.loads(OperationExcel().getRequestData(79))
dict1['resource_name'] = getRead(key1='name07')
dict1['resource_id'] = getRead(key1='resource_id_5')
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 1))
dict1['stop_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
return dict1
def setPassclock():
sj = "".join(random.sample('ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789', 6))
dict1 = json.loads(OperationExcel().getRequestData(272))
dict1['title'] = 'Pay_作业打卡' + sj
dict1['org_content'][0]['id'] = '1547' + str(int(time.time() * 1000))
dict1['class_hour_list'][0]['org_content'][0]['id'] = '1547' + str(
int(time.time() * 1000) + 1)
dict2 = json.dumps(dict1)
return dict2
def setFaceBuy_hsb(row, skid, reid, couid):
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['bizData[sku_id]'] = getRead(key1=skid)
dict1['bizData[resource_id]'] = getRead(key1=reid)
dict1['bizData[pre_get_info][sku_id]'] = getRead(key1=skid)
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1=reid)
dict1['bizData[edu_student_info][student_id]'] = getRead(key1='student_id')
dict1['bizData[edu_student_info][course_id]'] = getRead(key1=couid)
return dict1
def setFace_buy02():
dict1 = json.loads(OperationExcel().getRequestData(240))
dict1['bizData[sku_id]'] = getRead(key1='goods_code_01')
dict1['bizData[resource_id]'] = getRead(key1='course_offline_id_01')
dict1['bizData[pre_get_info][sku_id]'] = getRead(key1='goods_code_01')
dict1['bizData[pre_get_info][resource_id]'] = getRead(
key1='course_offline_id_01')
dict1['bizData[edu_student_info][student_id]'] = getRead(key1='student_id')
return dict1
def setNewActivity():
sj = "".join(random.sample('ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789', 6))
dict1 = json.loads(OperationExcel().getRequestData(293))
dict1['params[title]'] = 'Pay_活动管理' + sj
dict1['params[activity_start_at]'] = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
dict1['params[activity_end_at]'] = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time() + 2505600))
return dict1
def setNewFaceClass():
dict1 = json.loads(OperationExcel().getRequestData(255))
dict1['title'] = 'Pay_班级80' + str(random.randint(1, 99))
dict1['course_id'] = getRead(key1='course_id_03')
dict1['begin_time'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['end_time'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict2 = json.dumps(dict1)
return dict2
def setActivity_p():
field_content = '[[{"name":"姓名","content":"自动化测试机器人","required":"true","type":2},{"name":"手机号码","content":"18814480943","required":"true","type":1}]]'
dict1 = json.loads(OperationExcel().getRequestData(298))
dict1['bizData[resource_id]'] = getRead(key1='activity_id_9')
dict1['bizData[sku_id]'] = getRead(key1='sku_id')
dict1['bizData[ticket_id]'] = getRead(key1='ticket_id')
dict1['bizData[pre_get_info][resource_id]'] = getRead(key1='activity_id_9')
dict1['bizData[pre_get_info][sku_id]'] = getRead(key1='sku_id')
dict1['bizData[field_content]'] = field_content
return dict1
def setWXZapp_05():
dict1 = json.loads(OperationExcel().getRequestData(310))
dict1['shop_id'] = getRead(key1='shop_id')
dict1['resource_id'] = getRead(key1='APP_goods_id')
dict1['uuid'] = getRead(key1='uuid')
dict1['app_id'] = getRead(key1='shop_id')
dict1['api_token'] = getRead(key1='api_token')
dict1['user_id'] = getRead(key1='Appuser_id')
dict2 = json.dumps(dict1)
return dict2
def setNewgraphic01(row, title):
'''新建图文请求参数'''
s = 'ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789'
ss = random.sample(s, 6)
sj = "".join(ss)
dict1 = json.loads(OperationExcel().getRequestData(row))
dict1['params[title]'] = title + sj
dict1['params[start_at]'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
return dict1
def setSeckilling():
dict1 = json.loads(OperationExcel().getRequestData(25))
dict1['activity_name'] = 'Pay_预约秒杀' + str(random.randint(1, 99))
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 60))
dict1['end_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict1['goods_info[id]'] = getRead(key1='resource_id_2')
dict1['goods_info[resource_id]'] = getRead(key1='resource_id_2')
return dict1
def setCalendarclock():
sj = "".join(random.sample('ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789', 6))
dict1 = json.loads(OperationExcel().getRequestData(262))
dict1['title'] = 'Pay_日历打卡' + sj
dict1['org_content'][0]['id'] = '1547' + str(int(time.time() * 1000))
dict1['activity_start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['activity_stop_at'] = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time() + 2505600))
return dict1
class IsContent:
def __init__(self):
self.excel = OperationExcel()
def isContent(self, row, str1):
flag = None
if self.excel.getExpect(row=row) in str1:
flag = True
else:
flag = False
return flag
def setPromotion():
dict1 = json.loads(OperationExcel().getRequestData(18))
dict1['activity_name'] = 'Pay_限时折扣' + str(random.randint(1, 99))
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 3))
dict1['end_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict1['goods_list[0][resource_id]'] = getRead(key1='resource_id_1')
dict1['goods_list[0][goods_code]'] = getRead(key1='resource_id_1')
dict1['goods_list[0][resource_name]'] = getRead(key1='name01')
return dict1
def setSale():
dict1 = json.loads(OperationExcel().getRequestData(32))
dict1['activity_name'] = 'Pay_秒杀活动' + str(random.randint(1, 99))
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2))
dict1['end_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict1['goods_info[id]'] = getRead(key1='resource_id_3')
dict1['goods_info[resource_id]'] = getRead(key1='resource_id_3')
dict1['goods_info[title]'] = getRead(key1='name02')
return dict1
def setRoseArtifact():
dict1 = json.loads(OperationExcel().getRequestData(39))
dict1['activity_name'] = 'Pay_涨粉神器' + str(random.randint(1, 99))
dict1['resource_id'] = getRead(key1='package_id')
dict1['resource_name'] = getRead(key1='name03')
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['end_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict1['key_words'] = random.randint(1, 9999)
return dict1
def setRequestCode():
dict1 = json.loads(OperationExcel().getRequestData(96))
dict1['params[name]'] = 'Pay_邀请码' + str(random.randint(1, 99))
dict1['params[card_title]'] = 'Pay_邀请码' + str(random.randint(1, 99))
dict1['params[start_at]'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['params[stop_at]'] = time.strftime(
'%Y-%m-%d %H:%M:%S', time.localtime(time.time() + 2505600))
dict1['params[target_name]'] = getRead(key1='name08')
dict1['params[resource_id]'] = getRead(key1='resource_id_7')
return dict1
def setNewFriends_a():
dict1 = json.loads(OperationExcel().getRequestData(60))
dict1['activity_name'] = 'Pay_好友助力' + str(random.randint(1, 99))
dict1['goods_info[0][resource_id]'] = getRead(key1='package_id_2')
dict1['goods_info[0][resource_name]'] = getRead(key1='name05')
dict1['start_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
dict1['end_at'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time() + 2505600))
dict1['goods_info[0][goods_code]'] = getRead(key1='package_id_2')
return dict1
