Vue + Django API 前后端分离学习笔记 3.8 批量导入商品类别

谁践踏了优雅 2022-01-31 11:31 173阅读 0赞

独立使用django的model：

# encoding:utf-8
    
    # 独立使用Django的model
    
    import sys, os
    
    pwd = os.path.dirname(os.path.realpath(__file__))
    sys.path.append(pwd + "../")
    # 来源于manage.py 导入django的setting配置
    os.environ.setdefault("DJANGO_SETTINGS_MODULE", "MxShop.settings")
    
    import django
    django.setup()
    # 这里必须要在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()

嗯。。。干嘛不用pandas呢。。