def setUpClass(cls): for i in range(len(ableSale_data)): if ableSale_data[i]['sql']!='' and '{virtual_goods_id}' in ableSale_data[i]['body']: a=SqlData.themis_data(ableSale_data[i]['sql']) ableSale_data[i]['body']=ableSale_data[i]['body'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) else: continue
def setUpClass(cls): for i in range(len(deleteGoods_data)): if deleteGoods_data[i]['sql'] !='' and '{virtual_goods_id}' in deleteGoods_data[i]['body']: a=SqlData.themis_data(deleteGoods_data[i]['sql']) deleteGoods_data[i]['body']=deleteGoods_data[i]['body'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) if '{virtual_goods_id}' in deleteGoods_data[i]['msg']:#替换期望结果中的虚拟id deleteGoods_data[i]['msg']=(deleteGoods_data[i]['msg'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i]))) else: continue
def setUpClass(cls) : for i in range(len(getGroupProductId_data)): if getGroupProductId_data[i]['sql']!='' and '{virtual_goods_id}' in getGroupProductId_data[i]['body']: a=SqlData.themis_data(getGroupProductId_data[i]['sql']) getGroupProductId_data[i]['body']=getGroupProductId_data[i]['body'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) if '{virtual_goods_id}' in getGroupProductId_data[i]['msg']: getGroupProductId_data[i]['msg']=getGroupProductId_data[i]['msg'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) else: continue
def setUpClass(cls): for i in range(len(updateGoodsByType_data)): if updateGoodsByType_data[i]['sql'] != '' and '{virtual_goods_id}' in updateGoodsByType_data[i]['body']: a=SqlData.themis_data(updateGoodsByType_data[i]['sql']) updateGoodsByType_data[i]['body']=updateGoodsByType_data[i]['body'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) if '{virtual_goods_id}' in updateGoodsByType_data[i]['expect_result']: updateGoodsByType_data[i]['expect_result']=updateGoodsByType_data[i]['expect_result'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) if '{virtual_goods_id}' in updateGoodsByType_data[i]['msg']: updateGoodsByType_data[i]['msg']=updateGoodsByType_data[i]['msg'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i]))
def setUpClass(cls): try: for i in range(len(disableSale_data)): if disableSale_data[i]['sql']!='' and '{virtual_goods_id}' in disableSale_data[i]['body']: a=SqlData.themis_data(disableSale_data[i]['sql'])#连接数据库,返回数组,sql有可能不同 disableSale_data[i]['body']=disableSale_data[i]['body'].replace('{virtual_goods_id}',''.join('%s' %id for id in a[i])) else: continue except IndexError: print('下标越界')#因为海外仓商品数量少,所以可能存在商品不足,赋值错误
def setUpClass(cls): for i in range(len(updateRegionShippingFee_data)): if updateRegionShippingFee_data[i][ 'sql'] != '' and '{parent_sku}' in updateRegionShippingFee_data[ i]['body']: a = SqlData.themis_data(updateRegionShippingFee_data[i]['sql']) updateRegionShippingFee_data[i][ 'body'] = updateRegionShippingFee_data[i]['body'].replace( '{parent_sku}', str(a[i])) else: continue
def setUpClass(cls): for i in range(len(updateSkuImg_data)): if updateSkuImg_data[i]['sql']!='': a = SqlData.themis_data(updateSkuImg_data[i]['sql']) if '{product_id}' in updateSkuImg_data[i]['body']: updateSkuImg_data[i]['body']=updateSkuImg_data[i]['body'].replace('{product_id}',str(a[i][0])) if '{goods_sku}' in updateSkuImg_data[i]['body']: updateSkuImg_data[i]['body']=updateSkuImg_data[i]['body'].replace('{goods_sku}',str(a[i][1])) if '{img_id}' in updateSkuImg_data[i]['body']: updateSkuImg_data[i]['body']=updateSkuImg_data[i]['body'].replace('{img_id}',str(a[i][2])) else: continue
def setUpClass(cls): for i in range(len(uploadSizeChart_data)): if uploadSizeChart_data[i]['sql'] != '': a = SqlData.themis_data(uploadSizeChart_data[i]['sql']) if '{product_id}' in uploadSizeChart_data[i]['body']: uploadSizeChart_data[i]['body'] = uploadSizeChart_data[i][ 'body'].replace('{product_id}', ''.join('%s' % id for id in a[i])) if '{product_id}' in uploadSizeChart_data[i][ 'expect_result']: uploadSizeChart_data[i][ 'expect_result'] = uploadSizeChart_data[i][ 'expect_result'].replace( '{product_id}', ''.join('%s' % id for i in a[i])) else: continue
def setUpClass(cls): for i in range(len(getProductImgInfo_data)): if getProductImgInfo_data[i][ 'sql'] != '' and '{virtual_goods_id}' in getProductImgInfo_data[ i]['params']: a = SqlData.themis_data(getProductImgInfo_data[i]['sql']) getProductImgInfo_data[i]['params'] = getProductImgInfo_data[ i]['params'].replace('{virtual_goods_id}', ''.join('%s' % id for id in a[i])) if '{virtual_goods_id}' in getProductImgInfo_data[i][ 'expect_result']: getProductImgInfo_data[i][ 'expect_result'] = getProductImgInfo_data[i][ 'expect_result'].replace( '{virtual_goods_id}', ''.join('%s' % id for id in a[i])) else: continue
def setUpClass(cls): for i in range(len(addProductSku_data)): if addProductSku_data[i][ 'sql'] != '' and '{parent_sku}' in addProductSku_data[i][ 'body']: a = SqlData.themis_data(addProductSku_data[i]['sql']) addProductSku_data[i]['body'] = addProductSku_data[i][ 'body'].replace('{parent_sku}', ''.join('%s' % id for id in a[i])) if '{goods_sku}' in addProductSku_data[i]['body']: addProductSku_data[i]['body'] = addProductSku_data[i][ 'body'].replace('{goods_sku}', 'r' + str(random.randint(1, 10000))) if '{style_quantity}' in addProductSku_data[i]['body']: addProductSku_data[i]['body'] = addProductSku_data[i][ 'body'].replace('{style_quantity}', str(random.randint(1, 10000))) else: continue