1.model定义 - 图1

1. 表定义和生成

  1. package model
  3. import (
  4.     "database/sql"
  5.     "time"
  7.     "gorm.io/gorm"
  8. )
  10. type BaseModel struct {
  11.     ID        int32        `gorm:"primarykey"`
  12.     CreateAt  time.Time    `gorm:"column:add_time"`
  13.     UpdateAt  sql.NullTime `gorm:"column:update_time"`
  14.     DeletedAt gorm.DeletedAt
  15.     IsDeleted bool
  16. }
  18. // Category 分类表
  19. type Category struct {
  20.     BaseModel
  21.     Name             string      `gorm:"type:varchar(20);not null;comment:分类名称"`
  22.     ParentCategoryID int32       `gorm:"type:int(11);default:null;comment:父id 0顶级分类"`
  23.     SubCategory      []*Category `gorm:"foreignkey:ParentCategoryID;references:ID"`
  24.     Level            int32       `gorm:"type:int(11);not null;default:1;comment:顶级分类"`
  25.     IsTab            bool        `gorm:"default:false;not null;comment:是否是选项卡"`
  26. }
  28. type Brands struct {
  29.     BaseModel
  30.     Name string `gorm:"type:varchar(50);not null;comment:品牌名称"`
  31.     Logo string `gorm:"type:varchar(255);not null;comment:品牌logo"`
  32. }
  34. type GoodsCategoryBrand struct {
  35.     BaseModel
  36.     CategoryID int32    `gorm:"type:int(11);not null;comment:商品分类id"`
  37.     Category   Category `gorm:"foreignKey:CategoryID;references:ID"`
  39.     BrandsID int32  `gorm:"type:int(11);not null;comment:品牌id"`
  40.     Brand    Brands `gorm:"foreignKey:BrandsID;references:ID"`
  41. }
  43. func (GoodsCategoryBrand) TableName() string {
  44.     return "goodscategorybrand"
  45. }
  47. // Banner 轮播图表
  48. type Banner struct {
  49.     BaseModel
  50.     Image string `gorm:"type:varchar(255);not null;comment:图片地址"`
  51.     Url   string `gorm:"type:varchar(255);not null;comment:跳转地址"`
  52.     Index int32  `gorm:"type:int(11);not null;comment:轮播顺序"`
  53. }
  55. type Goods struct {
  56.     BaseModel
  57.     CategoryID      int32    `gorm:"type:int;not null;comment:商品分类id"`
  58.     Category        Category `gorm:"foreignKey:CategoryID;references:ID"`
  59.     BrandsID        int32    `gorm:"type:int;not null;comment:品牌id"`
  60.     Brands          Brands   `gorm:"foreignKey:BrandsID;references:ID"`
  61.     OnSale          bool     `gorm:"default:false;not null;comment:是否上架"`
  62.     ShipFree        bool     `gorm:"default:false;not null;comment:是否免运费"`
  63.     IsNew           bool     `gorm:"default:false;not null;comment:是否是新品"`
  64.     IsHot           bool     `gorm:"default:false;not null;comment:是否是热卖"`
  65.     Name            string   `gorm:"type:varchar(100);not null;comment:商品名称"`
  66.     GoodsSn         string   `gorm:"type:varchar(50);not null;comment:商品货号"`
  67.     ClickNum        int32    `gorm:"type:int;default:0;not null;comment:点击数"`
  68.     SoldNum         int32    `gorm:"type:int;default:0;not null;comment:销售数"`
  69.     FavNum          int32    `gorm:"type:int;default:0;not null;comment:收藏数"`
  70.     MarketPrice     float32  `gorm:"not null;comment:市场价"`
  71.     ShopPrice       float32  `gorm:"not null;comment:本店价"`
  72.     GoodsBrief      string   `gorm:"type:varchar(100);not null;comment:商品简介"`
  73.     Images          GormList `gorm:"type:varchar(1000);not null;comment:商品图片"`
  74.     DescImages      GormList `gorm:"type:varchar(4000);not null;comment:商品详情图片"` // 修改长度
  75.     GoodsFrontImage string   `gorm:"type:varchar(200);not null;comment:商品封面图"`
  76. }

2. 导入数据

mxshop_goods_srv.sql