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