model

Documentation

Index

• func AddComment(comment *Comment) int
• func AddUser(data *User) int
• func ChangePassword(id int, data *User) int
• func CreateArticle(data *Article) int
• func CreateCategory(data *Category) int
• func DeleteArticle(id int) int
• func DeleteCategory(id int) int
• func DeleteComment(id int) int
• func DeleteUser(id int) int
• func EditArticle(id int, data *Article) int
• func EditCategory(id int, data *Category) int
• func EditUser(id int, data *User) int
• func GetCommentNumber(id int) int64
• func InitDb()
• func IsArticleExist(name string) (code int)
• func IsCategoryExist(name string) (code int)
• func IsUserExist(name string) (code int)
• func PassTheComment(id int, data *Comment) int
• func RemoveTheComment(id int, data *Comment) int
• func ScryptPassword(password string) string
• func UpdateProfile(id int, data *Profile) int
• func UpdateUser(id int, username string) int
• func VerifyAdminLogin(username, password string) int
• type Article
  • func GetArticleInfo(id int) (*Article, int)
  • func GetArticleList(title string, pageSize int, pageNum int) ([]Article, int, int64)
  • func GetCategoryArticleList(id int, pageSize int, pageNum int) ([]Article, int, int64)
• type Category
  • func GetCategory(id int) (Category, int)
  • func GetCategoryList(pageSize int, pageNum int) ([]Category, int64)
• type Comment
  • func ArticleGetCommentList(id int, pageSize int, pageNum int) ([]Comment, int64, int)
  • func GetComment(id int) (Comment, int)
  • func GetCommentList(pageSize int, pageNum int) ([]Comment, int64, int)
• type LogOperation
• type Profile
  • func GetProfile(id int) (Profile, int)
• type User
  • func GetUser(id int) (User, int)
  • func GetUserList(username string, pageSize int, pageNum int) ([]User, int64)
  • func VerifyFrontLogin(username, password string) (User, int)
  • func (u *User) BeforeSave(_ *gorm.DB) (err error)

Functions

func AddComment

func AddComment(comment *Comment) int

AddComment 新增评论

func AddUser

func AddUser(data *User) int

AddUser 添加用户(注册)

func ChangePassword

func ChangePassword(id int, data *User) int

ChangePassword 修改密码

func CreateArticle

func CreateArticle(data *Article) int

CreateArticle 添加文章

func CreateCategory

func CreateCategory(data *Category) int

CreateCategory 添加分类

func DeleteArticle

func DeleteArticle(id int) int

DeleteArticle 删除分类

func DeleteCategory

func DeleteCategory(id int) int

DeleteCategory 删除分类

func DeleteComment

func DeleteComment(id int) int

DeleteComment 删除评论

func DeleteUser

func DeleteUser(id int) int

DeleteUser 删除用户(soft delete)

func EditArticle

func EditArticle(id int, data *Article) int

EditArticle 编辑文章信息

func EditCategory

func EditCategory(id int, data *Category) int

EditCategory 编辑分类信息

func EditUser

func EditUser(id int, data *User) int

EditUser 编辑用户信息

func GetCommentNumber

func GetCommentNumber(id int) int64

GetCommentNumber 获取评论数量

func InitDb

func InitDb()

func IsArticleExist

func IsArticleExist(name string) (code int)

IsArticleExist 查询分类是否存在

func IsCategoryExist

func IsCategoryExist(name string) (code int)

IsCategoryExist 查询分类是否存在

func IsUserExist

func IsUserExist(name string) (code int)

IsUserExist 查询用户是否存在

func PassTheComment

func PassTheComment(id int, data *Comment) int

PassTheComment 通过评论

func RemoveTheComment

func RemoveTheComment(id int, data *Comment) int

RemoveTheComment 撤下该评论

func ScryptPassword

func ScryptPassword(password string) string

ScryptPassword 密码加密

func UpdateProfile

func UpdateProfile(id int, data *Profile) int

UpdateProfile 更新个人信息

func UpdateUser

func UpdateUser(id int, username string) int

UpdateUser 编辑用户信息时，防止不能修改用户名

func VerifyAdminLogin

func VerifyAdminLogin(username, password string) int

VerifyAdminLogin 后台登录验证

Types

type Article

