def row(): row1 = [] for i in range(1, OperationExcel().getRows()): if OperationExcel().getResult(i) == 'Y': row1.append(i) else: pass return row1
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 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 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 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 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 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 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 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 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 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
def setEditColumn(row, title, resource_id): '''再次编辑专栏''' s = 'ABCDEFGHIJKLNMOPQRSTUVWXYZ0123456789' ss = random.sample(s, 6) sj = "".join(ss) dict1 = json.loads(OperationExcel().getRequestData(row)) dict1['params[name]'] = title + sj dict1['params[id]'] = getRead(key1=resource_id) dict1['lead[app_id]'] = getRead(key1='app_id') dict1['lead[resource_id]'] = getRead(key1=resource_id) return dict1
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 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 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 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