mysql

Documentation

Index

• func ChangeCategoryName(db *sql.DB, tableName string, category uint, name string) error
• func ChangeCategoryStatus(db *sql.DB, tableName string, category uint, status int8) error
• func CreateTable(db *sql.DB, tableName string) error
• func InsertCategory(db *sql.DB, tableName string, parentID uint, name string) (uint, error)
• type Category
  • func LisitChirldrenByParentID(db *sql.DB, tableName string, parentID uint) ([]*Category, error)

Functions

func ChangeCategoryName

func ChangeCategoryName(db *sql.DB, tableName string, category uint, name string) error

ChangeCategoryName 改变目录名称

func ChangeCategoryStatus

func ChangeCategoryStatus(db *sql.DB, tableName string, category uint, status int8) error

ChangeCategoryStatus 改变目录状态

func CreateTable

func CreateTable(db *sql.DB, tableName string) error

CreateTable -

func InsertCategory

func InsertCategory(db *sql.DB, tableName string, parentID uint, name string) (uint, error)

InsertCategory 自动设定 id 和 status状态和 创建时间 -

Types

type Category

type Category struct {
	CategoryID uint
	ParentID   uint //为0则是根目录
	Name       string
	Status     int8
	CreateTime time.Time
}

Category -

func LisitChirldrenByParentID

func LisitChirldrenByParentID(db *sql.DB, tableName string, parentID uint) ([]*Category, error)

LisitChirldrenByParentID -