type Article struct {
	gorm.Model
	Category     Category `gorm:"foreignKey:Cid"` // Cid CategoryId和分类的id对应
	Title        string   `gorm:"type:varchar(100);not null" json:"title"`
	Cid          int      `gorm:"type:int;not null" json:"cid"`
	Description  string   `gorm:"type:varchar(200)" json:"description"`
	Content      string   `gorm:"type:longtext" json:"content"`
	Img          string   `gorm:"type:varchar(100)" json:"img"`
	ReadCount    uint     `gorm:"type:int(100)" json:"read_count"`
	CommentCount int      `gorm:"type:int(100);not null;default:0" json:"comment_count"`
}

func GetArticleInfo

func GetArticleInfo(id int) (*Article, int)

GetArticleInfo 查询文章信息

func GetArticleList

func GetArticleList(title string, pageSize int, pageNum int) ([]Article, int, int64)

GetArticleList 查询文章列表

func GetCategoryArticleList

func GetCategoryArticleList(id int, pageSize int, pageNum int) ([]Article, int, int64)

GetCategoryArticleList 查询分类下所有文章

type Category

type Category struct {
	ID   uint   `gorm:"primary_key;auto_increment" json:"id"`
	Name string `gorm:"type:varchar(20);not null" json:"name"`
}

func GetCategory

func GetCategory(id int) (Category, int)

GetCategory 查询单个分类

func GetCategoryList

func GetCategoryList(pageSize int, pageNum int) ([]Category, int64)

GetCategoryList 查询分类列表

type Comment

type Comment struct {
	gorm.Model
	UserId       uint   `json:"user_id"`
	ArticleId    uint   `json:"article_id"`
	ArticleTitle string `json:"article_title"`
	UserName     string `json:"username"`
	Content      string `gorm:"varchar(500);not null" json:"content"`
	Status       int    `json:"status"`
}

func ArticleGetCommentList

func ArticleGetCommentList(id int, pageSize int, pageNum int) ([]Comment, int64, int)

ArticleGetCommentList 展示文章底下的评论

func GetComment

func GetComment(id int) (Comment, int)

GetComment 查询单个评论

func GetCommentList

func GetCommentList(pageSize int, pageNum int) ([]Comment, int64, int)

GetCommentList 获取评论列表(后台)

type LogOperation

type LogOperation struct {
	gorm.Model
	Type      uint   `gorm:"type:smallint(5); not null" json:"type"`
	Ip        string `gorm:"type:varchar(100); not null" json:"ip"`
	UserAgent string `gorm:"type:varchar(100); not null" json:"user_agent"`
	Size      uint   `gorm:"type:int(100); not null" json:"size"`
	Method    string `gorm:"type:varchar(20); not null" json:"method"`
	Code      uint   `gorm:"type:int(5); not null" json:"code"`
	HostName  string `gorm:"type:varchar(100); not null" json:"host_name"`
}

LogOperation 日志字段 请求时间 CreatedAt 状态码 Code 请求IP Ip 客户端信息 UserAgent 请求大小 Size 请求方法 Method 请求路径 Type

type Profile

type Profile struct {
	ID          int    `gorm:"primary_key;auto_increment" json:"id"`
	Name        string `gorm:"type:varchar(20)" json:"name"`
	Description string `gorm:"type:varchar(200)" json:"description"`
	Github      string `gorm:"type:varchar(200)" json:"github"`
	Email       string `gorm:"type:varchar(200)" json:"email"`
	Img         string `gorm:"type:varchar(200)" json:"img"`
	Avatar      string `gorm:"type:varchar(200)" json:"avatar"`
	Bili        string `gorm:"type:varchar(200)" json:"bili"`
	IcpRecord   string `gorm:"type:varchar(200)" json:"icp_record"`
}

func GetProfile

func GetProfile(id int) (Profile, int)

GetProfile 获取个人信息

type User

type User struct {
	// gorm.Model 提供了以下四个字段: ID, CreatedAt, UpdatedAt, DeletedAt
	gorm.Model
	Username string `gorm:"type:varchar(20);not null" json:"username" validate:"required,min=4,max=15" label:"用户名"`
	Password string `gorm:"type:varchar(20);not null" json:"password" validate:"required,min=6,max=20" label:"密码"`
	// 0无权限，1为管理员
	Role int `gorm:"type:int;default:2" json:"role" validate:"required,lte=2" label:"角色码"`
}

func GetUser

func GetUser(id int) (User, int)

GetUser 查询单个用户

func GetUserList

func GetUserList(username string, pageSize int, pageNum int) ([]User, int64)

GetUserList 查询用户列表

func VerifyFrontLogin

func VerifyFrontLogin(username, password string) (User, int)

VerifyFrontLogin 前台登录验证

func (*User) BeforeSave

func (u *User) BeforeSave(_ *gorm.DB) (err error)

BeforeSave 开始事务前，由GORM处理