import django
pwd=os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd+"../")
#django初始化
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "Shop.settings")
django.setup()
from goods.models import Goods,GoodsCategory,GoodsImage#必须在django初始化之后才能引入
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.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_obj=GoodsImage()
goods_image_obj.goods=goods
goods_image_obj.image=goods_image
goods_image_obj.save()
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 goods_detail in row_data:
goods = Goods()
goods.name = goods_detail["name"]
#前端中是“￥232”，数据库中是float类型，所以要替换掉
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]
# 取出当前子类对应的GoodsCategory对象，filter没有匹配的会返回空数组，不会抛异常。
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
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'][0] 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
dir_path = os.path.dirname(file_path)
#第三步：讲这个目录的路径添加到我们的搜寻环境当中
sys.path.append(dir_path)
#第四步，动态设置我们的setting文件
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "gulishop.settings")
#第五步，让设置好的环境初始化生效
import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for item in row_data:
goods = Goods()
goods.name = item['name']
goods.goods_brief = item['desc'] if item['desc'] else ''
goods.desc = item['goods_desc'] if item['goods_desc'] else ''
goods.market_price = float(item['market_price'].replace('￥', '').replace(
'元', ''))
goods.shop_price = float(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']:
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
sys.path.append(pwd + "../")
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()
from goods.models import Goods, GoodsCategory, GoodsImage #这句一定要放在14、15这两行的下面，不能放在最顶上。因为必须要先把django引入之后才能写这个，不然会报错
from db_tools.data.product_data import row_data #引入商品
for goods_detail in row_data:
#上面的row_data是在produ_data.py这个文件里引入的
goods = Goods()
goods.name = goods_detail["name"]
goods.market_price = float(
int(goods_detail["market_price"].replace("￥", "").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.brief是在Goods的models中，后面的goods_detail是在product中，这几个需要一一对应
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
add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
'''
if __name__ == "__main__":
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for g in row_data:
g_instance = Goods()
g_instance.name = g['name']
g_instance.market_price = float(
int(g["sale_price"].replace("￥", "").replace("元", "")))
g_instance.shop_price = float(
int(g["sale_price"].replace("￥", "").replace("元", "")))
g_instance.goods_brief = g['desc'] if g['desc'] is not None else ''
g_instance.goods_desc = g['goods_desc'] if g[
'goods_desc'] is not None else ''
g_instance.goods_front_image = g['images'][0] if g['images'] else ''
# 类别
category = GoodsCategory.objects.filter(name=g['categorys'][-1])
if category:
g_instance.category = category[0]
g_instance.save()
# goodsimage
for img in g['images']:
good_img_instane = GoodsImage()
good_img_instane.goods = g_instance
good_img_instane.image = img
good_img_instane.save()
