1. Vue+restframe安装及通过python插入数据

最新推荐文章于 2024-02-26 18:42:17 发布

原创最新推荐文章于 2024-02-26 18:42:17 发布 · 437 阅读

0 ·

CC 4.0 BY-SA版权

Vue+Django rest framework 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何使用Vue.js和Node.js搭建前端项目，并通过RESTful API与后端交互。内容涵盖Vue.js项目的安装配置、RESTful API的实现及Django Rest Framework的使用等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Vue安装

nodejs官网下载最新的版本，旧的可能不能用，用的v10.15.0没问题

Cnpm 安装教程 http://npm.taobao.org/ npm是包管理器，但是npm下载包速度慢，cnpm快，所以更多使用cnpm

进入vue项目的目录执行ncpm install会生成node_modules的目录

然后执行cnpm run dev，这是进入url就可以看vue项目。

Rest framework安装

进入虚拟环境安装如下版本的包

pip install djangorestframework==3.6.3
pip install django==1.11.3
pip install markdown==2.6.8
pip install django-filter==1.0.4

然后创建project，配置解释器，添加一个application name的别称（创建一个users的app），enable django admin去除勾选（以后用xadmin）

添加数据库

settings中添加mysql配置

DATABASES = {
    'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME':'LvShop',
    'USER': 'root',
    'PASSWORD': 'Lvhao_610',
    'HOST': '47.98.105.40',
    'PORT': '3306',
    'OPTIONS': {'init_command': "SET sql_mode='STRICT_TRANS_TABLES';SET default_storage_engine=INNODB"},   # 添加innodb引擎，不然以后建表migration的时候会出错，因为我的mysql版本是5.7 ，视频中直接'OPTIONS': { 'init_command': 'SET storage_engine=INNODB;' }
    }
}

安装mysqlclient用pip没有成功，下载对应的whl文件进行安装pip 安装 https://www.lfd.uci.edu/~gohlke/pythonlibs/ 。

再安装 pip install pillow

最后配置

通过python插入数据

再dbtools下新建data目录，放入2个py文件，文件格式类似这种列表中字典形式

goods的model

from datetime import datetime

from django.db import models
from DjangoUeditor.models import UEditorField
# Create your models here.


class GoodsCategory(models.Model):
    """
    商品类别
    """
    CATEGORY_TYPE = (
        (1, "一级类目"),
        (2, "二级类目"),
        (3, "三级类目"),
    )

    name = models.CharField(default="", max_length=30, verbose_name="类别名", help_text="类别名")
    code = models.CharField(default="", max_length=30, verbose_name="类别code", help_text="类别code")
    desc = models.TextField(default="", verbose_name="类别描述", help_text="类别描述")
    category_type = models.IntegerField(choices=CATEGORY_TYPE, verbose_name="类目级别", help_text="类目级别")
    parent_category = models.ForeignKey("self", null=True, blank=True, verbose_name="父类目级别", help_text="父目录",
                                        related_name="sub_cat")
    is_tab = models.BooleanField(default=False, verbose_name="是否导航", help_text="是否导航")
    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:
        verbose_name = "商品类别"
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.name


class GoodsCategoryBrand(models.Model):
    """
    品牌名
    """
    category = models.ForeignKey(GoodsCategory, related_name='brands', null=True, blank=True, verbose_name="商品类目")
    name = models.CharField(default="", max_length=30, verbose_name="品牌名", help_text="品牌名")
    desc = models.TextField(default="", max_length=200, verbose_name="品牌描述", help_text="品牌描述")
    image = models.ImageField(max_length=200, upload_to="brands/")
    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:
        verbose_name = "品牌"
        verbose_name_plural = verbose_name
        db_table = "goods_goodsbrand"

    def __str__(self):
        return self.name


class Goods(models.Model):
    """
    商品
    """
    category = models.ForeignKey(GoodsCategory, verbose_name="商品类目")
    goods_sn = models.CharField(max_length=50, default="", verbose_name="商品唯一货号")
    name = models.CharField(max_length=100, verbose_name="商品名")
    click_num = models.IntegerField(default=0, verbose_name="点击数")
    sold_num = models.IntegerField(default=0, verbose_name="商品销售量")
    fav_num = models.IntegerField(default=0, verbose_name="收藏数")
    goods_num = models.IntegerField(default=0, verbose_name="库存数")
    market_price = models.FloatField(default=0, verbose_name="市场价格")
    shop_price = models.FloatField(default=0, verbose_name="本店价格")
    goods_brief = models.TextField(max_length=500, verbose_name="商品简短描述")
    goods_desc = UEditorField(verbose_name=u"内容", imagePath="goods/images/", width=1000, height=300,
                              filePath="goods/files/", default='')
    ship_free = models.BooleanField(default=True, verbose_name="是否承担运费")
    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="添加时间")

    class Meta:
        verbose_name = '商品'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.name


class IndexAd(models.Model):
    category = models.ForeignKey(GoodsCategory, related_name='category',verbose_name="商品类目")
    goods =models.ForeignKey(Goods, related_name='goods')

    class Meta:
        verbose_name = '首页商品类别广告'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.goods.name


class GoodsImage(models.Model):
    """
    商品轮播图
    """
    goods = models.ForeignKey(Goods, verbose_name="商品", related_name="images")
    image = models.ImageField(upload_to="", verbose_name="图片", null=True, blank=True)
    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:
        verbose_name = '商品图片'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.goods.name


class Banner(models.Model):
    """
    轮播的商品
    """
    goods = models.ForeignKey(Goods, verbose_name="商品")
    image = models.ImageField(upload_to='banner', verbose_name="轮播图片")
    index = models.IntegerField(default=0, verbose_name="轮播顺序")
    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:
        verbose_name = '轮播商品'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.goods.name


class HotSearchWords(models.Model):
    """
    热搜词
    """
    keywords = models.CharField(default="", max_length=20, verbose_name="热搜词")
    index = models.IntegerField(default=0, verbose_name="排序")
    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:
        verbose_name = '热搜词'
        verbose_name_plural = verbose_name

    def __str__(self):
        return self.keywords

import_category.py文件，然后运行这个文件，数据库中就有数据了

import sys
import os


pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd+"../")   # 根目录
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "LvShop.settings")   # 这句话复制manage.py中

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

再后台管理系统中也就有了

接下来，倒入goods的商品数据，同理运行写好的import_goods_data.py文件，

在settings中配置

MEDIA_URL = "/media/"
MEDIA_ROOT  = os.path.join(BASE_DIR,"media")

LvShop/LvShop/urls.py 文件中加入

from LvShop.settings import MEDIA_ROOT
from django.views.static import serve

urlpatterns = [
    #url(r'^admin/', admin.site.urls),
    url(r'^xadmin/', xadmin.site.urls),
    url(r'^media/(?P<path>.*)$', serve, {'document_root': MEDIA_ROOT}),
]

这样在xadmin后台的商品选项中就能显示图片了