def addgoods(self):
for books_cate in book_data:
category = GoodsCategory.objects.filter(pk=books_cate["category"])
if category:
for book in books_cate["books"]:
goods = Goods()
goods.category = category[0]
goods.name = book["name"]
goods.goods_sn = book["ISBN"]
goods.author = book["author"]
goods.click_num = goods.sold_num = goods.fav_num = 0
goods.goods_num = 200
goods.shop_price = book["shop_price"]
goods.market_price = goods.shop_price * 1.25
goods.bid = goods.shop_price * 0.8
goods.goods_brief = book["goods_brief"]
goods.goods_desc = book["goods_desc"]
goods.goods_front_image = book["images"][0]
goods.is_hot = goods.is_new = False
goods.save()
book_image_list = []
for book_image in book["images"]:
book_image_instance = GoodsImage()
book_image_instance.image = book_image
book_image_instance.goods = goods
book_image_list.append(book_image_instance)
GoodsImage.objects.bulk_create(book_image_list)
def import_product_data(self, datas):
from goods.models import Goods
from goods.models import GoodsCategory
from goods.models import GoodsImage
for data in datas:
good = Goods()
good.name = data['name']
# 商品类别为外键
# 通过名称筛选出类别再赋值
category = data['categorys'][-1]
good_category = GoodsCategory.objects.filter(name=category)
if category:
good.category = good_category[0]
good.market_price = float(data['market_price'].replace('￥', '').replace('元', ''))
good.shop_price = float(data['sale_price'].replace('￥', '').replace('元', ''))
good.goods_brief = data['desc'] if data['desc'] is not None else ''
good.goods_front_image = data['images'][0] if data['images'] is not None else ''
good.goods_desc = data['goods_desc'] if data['goods_desc'] is not None else ''
good.save()
if data['images'] is not None:
for image in data['images']:
good_image = GoodsImage()
good_image.goods = good
good_image.image = image
good_image.save()
def import_goods_data():
from goods.models import Goods, GoodsCategory, GoodsImage
with open('data/product_data.json', 'r', encoding='utf8') as f:
row_data = json.loads(f.read())
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()
def deal_product(data):
for goods_detail in 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()
def post(self, request, format=None):
file_obj = request.data["file"]
data = pd.read_excel(file_obj)
try:
for index, row in data.iterrows():
goods = Goods()
goods.gtin = row['id']
goods.company = row['company']
goods.spec = row['spec']
goods.name = row['name']
goods.brand = row['brand']
if len(eval(row['classes'])) > 0:
goods.is_class = 1
goods.save()
classes = eval(row['classes'])
for class_name in classes:
category = GoodsCategory.objects.filter(
name=class_name)
goods.classes.add(category[0])
else:
goods.save()
except Argument:
print(Argument)
return Response({"msg": "上传文件失败，请检查文件格式是否正确"})
else:
return Response(status=201, data={"code": 201, "msg": "上传数据成功"})
# print(data)
# print("here")
# return Response(status=201)
# def DashboardView(self):
# total = Goods.objects.all().count()
# is_class = Goods.objects.filter(is_class=1).count()
# no_class = total - is_class
# class_per = is_class / total
# json_data = {
# "total": total,
# "is_class": is_class,
# "no_class": no_class,
# "percent": class_per
# }
# return JsonResponse(json_data,safe=False)
# class DashboardView(View):
# def get(self, request):
# total = Goods.objects.all().count()
# is_class = Goods.objects.filter(is_class=1).count()
# no_class = total - is_class
# class_per = is_class / total
# json_data = {
# "total": total,
# "is_class": is_class,
# "no_class": no_class,
# "percent": class_per
# }
# return JsonResponse(json.dump(json_data),safe=False)
def addGoods(request):
goods=Goods()
goods.name=request.GET['name']
goods.description=request.GET['description']
goods.picture1=open("tmp\\nokia1.jpg","rb")
goods.picture2=open("tmp\\nokia2.jpg","rb")
goods.picture3=open("tmp\\nokia3.jpg","rb")
goods.price=105
# goods.time=datetime.datetime.now
goods.save()
return HttpResponse("success")
def __init__(self):
super(GoodsCreater, self).__init__(0)
counter = 300
while counter != 0:
new_object = Goods()
new_object.supplier = self.rdm_choice(self.LIST_OF_SUPPLIERS)
new_object.name = self.rdm_choice(self.LIST_OF_GOODS_NAMES)
new_object.price = randrange(0, 100)
path = self.user_goods_directory_path(
new_object, self.rdm_choice(self.LIST_OF_PICTURES))
print(path)
new_object.picture = path
new_object.description = self.rdm_choice(self.LIST_OF_DESCRIPTION)
new_object.save()
print(new_object)
counter -= 1
def import_goods(apps, schema_editor):
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detail in product_data.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_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()
dir_path = os.path.dirname(os.path.abspath(__file__))
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
import os
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
import django
django.setup()
from goods.models import Goods, GoodsCategory
data = pd.read_csv('data/water_classnum.csv')
# from db_tools.data.product_data import row_data
for index, row in data.iterrows():
# if index > 5:
# break
# print(len(eval(row['classes'])))
goods = Goods()
goods.gtin = row['id']
goods.company = row['company']
goods.spec = row['spec']
goods.name = row['name']
goods.brand = row['brand']
if len(eval(row['classes'])) > 0:
goods.is_class = 1
goods.save()
classes = eval(row['classes'])
for class_name in classes:
category = GoodsCategory.objects.filter(name=class_name)
goods.classes.add(category[0])
else:
goods.save()
print(index)
# for goods_detail in row_data:
# goods = Goods()
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数据导入完成')
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + '../')
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "MxShop.settings")
import django
django.setup()
#以上写好就能直接使用django model 独立出来使用
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for goods_derail in row_data:
goods = Goods()
goods.name = goods_derail['name']
goods.market_price = float(
int(goods_derail['market_price'].replace('￥', '').replace('元', '')))
goods.shop_price = float(
int(goods_derail['sale_price'].replace('￥', '').replace('元', '')))
goods.goods_brief = goods_derail['desc'] if goods_derail[
'desc'] is not None else ''
goods.goods_front_image = goods_derail['images'][0] if goods_derail[
'images'] else ''
category_name = goods_derail['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
# 获取当前文件的所在文件夹
currentDir = os.path.dirname(__file__)
# 将项目根目录追加到path里
sys.path.append(currentDir + "../")
# print(sys.path)
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'ShopDjango.settings')
import django
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
from db_tools.data.product_data import row_data
for product in row_data:
goods = Goods()
goods.name = product.get('name')
goods.market_price = float(
int(product.get('market_price').replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(product.get('sale_price').replace("￥", "").replace("元", "")))
goods.goods_brief = product.get('desc') if product.get(
'desc') is not None else ""
goods.goods_desc = product.get('goods_desc') if product.get(
'goods_desc') is not None else ""
goods.goods_front_image = product.get('images')[0] if product.get(
'images') else ""
goodsImages = product.get('images')
category_name = product.get('categorys')[-1]
# objects.filter会获取一个集合
category = GoodsCategory.objects.filter(name=category_name)
if category:
# 独立的使用Models
pwd = 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 goods_data in row_data:
goods = Goods()
goods.name = goods_data["name"]
goods.market_price = float(goods_data["market_price"].replace("￥",
"").replace(
"元", ""))
goods.shop_price = float(goods_data["sale_price"].replace("￥", "").replace(
"元", ""))
goods.goods_brief = goods_data["desc"] if goods_data[
"desc"] is not None else ""
goods.goods_desc = goods_data["goods_desc"] if goods_data[
"goods_desc"] is not None else ""
# 这里只取第一张
goods.front_page_image = goods_data["images"][0] if goods_data[
"images"] else ""
category_name = goods_data["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
import os
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + '../')
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "SmShop.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]
import os
import sys
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()
import sys
import os
pwd = os.path.dirname(os.path.relpath(__file__))
sys.path.append(os.path.abspath(os.path.join(pwd, '..')))
sys.path.append(pwd)
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'Freshshop.settings')
import django
django.setup()
from db_tools.data import product_data
from goods.models import Goods, GoodsBannerImage, GoodsCategory
for product in product_data.row_data:
goods = Goods()
goods.name = product['name']
goods.market_price = float(
int(product['market_price'].replace('￥', '').replace('元', '')))
goods.shop_price = float(
int(product['sale_price'].replace('￥', '').replace('元', '')))
goods.goods_detail = product['goods_desc'] if product[
'goods_desc'] is not None else ''
goods.desc = product['desc'] if product['desc'] is not None else ''
goods.image = product['images'][0] if product['images'][
0] is not None else ''
category_name = product['categorys'][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
goods.save()
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()
import os
# 独立使用model
pwd = os.path.dirname(os.path.realpath(__file__)) # 获得当前目录
sys.path.append(pwd + "../") # 当前目录加入python搜索路径之下
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'MxShop.settings')
import django
django.setup()
from goods.models import GoodsCategory, Goods, GoodsImage
from db_tools.data.product_data import row_data
for goods_detial in row_data:
goods = Goods()
goods.name = goods_detial["name"]
goods.market_price = float(
int(goods_detial["market_price"].replace("￥", "").replace("元", "")))
goods.shop_price = float(
int(goods_detial["market_price"].replace("￥", "").replace("元", "")))
goods.goods_brief = goods_detial["desc"] if goods_detial[
"desc"] is not None else ""
goods.goods_desc = goods_detial["goods_desc"] if goods_detial[
"goods_desc"] is not None else ""
goods.goods_front_image = goods_detial["images"][0] if goods_detial[
"images"] is not None else ""
category_name = goods_detial["categorys"][-1]
category = GoodsCategory.objects.filter(name=category_name)
if category:
goods.category = category[0]
import os
pwd = os.getcwd()
sys.path.append(pwd + "../")
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "Mxshop.settings")
import django
django.setup()
from goods.models import Goods, GoodsImage, GoodsCategory
from db_tools.data.product_data import row_data
for goods_detail in row_data:
goods = Goods()
goods.name = goods_detail.get('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["desc"] if goods_detail[
"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)
import os
pwd = os.path.dirname(os.path.realpath(__file__))
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
pwd = os.path.dirname(os.path.relpath(__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 goods_detail in row_data:
goods = Goods() #实例化
goods.name = goods_detail["name"] #实例化的name等于 goods_detail中的name
#实例化的market_price等于goods_detail中的market_price,但是要将“￥”转换为空串,将“元”转换为空串,然后将剩下的数字转换为int类型
#接着再将int类型的数据转换为float类型的数据
goods.market_price = float(int(goods_detail["market_price"].replace("￥","").replace("元",""))) #市场价格
goods.shop_price = float(int(goods_detail["sale_price"].replace("￥","").replace("元",""))) #本店价格
# 商品的简介对应goods_detail中的desc内容,如果goods_detail中的desc内容不为None，就设置为空串
goods.goods_brief = goods_detail["desc"] if goods_detail["desc"] is not None else ""
#商户的描述对应goods_detail中的goods_desc内容，如果goods_detail中的goods_desc内容不为空，就设置为空串
goods.goods_desc = goods_detail["goods_desc"] if goods_detail["goods_desc"] is not None else ""
#商品的封面图等于goods_detail中images中的第一张图，如果没有这么多图片，则设置为空串
goods.goods_front_image = goods_detail["images"][0] if goods_detail["images"] else ""
#商品类别的名字等于goods_detail中categorys中的倒数第一个
import django
django.setup()
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]
from db_tools.data.product_data import row_data
pwd = os.path.dirname(os.path.relpath(__file__))
sys.path.append(pwd+'../')
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "MxShop.settings")
django.setup()
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detail in row_data:
goods_install = Goods()
goods_install.name = goods_detail['name']
goods_install.market_price = float(int(goods_detail['market_price'].replace("￥", "").replace("元", "")))
goods_install.shop_price = float(int(goods_detail['sale_price'].replace("￥", "").replace("元", "")))
goods_install.goods_brief = goods_detail['desc'] and goods_detail['desc'] or ''
goods_install.goods_desc = goods_detail['goods_desc'] and goods_detail['goods_desc'] or ''
goods_install.goods_front_image = goods_detail['images'][0] if goods_detail['images'] else ""
categorys_name = goods_detail['categorys'][-1]
category = GoodsCategory.objects.filter(name=categorys_name)
if category:
goods_install.category = category[0]
goods_install.save()
for goods_image in goods_detail['images']:
goods_image_instace = GoodsImage()
goods_image_instace.image = goods_image
#独立使用django的models
import sys
import os
# 获取当前文件路径 __file__ 文件的完整路径和文件名
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append("../" + pwd)
# 和manage.py 中的环境变量保持一致
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "TTSX.settings")
# c:\\xxx\\b.py
# Django 版本大于等于1.7的时候，需要加上下面两句
import django
# 否则会抛出错误 django.core.exceptions.AppRegistryNotReady: Models aren't loaded yet.
django.setup()
from goods.models import Goods
# all_categorys = GoodsCategory.objects.all()
from db_tools.data.product_data import row_data
for goods_dateil in row_data:
goods = Goods()
goods.name = goods_dateil["name"]
#2.导入django设置
import django
django.setup()
#3.导入数据，和对应的Model
from db_tools.data.product_data import row_data
from goods.models import Goods, GoodsCategory, GoodsImage
for goods_detail in row_data:
# print(goods_detail)
instance = Goods()
instance.market_price = float(goods_detail["market_price"].replace(
"￥", "").replace("元", ""))
#商品名称
instance.name = goods_detail["name"] if goods_detail[
"name"] is not None else ""
#商品简单描述
instance.goods_brief = goods_detail["desc"] if goods_detail["desc"] else ""
#本店价格
instance.shop_price = float(goods_detail["sale_price"].replace(
"￥", "").replace("元", ""))
#商品详细介绍
instance.goods_desc = goods_detail["goods_desc"] if goods_detail[
"goods_desc"] else ""
#商品的封面
instance.goods_front_image = goods_detail["images"][0] if goods_detail[
"images"] else ""
#设置商品属于哪个商品类别
categorys_name = goods_detail["categorys"][-1] #'根茎类',或者
import sys, os
pwd = os.path.dirname(os.path.realpath(__file__))
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]
import sys
pwd = os.path.dirname(os.path.abspath(__file__))
sys.path.append(pwd+"../")
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "FoodMarket.settings")
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()
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + '../')
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'MxShop1.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_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]
import os
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + "../")
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "shop.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_front_image = models.ImageField(upload_to="goods/images/", null=True, blank=True, verbose_name="封面图")
# 商品是否新品
is_new = models.BooleanField(default=False, verbose_name='是否热销')
is_hot = models.BooleanField(default=False, verbose_name='是否热销')
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
