def import_category_data():
from goods.models import GoodsCategory
with open('data/category_data.json', 'r', encoding='utf8') as f:
row_data = json.loads(f.read())
for lev1_cat in row_data:
lev1_intance = GoodsCategory()
lev1_intance.code = lev1_cat["code"]
lev1_intance.name = lev1_cat["name"]
lev1_intance.category_type = 1
lev1_intance.save()
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_intance = GoodsCategory()
lev2_intance.code = lev2_cat["code"]
lev2_intance.name = lev2_cat["name"]
lev2_intance.category_type = 2
lev2_intance.parent_category = lev1_intance
lev2_intance.save()
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_intance = GoodsCategory()
lev3_intance.code = lev3_cat["code"]
lev3_intance.name = lev3_cat["name"]
lev3_intance.category_type = 3
lev3_intance.parent_category = lev2_intance
lev3_intance.save()
def addcate(self):
# 一级分类
for lev1_cat in book_categories:
lev1_intance = GoodsCategory()
lev1_intance.code = lev1_cat["cate_code"]
lev1_intance.name = lev1_cat["cate_name"]
lev1_intance.category_type = 1
lev1_intance.save()
# 二级分类
for lev2_cat in lev1_cat["sub_cate"]:
lev2_intance = GoodsCategory()
lev2_intance.code = lev2_cat["cate_code"]
lev2_intance.name = lev2_cat["cate_name"]
lev2_intance.category_type = 2
lev2_intance.parent_category = lev1_intance
lev2_intance.save()
# 三级分类
for lev3_cat in lev2_cat["sub_cate"]:
lev3_intance = GoodsCategory()
lev3_intance.code = lev3_cat["cate_code"]
lev3_intance.name = lev3_cat["cate_name"]
lev3_intance.category_type = 3
lev3_intance.parent_category = lev2_intance
lev3_intance.save()
def add_cate(parent_cate, parent_cate_instance, deap):
cates = parent_cate.get("sub_categorys", None)
if cates:
for sub_cate in cates:
cate_instance = GoodsCategory()
cate_instance.name = sub_cate["name"]
cate_instance.code = sub_cate["code"]
cate_instance.parent_category = parent_cate_instance
cate_instance.category_type = deap + 1
cate_instance.save()
add_cate(sub_cate, cate_instance, deap + 1)
else:
return
def import_category(apps, schema_editor):
for lev1_cat in category_data.row_data:
lev1_instance = GoodsCategory()
lev1_instance.code = lev1_cat['code']
lev1_instance.name = lev1_cat['name']
lev1_instance.category_type = 1
lev1_instance.save()
for lev2_cat in lev1_cat['sub_categorys']:
lev2_instance = GoodsCategory()
lev2_instance.code = lev2_cat['code']
lev2_instance.name = lev2_cat['name']
lev2_instance.category_type = 2
lev2_instance.parent_category = lev1_instance
lev2_instance.save()
for lev3_cat in lev2_cat['sub_categorys']:
lev3_instance = GoodsCategory()
lev3_instance.code = lev3_cat['code']
lev3_instance.name = lev3_cat['name']
lev3_instance.category_type = 3
lev3_instance.parent_category = lev2_instance
lev3_instance.save()
def import_category_data(self, datas):
from goods.models import GoodsCategory
for data_lv1 in datas:
goods_category_lv1 = GoodsCategory()
goods_category_lv1.name = data_lv1['name']
goods_category_lv1.code = data_lv1['code']
goods_category_lv1.category_type = 1
goods_category_lv1.save()
for data_lv2 in data_lv1['sub_categorys']:
goods_category_lv2 = GoodsCategory()
goods_category_lv2.name = data_lv2['name']
goods_category_lv2.code = data_lv2['code']
goods_category_lv2.category_type = 2
goods_category_lv2.parent_category = goods_category_lv1
goods_category_lv2.save()
for data_lv3 in data_lv2['sub_categorys']:
goods_category_lv3 = GoodsCategory()
goods_category_lv3.name = data_lv3['name']
goods_category_lv3.code = data_lv3['code']
goods_category_lv3.category_type = 3
goods_category_lv3.parent_category = goods_category_lv2
goods_category_lv3.save()
def deal_category(data, depth, category_pro):
if not isinstance(data, (list, dict)):
raise TypeError("数据格式不正确")
if isinstance(data, dict) and len(data):
category_instance = GoodsCategory()
category_instance.code = data["code"]
category_instance.name = data["name"]
category_instance.category_type = depth
if category_pro is not None:
category_instance.parent_category = category_pro
category_instance.save()
next_node = data.get('sub_categorys', '')
if isinstance(next_node, list):
for node in next_node:
deal_category(node, depth + 1, category_instance)
def add_data(data, type, parent_instance=None):
'''
填充数据用的
:param data: 数据主体
:param type: 类型
:param parent_instance: 父类实体
:return goods 实例主体:
'''
goods = GoodsCategory()
goods.code = data['code']
goods.name = data['name']
goods.category_type = type
if parent_instance is not None:
goods.parent_category = parent_instance
goods.save()
return goods
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
category.category_type = 2
category.save()
goods.category = category
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()
from db_tools.data.category_data import row_data
props = {
'code': 'code',
'name': 'name',
'sub_categories': 'sub_categories'
}
for leve1_cat in row_data:
leve1_instance = GoodsCategory()
leve1_instance.code = leve1_cat[props['code']]
leve1_instance.name = leve1_cat[props['name']]
leve1_instance.category_type = 1
leve1_instance.save()
for leve2_cat in leve1_cat[props['sub_categories']]:
leve2_instance = GoodsCategory()
leve2_instance.code = leve2_cat[props['code']]
leve2_instance.name = leve2_cat[props['name']]
leve2_instance.category_type = 2
leve2_instance.parent_category = leve1_instance
leve2_instance.save()
for leve3_cat in leve2_cat[props['sub_categories']]:
leve3_instance = GoodsCategory()
leve3_instance.code = leve3_cat[props['code']]
leve3_instance.name = leve3_cat[props['name']]
leve3_instance.category_type = 3
leve3_instance.parent_category = leve2_instance
leve3_instance.save()
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'shopping.settings')
import django
django.setup()
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
for lev1_cat in row_data:
lev1_sintance = GoodsCategory()
lev1_sintance.code = lev1_cat["code"]
lev1_sintance.name = lev1_cat["name"]
lev1_sintance.category_type = 1
lev1_sintance.save()
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_sintance = GoodsCategory()
lev2_sintance.code = lev2_cat["code"]
lev2_sintance.name = lev2_cat["name"]
lev2_sintance.category_type = 2
lev2_sintance.parent_category = lev1_sintance
lev2_sintance.save()
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_sintance = GoodsCategory()
lev3_sintance.code = lev3_cat["code"]
lev3_sintance.name = lev3_cat["name"]
lev3_sintance.category_type = 3
lev3_sintance.parent_category = lev2_sintance
lev3_sintance.save()
from db_tools.data.category_data import row_data
# 一级类
for lev1_cat in row_data:
lev1_intance = GoodsCategory()
lev1_intance.name = lev1_cat["name"]
lev1_intance.code = lev1_cat["code"]
lev1_intance.category_type = 1 # 一级类别
lev1_intance.save()
# 二级类
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_intance = GoodsCategory()
lev2_intance.name = lev2_cat["name"]
lev2_intance.code = lev2_cat["code"]
lev2_intance.category_type = 2 # 二级类别
lev2_intance.parent_category = lev1_intance # 父级分类
lev2_intance.save()
# 三级类
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_intance = GoodsCategory()
lev3_intance.name = lev3_cat["name"]
lev3_intance.code = lev3_cat["code"]
lev3_intance.category_type = 3 # 二级类别
lev3_intance.parent_category = lev2_intance # 父级分类
lev3_intance.save()
from db_tools.data.category_data import row_data
#对数据遍历入库
for lev1_cat in row_data: #第一个类别
lev1_instance = GoodsCategory() #数据库的对象等于GoodsCategory
lev1_instance.code = lev1_cat["code"] #实例的code等于lev1_cat中的code
lev1_instance.name = lev1_cat["name"] # 实例的name等于lev1_cat中的name
lev1_instance.category_type = 1 #实例的类型选择一级目录 “1”
lev1_instance.save() #保存到数据库
#遍历子类
for lev2_cat in lev1_cat["sub_categorys"]: #遍历子类
lev2_instance = GoodsCategory() # 数据库的对象等于GoodsCategory
lev2_instance.code = lev2_cat["code"] # 实例的code等于lev2_cat中的code
lev2_instance.name = lev2_cat["name"] # 实例的name等于lev2_cat中的name
lev2_instance.category_type = 2 # 实例的类型选择二级目录 “2”
lev2_instance.parent_category = lev1_instance # lev2的父类是lev1
lev2_instance.save() # 保存到数据库
#遍历lev2的子类
for lev3_cat in lev2_cat["sub_categorys"]: # 遍历子类
lev3_instance = GoodsCategory() # 数据库的对象等于GoodsCategory
lev3_instance.code = lev3_cat["code"] # 实例的code等于lev3_cat中的code
lev3_instance.name = lev3_cat["name"] # 实例的name等于lev3_cat中的name
lev3_instance.category_type = 3 # 实例的类型选择三级目录 “3”
lev3_instance.parent_category = lev2_instance # lev3的父类是lev2
lev3_instance.save() # 保存到数据库
sys.path.append(pwd + "../")
#django初始化
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "Shop.settings")
django.setup()
from goods.models import GoodsCategory #必须在django初始化之后才能引入
from db_tools.data.category_data import row_data
for lev1_cat in row_data:
lev1_obj = GoodsCategory()
lev1_obj.code = lev1_cat["code"]
lev1_obj.name = lev1_cat["name"]
lev1_obj.category_type = 1
lev1_obj.save()
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_obj = GoodsCategory()
lev2_obj.code = lev2_cat["code"]
lev2_obj.name = lev2_cat["name"]
lev2_obj.category_type = 2
lev2_obj.parent_category = lev1_obj
lev2_obj.save()
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_obj = GoodsCategory()
lev3_obj.code = lev3_cat["code"]
lev3_obj.name = lev3_cat["name"]
lev3_obj.category_type = 3
lev3_obj.parent_category = lev2_obj
lev3_obj.save()
# 启动django
django.setup()
from goods.models import GoodsCategory
for lev1_cat in row_data:
lev1_install = GoodsCategory()
lev1_install.code = lev1_cat['code']
lev1_install.name = lev1_cat['name']
lev1_install.category_type = 1
lev1_install.save()
for lev2_cat in lev1_cat['sub_categorys']:
lev2_intance = GoodsCategory()
lev2_intance.name = lev2_cat['name']
lev2_intance.code = lev2_cat['code']
lev2_intance.category_type = 2
lev2_intance.parent_category = lev1_install
lev2_intance.save()
for lev3_cat in lev2_cat['sub_categorys']:
lev3_install = GoodsCategory()
lev3_install.name = lev3_cat['name']
lev3_install.code = lev3_cat['code']
lev3_install.category_type = 3
lev3_install.parent_category = lev2_intance
lev3_install.save()
print('insert data over!!!')
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 goods.models import GoodsCategory
from db_tools.data import category_data
for rank1_cate in category_data.row_data:
goods_cate_1 = GoodsCategory()
goods_cate_1.code = rank1_cate['code']
goods_cate_1.name = rank1_cate['name']
goods_cate_1.category_type = 1
goods_cate_1.save()
for rank2_cate in rank1_cate['sub_categorys']:
goods_cate_2 = GoodsCategory()
goods_cate_2.code = rank2_cate['code']
goods_cate_2.name = rank2_cate['name']
goods_cate_2.category_type = 2
goods_cate_2.parent_category = goods_cate_1
goods_cate_2.save()
for rank3_cate in rank2_cate['sub_categorys']:
goods_cate_3 = GoodsCategory()
goods_cate_3.code = rank3_cate['code']
goods_cate_3.name = rank3_cate['name']
goods_cate_3.category_type = 3
goods_cate_3.parent_category = goods_cate_2
goods_cate_3.save()
#
# verifycode = VerifyCode()
# verifycode.code = "1234"
# verifycode.mobile = "18601042258"
# verifycode.save()
#存数据，--->数据库
for item1 in row_data:
instance1 = GoodsCategory()
instance1.category_type = 1 #当前就是一级商品类目
instance1.name = item1["name"] #商品类别的名称
instance1.code = item1["code"] #商品类别的编码
instance1.save() #保存数据库
for item2 in item1["sub_categorys"]:
instance2 = GoodsCategory()
instance2.category_type = 2 # 当前就是二级商品类目
instance2.name = item2["name"] # 商品类别的名称
instance2.code = item2["code"] # 商品类别的编码
instance2.parent_category = instance1 #上级商品类目
instance2.save() #保存到数据库
for item3 in item2["sub_categorys"]:
instance3 = GoodsCategory()
instance3.category_type = 3 # 当前就是二级商品类目
instance3.name = item3["name"] # 商品类别的名称
instance3.code = item3["code"] # 商品类别的编码
instance3.parent_category = instance2 # 上级商品类目
instance3.save() #保存到数据库
print(item3)
import django
django.setup()
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
for lev1_cat in row_data:
lev1_intance = GoodsCategory()
lev1_intance.code = lev1_cat["code"]
lev1_intance.name = lev1_cat["name"]
lev1_intance.category_type = 1
lev1_intance.save()
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_intance = GoodsCategory()
lev2_intance.code = lev2_cat["code"]
lev2_intance.name = lev2_cat["name"]
lev2_intance.category_type = 2
lev2_intance.parent_category = lev1_intance
lev2_intance.save()
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_intance = GoodsCategory()
lev3_intance.code = lev3_cat["code"]
lev3_intance.name = lev3_cat["name"]
lev3_intance.category_type = 3
lev3_intance.parent_category = lev2_intance
lev3_intance.save()
sys.path.append(pwd+"../")
#django初始化
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "Shop.settings")
django.setup()
from goods.models import GoodsCategory#必须在django初始化之后才能引入
from db_tools.data.category_data import row_data
for lev1_cat in row_data:
lev1_obj=GoodsCategory()
lev1_obj.code=lev1_cat["code"]
lev1_obj.name=lev1_cat["name"]
lev1_obj.category_type=1
lev1_obj.save()
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_obj = GoodsCategory()
lev2_obj.code = lev2_cat["code"]
lev2_obj.name = lev2_cat["name"]
lev2_obj.category_type = 2
lev2_obj.parent_category=lev1_obj
lev2_obj.save()
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_obj = GoodsCategory()
lev3_obj.code = lev3_cat["code"]
lev3_obj.name = lev3_cat["name"]
lev3_obj.category_type = 3
lev3_obj.parent_category = lev2_obj
lev3_obj.save()
import django
django.setup()
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
for lvl1_cat in row_data:
lvl1_instance = GoodsCategory()
lvl1_instance.code = lvl1_cat["code"]
lvl1_instance.name = lvl1_cat["name"]
lvl1_instance.category_type = 1
lvl1_instance.save()
for lvl2_cat in lvl1_cat["sub_categorys"]:
lvl2_instance = GoodsCategory()
lvl2_instance.code = lvl2_cat["code"]
lvl2_instance.name = lvl2_cat["name"]
lvl2_instance.category_type = 2
lvl2_instance.parent_category = lvl1_instance
lvl2_instance.save()
for lvl3_cat in lvl2_cat["sub_categorys"]:
lvl3_instance = GoodsCategory()
lvl3_instance.code = lvl3_cat["code"]
lvl3_instance.name = lvl3_cat["name"]
lvl3_instance.category_type = 3
lvl3_instance.parent_category = lvl2_instance
lvl3_instance.save()
import django
django.setup()
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
import_data = row_data
for data_1 in import_data:
obj_1 = GoodsCategory()
obj_1.name = data_1["name"]
obj_1.code = data_1["code"]
obj_1.category_type = 1
obj_1.save()
for data_2 in data_1["sub_categorys"]:
obj_2 = GoodsCategory()
obj_2.name = data_2["name"]
obj_2.code = data_2["code"]
obj_2.category_type = 2
obj_2.parent_category = obj_1
obj_2.save()
for data_3 in data_2["sub_categorys"]:
obj_3 = GoodsCategory()
obj_3.name = data_2["name"]
obj_3.code = data_2["code"]
obj_3.category_type = 3
obj_3.parent_category = obj_2
obj_3.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.category_data import row_data
from goods.models import GoodsCategory
for lev1 in row_data:
cat1 = GoodsCategory()
cat1.name = lev1['name']
cat1.code = lev1['code'] if lev1['code'] else ''
cat1.category_type = 1
cat1.save()
for lev2 in lev1['sub_categorys']:
cat2 = GoodsCategory()
cat2.name = lev2['name']
cat2.code = lev2['code'] if lev1['code'] else ''
cat2.category_type = 2
cat2.parent_category = cat1
cat2.save()
for lev3 in lev2['sub_categorys']:
cat3 = GoodsCategory()
cat3.name = lev3['name']
cat3.code = lev3['code'] if lev1['code'] else ''
cat3.category_type = 3
cat3.parent_category = cat2
cat3.save()
django.setup()
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
# 1级分类
for level1_cat in row_data:
category1 = GoodsCategory()
category1.name_en = level1_cat["code"]
category1.name = level1_cat["name"]
category1.category_level = 1
category1.save()
# 二级分类
for level2_cat in level1_cat["sub_categorys"]:
category2 = GoodsCategory()
category2.name_en = level2_cat["code"]
category2.name = level2_cat["name"]
category2.category_level = 2
category2.parent_category = category1
category2.save()
# 三级分类
for level3_cat in level2_cat["sub_categorys"]:
category3 = GoodsCategory()
category3.name_en = level3_cat["code"]
category3.name = level3_cat["name"]
category3.category_level = 3
category3.parent_category = category2
category3.save()
django.setup()
# 这个必须放在os.environ.setdefault("DJANGO_SETTINGS_MODULE", "FoodMarket.settings")之后
# 因为当还没有把FoodMartket目录添加进来,也还没有把setting文件当做为django默认setting文件
from db_tools.data.category_data import row_data
from goods.models import GoodsCategory
for category1 in row_data:
instance1 = GoodsCategory()
instance1.name = category1["name"]
instance1.code = category1["code"]
instance1.category_type = 1
instance1.save()
for category2 in category1["sub_categorys"]:
instance2 = GoodsCategory()
instance2.name = category2["name"]
instance2.code = category2["code"]
instance2.parent_category = instance1
instance2.category_type = 2
instance2.save()
for category3 in category2["sub_categorys"]:
instance3 = GoodsCategory()
instance3.name = category3["name"]
instance3.code = category3["code"]
instance3.parent_category = instance2
instance3.category_type = 3
instance3.save()
#一级类目的数据 for level1_data in row_data: level1_instance = GoodsCategory() level1_instance.name = level1_data["name"] level1_instance.code = level1_data["code"] level1_instance.category_type = 1#类别属于一级类目 #保存数据 level1_instance.save() #二级类目的数据 for level2_data in level1_data["sub_categorys"]: level2_instance = GoodsCategory() level2_instance.name = level2_data["name"] level2_instance.code = level2_data["code"] level2_instance.category_type = 2 # 类别属于二级类目 #这个不要忘记 level2_instance.parent_category = level1_instance # 保存数据 level2_instance.save() #三级类目的数据 for level3_data in level2_data["sub_categorys"]: level3_instance = GoodsCategory() level3_instance.name = level3_data["name"] level3_instance.code = level3_data["code"] level3_instance.category_type = 3 # 类别属于三级类目 # 这个不要忘记 level3_instance.parent_category = level2_instance # 保存数据 level3_instance.save()
# 这行代码必须在初始化django之后
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
# 一级分类
for lev1_cat in row_data:
lev1_intance = GoodsCategory()
lev1_intance.code = lev1_cat["code"]
lev1_intance.name = lev1_cat["name"]
lev1_intance.category_type = 1
lev1_intance.save()
# 二级分类
for lev2_cat in lev1_cat["sub_categorys"]:
lev2_intance = GoodsCategory()
lev2_intance.code = lev2_cat["code"]
lev2_intance.name = lev2_cat["name"]
lev2_intance.category_type = 2
lev2_intance.parent_category = lev1_intance
lev2_intance.save()
# 三级分类
for lev3_cat in lev2_cat["sub_categorys"]:
lev3_intance = GoodsCategory()
lev3_intance.code = lev3_cat["code"]
lev3_intance.name = lev3_cat["name"]
lev3_intance.category_type = 3
lev3_intance.parent_category = lev2_intance
lev3_intance.save()
import django
django.setup()
# 然后使用model
from goods.models import GoodsCategory
from db_tools.data.category_data import row_data
for lev1_ca in row_data:
lev1_instance = GoodsCategory()
lev1_instance.code = lev1_ca['code']
lev1_instance.name = lev1_ca['name']
lev1_instance.category_type = 1
lev1_instance.save()
for lev2_ca in lev1_ca['sub_categorys']:
lev2_instance = GoodsCategory()
lev2_instance.code = lev2_ca['code']
lev2_instance.name = lev2_ca['name']
lev2_instance.category_type = 2
lev2_instance.parent_category = lev1_instance # 二级类有父类
lev2_instance.save()
for lev3_ca in lev2_ca['sub_categorys']:
lev3_instance = GoodsCategory()
lev3_instance.code = lev3_ca['code']
lev3_instance.name = lev3_ca['name']
lev3_instance.category_type = 3
lev3_instance.parent_category = lev2_instance # 三级类有父类
lev3_instance.save()
