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()