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"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_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]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail["images"]:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
if __name__ == '__main__':
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail['name']
goods.market_price = float(goods_detail['market_price'].replace(
'￥', '').replace('元', ''))
goods.shop_price = float(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_font_image = goods_detail['images'][0] if goods_detail[
'images'] is not None else ''
category_name = goods_detail['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail['images']:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
sys.path.append(dir_path)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "gulishop.settings")
import django
django.setup()
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for item in row_data:
goods = Goods()
goods.name = item['name']
goods.goods_brief = item['desc'] if item['desc'] else ''
goods.goods_desc = item['goods_desc'] if item['goods_desc'] else ''
goods.market_price = item['market_price'].replace('￥', '').replace('元', '')
goods.shop_price = item['sale_price'].replace('￥', '').replace('元', '')
goods.goods_front_image = item['images'][0] if item['images'] else ''
category_name = item['categorys'][-1]
category_list = GoodsCategory.objects.filter(name=category_name)
if category_list:
goods.category = category_list[0]
goods.save()
for image in item['images']:
goods_image = GoodsImage()
goods_image.goods = goods
goods_image.image = image
goods_image.save()
from db_utils.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for item in row_data:
goods = Goods()
goods.market_price = float(item["market_price"].replace("元", "").replace(
"￥", ""))
goods.shop_price = float(item["market_price"].replace("元",
"").replace("￥", ""))
goods.name = item["name"] if item["name"] is not None else ""
# 商品的简单描述
goods.goods_brief = item["desc"] if item["desc"] is not None else ""
# 商品的详细描述
goods.goods_desc = item["goods_desc"] if item["goods_desc"] else ""
goods.goods_front_image = item["images"][0] if item["images"] else ""
# 类目：三级类目或者二级类目
category_name = item["categorys"][-1]
# 查看类目是否存在
categorys = GoodsCategory.objects.filter(name=category_name)
# print("categorys===",categorys)
if categorys:
goods.category = categorys[0]
goods.save()
for image in item["images"]:
sys.path.append(pwd + '../')
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "RXYshop.settings")
import django
django.setup()
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detils in row_data:
goods = Goods()
goods.name = goods_detils['name']
goods.goods_brief = goods_detils['desc'] if goods_detils[
'desc'] is not None else ""
goods.goods_desc = goods_detils['goods_desc'] if goods_detils[
'goods_desc'] is not None else ""
goods.market_price = float(
int(goods_detils['market_price'].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detils["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_front_image = goods_detils['images'][0] if goods_detils[
'images'] else ""
category_name = goods_detils['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for image_detail in goods_detils['images']:
image = GoodsImage()
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']
# get rid of symbols and characters and transfer into number
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detail["sale_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detail["desc"] if goods_detail["desc"] else ""
goods.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] else ""
goods.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
category_name = goods_detail["categorys"][-1]
# use filter instead of get here to avoid raising exceptions when there are none or more than one result
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
else:
category = GoodsCategory()
category.name = category_name
parent_name = goods_detail["categorys"][-2]
category.parent_category = GoodsCategory.objects.filter(
name=parent_name)[0]
category.code = category_name
import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for import_good_data in row_data:
db_good = Goods()
db_good.name = import_good_data["name"]
# 首页图片路径保存为字符串即可
db_good.goods_front_image = import_good_data["images"][0] if import_good_data["images"] else ''
db_good.market_price = float(int(import_good_data["market_price"].replace("￥", "").replace("元", "")))
db_good.shop_price = float(int(import_good_data["sale_price"].replace("￥", "").replace("元", "")))
db_good.goods_brief = import_good_data["desc"] if import_good_data["desc"] is not None else ""
db_good.goods_desc = import_good_data["goods_desc"] if import_good_data["goods_desc"] is not None else ""
# 取出最后一个根茎类字符串就可以了
category_name = import_good_data["categorys"][-1]
# 为什么使用filter不使用get因为使用django的get方法是从数据库的取得一个匹配的结果，返回一个对象，如果记录不存在的话，它会报错,
# 而且记录多于两条也会报错,而使用filter会返回结果的一个数组,当没有查询到结果时返回空数组。
goods_category = GoodsCategory.objects.filter(name=category_name)
if goods_category:
db_good.category = goods_category[0]
db_good.save()
# 把每个图片保存为对象
if import_good_data["images"]:
for image in import_good_data["images"]:
goods_image = GoodsImage()
goods_image.image = image
pwd = os.path.dirname(os.path.dirname(os.path.realpath(__file__)))
sys.path.append(pwd)
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'MxShop.settings')
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_instance = Goods()
good_instance.name = good['name']
good_instance.goods_desc = good['goods_desc'] if good[
'goods_desc'] is not None else ''
good_instance.market_price = good['market_price'].replace('￥', '').replace(
'元', '')
good_instance.shop_price = good['sale_price'].replace('￥',
'').replace('元', '')
good_instance.goods_brief = good['desc'] if good['desc'] is not None else ''
good_instance.goods_front_image = good['images'][0] if good[
'images'] else ''
category_name = good['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
good_instance.category = category[0]
good_instance.save()
for image in good['images']:
import os
import sys
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
sys.path.append(BASE_DIR)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "django_project.settings")
import django
django.setup()
from db_tool.data.goods_data import goods_data
from goods.models import Category, Goods
for data in goods_data:
goods = Goods()
goods.goods_id = data['goods_id']
goods.category = Category.objects.filter(pk=data['category']).first()
goods.name = data['name']
goods.market_price = data['market_price']
goods.goods_brief = data['goods_brief']
goods.goods_desc = data['goods_desc']
goods.goods_front_image = data['goods_front_image']
goods.periods = data['periods']
goods.save()
print('goods数据导入完成')
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
goods_image_instance.goods = good_detail
goods_image_instance.save()
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "daydayfresh.settings")
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']
goods.market_price = float(int(goods_detail['market_price'].replace('￥', '').replace('元', '')))
goods.shop_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]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
for goods_image in goods_detail['images']:
goods_image_instance = GoodsImage()
goods_image_instance.image = goods_image
goods_image_instance.goods = goods
goods_image_instance.save()
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + "../")
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "MaxShop.settings")
import django
django.setup()
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for data in row_data:
goods = Goods()
goods.name = data["name"]
goods.shop_price = float(
int(data["sale_price"].replace("￥", "").replace("元", "")))
goods.market_price = float(
int(data["market_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = data["desc"] if data["desc"] is not None else ""
goods.goods_desc = data["goods_desc"] if data[
"goods_desc"] is not None else ""
goods.goods_font_image = data["images"][0] if data["images"] else ""
goodscategory = GoodsCategory.objects.filter(name=data["categorys"][-1])[0]
if goodscategory:
goods.category = goodscategory
goods.save()
for image in data["images"]:
goods_image = GoodsImage()
goods_image.image = image
goods_image.goods = goods
goods_image.save()
