construct

Documentation

Index

• func GuessStructTags(ci *schema.ColumnInfo) string
• func GuessTypeName(ci *schema.ColumnInfo) string
• func IgnoreNotFoundError(err error) error
• func MoveEdge(query *gorm.DB, base uint, offset string) (err error)
• func Paginate(query *gorm.DB, out interface{}, pageno, pagesize int) (total int, err error)
• type FilterFunc
• type ITableComment
• type ITableName
• type Model
  • func (Model) TableComment() string
• type NestedNode
  • func (n *NestedNode) AddToParent(parent *NestedNode, tbQuery *gorm.DB) error
  • func (n NestedNode) AncestorsFilter(Backward bool) FilterFunc
  • func (n NestedNode) ChildrenFilter(rank uint8) FilterFunc
  • func (n NestedNode) CountChildren() int
  • func (n NestedNode) IsLeaf() bool
• type SqlTag
  • func NewSqlTag() *SqlTag
  • func (st *SqlTag) Delete(key string)
  • func (st *SqlTag) Get(key string) (string, bool)
  • func (st *SqlTag) ParseTag(tag reflect.StructTag)
  • func (st *SqlTag) Set(key, val string)
  • func (st *SqlTag) String(head string) string

Functions

func GuessStructTags

func GuessStructTags(ci *schema.ColumnInfo) string

根据数据库字段属性设置Struct tags

func GuessTypeName

func GuessTypeName(ci *schema.ColumnInfo) string

根据数据库字段类型猜测Go类型，适用于mysql或pgsql

func IgnoreNotFoundError

func IgnoreNotFoundError(err error) error

忽略表中无数据的错误

func MoveEdge

func MoveEdge(query *gorm.DB, base uint, offset string) (err error)

左右边界整体移动

func Paginate

func Paginate(query *gorm.DB, out interface{}, pageno, pagesize int) (total int, err error)

*

• 翻页查询，out参数需要传引用
• 使用方法 total, err := Paginate(query, &rows, pageno, pagesize)

Types

type FilterFunc

type FilterFunc = func(query *gorm.DB) *gorm.DB

*

• 过滤查询
• 使用方法 query = query.Scopes(filters ...FilterFunc)

type ITableComment

type ITableComment interface {
	TableComment() string
}

*

• 数据表注释

type ITableName

type ITableName interface {
	TableName() string
}

*

• 数据表名

type Model

type Model struct {
	ID uint `json:"id" toml:"-" gorm:"primary_key;not null;auto_increment"`
}

*

• 带自增主键的基础Model

func (Model) TableComment

func (Model) TableComment() string

type NestedNode

type NestedNode struct {
	Lft   uint  `json:"-" gorm:"not null;default:0;comment:'左边界'"`          // 左边界
	Rgt   uint  `json:"-" gorm:"not null;index;default:0;comment:'右边界'"`    // 右边界
	Depth uint8 `json:"depth" gorm:"not null;index;default:1;comment:'高度'"` // 高度
}

嵌套集合树

func (*NestedNode) AddToParent

func (n *NestedNode) AddToParent(parent *NestedNode, tbQuery *gorm.DB) error

添加到父节点最末，tbQuery一定要使用db.Table(...)

func (NestedNode) AncestorsFilter

func (n NestedNode) AncestorsFilter(Backward bool) FilterFunc

找出所有直系祖先节点

func (NestedNode) ChildrenFilter

func (n NestedNode) ChildrenFilter(rank uint8) FilterFunc

找出所有子孙节点

func (NestedNode) CountChildren

func (n NestedNode) CountChildren() int

有多少个子孙节点

func (NestedNode) IsLeaf

func (n NestedNode) IsLeaf() bool

是否叶子节点

type SqlTag

type SqlTag struct {
	reflect.StructTag
	// contains filtered or unexported fields
}

StructTag named sql or gorm

func NewSqlTag

func NewSqlTag() *SqlTag

func (*SqlTag) Delete

func (st *SqlTag) Delete(key string)

Deletes a tag

func (*SqlTag) Get

func (st *SqlTag) Get(key string) (string, bool)

Returns a tag from the tag data

func (*SqlTag) ParseTag

func (st *SqlTag) ParseTag(tag reflect.StructTag)

func (*SqlTag) Set

func (st *SqlTag) Set(key, val string)

Sets a tag in the tag data map

func (*SqlTag) String

func (st *SqlTag) String(head string) string

转为字符串格式，头通常使用sql或gorm