import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for good in row_data:
good_detail = Goods()
good_detail.name = good['name']
good_detail.market_price = float(good['market_price'].replace('￥',
'').replace(
'元', ''))
good_detail.sale_price = float(good['sale_price'].replace('￥', '').replace(
'元', ''))
good_detail.goods_brief = good['desc'] if good['desc'] is not None else ''
good_detail.goods_desc = good['goods_desc'] if good[
'goods_desc'] is not None else ''
good_detail.goods_front_image = good['images'][0] if good['images'] else ''
c_name = good['categorys'][-1]
category = GoodsCategory.objects.filter(name=c_name)
if category:
good_detail.category = category[0]
good_detail.save()
for goods_image in good['images']:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
# 转换float
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.sale_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail[
"desc"] is not None else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] is not None else ""
# 封面图
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
category_name = goods_detail["categorys"][-1]
# filter不抛异常,get抛异常
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
import django
django.setup()
from goods.models import Goods, GoodsCategoryBrand, GoodsImage, GoodsCategory
import re
for goods_detail in row_data:
print('goods_detail', goods_detail['name'])
goods = Goods()
goods.name = goods_detail['name']
goods.market_price = int(
re.match(r".*?(\d+\.{0,}\d{0,}).*?",
goods_detail['market_price']).group(1))
goods.sale_price = int(
re.match(r".*?(\d+\.{0,}\d{0,}).*?",
goods_detail['sale_price']).group(1))
goods.goods_brief = goods_detail['desc'] if goods_detail[
'desc'] is not None else ''
goods.goods_desc = goods_detail['goods_desc'] if goods_detail[
'goods_desc'] is not None else ''
goods.goods_front_images = goods_detail['images'][0] if goods_detail[
'images'] else ''
category_name = goods_detail['categorys'][-1] # 最后一个最精确
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
# F:\test\MxShop\db_tools\import_category_data.py
for goods_image in goods_detail['images']:
