repos

Documentation

Index

• Constants
• type Delete
• type IBasicRepository
• type IRepository
• type ITxRepository
• type Query
• type TxKey
• type Update
• type Where
  • func Between(column string, v1, v2 interface{}) *Where
  • func Eq(column string, value interface{}) *Where
  • func Gt(column string, value interface{}) *Where
  • func Gte(column string, value interface{}) *Where
  • func In(column string, value interface{}) *Where
  • func IsNotNull(column string) *Where
  • func IsNull(column string) *Where
  • func Like(column string, value interface{}) *Where
  • func Lt(column string, value interface{}) *Where
  • func Lte(column string, value interface{}) *Where
  • func Ne(column string, value interface{}) *Where
  • func NotIn(column string, value interface{}) *Where
  • func (w *Where) Build() (string, []interface{})
• type Wheres
  • func NewWheres() Wheres
  • func (w Wheres) And(wheres ...*Where) Wheres
  • func (w Wheres) Or(wheres ...*Where) Wheres

Constants

const (
	IN        = "IN"
	NotIN     = "NOT IN"
	BETWEEN   = "BETWEEN"
	LIKE      = "LIKE"
	IsNULL    = "IS NULL"
	IsNotNULL = "IS NOT NULL"
)

Types

type Delete

type Delete struct {
	Model  interface{}
	Wheres Wheres
}

type IBasicRepository

type IBasicRepository interface {
	IRepository
	ITxRepository
}

IBasicRepository 基础查询与事务

type IRepository

type IRepository interface {
	Get(*Query) error
	Find(*Query) error
	Create(interface{}) error
	CreateInTx(context.Context, interface{}) error
	Update(*Update) error
	UpdateInTx(context.Context, *Update) error
	UpdateColumn(*Update) error
	UpdateColumnInTx(context.Context, *Update) error
	Delete(*Delete) error
	DeleteInTx(context.Context, *Delete) error
}

IRepository 基础查询

type ITxRepository

type ITxRepository interface {
	Tx(context.Context, func(context.Context) error) error
	GetTx(context.Context) (interface{}, error)
}

ITxRepository 事务

type Query

type Query struct {
	Model          interface{} // 查询的模型
	Wheres         Wheres      // 查询条件
	Recipient      interface{} // 查询结果保存的对象
	OrderBy        string      // 排序条件
	IgnoreNotFound bool        // 是否过滤未找到数据的错误
	Num, Size      int         // 分页页码, 单页大小
	Total          *int64      // 总数
}

type TxKey

type TxKey struct{}

type Update

type Update struct {
	Model   interface{}            // 修改对应的模型
	Wheres  Wheres                 // 修改的过滤条件
	Update  interface{}            // 修改的结构体值, 修改整体值时使用
	Fields  map[string]interface{} // 修改的map值, 用于修改单个或多个字段时使用
	SaveNil bool                   // 是否保存空值, 默认不会更新类似 0,false,"" 等值
	Omits   []string               // 修改时指定不更新的字段
}

type Where

type Where struct {
	Column    string
	Condition string
	V1        interface{}
	V2        interface{}
	Or        bool
}

func Between

func Between(column string, v1, v2 interface{}) *Where

func Eq

func Eq(column string, value interface{}) *Where

func Gt

func Gt(column string, value interface{}) *Where

func Gte

func Gte(column string, value interface{}) *Where

func In

func In(column string, value interface{}) *Where

func IsNotNull

func IsNotNull(column string) *Where

func IsNull

func IsNull(column string) *Where

func Like

func Like(column string, value interface{}) *Where

func Lt

func Lt(column string, value interface{}) *Where

func Lte

func Lte(column string, value interface{}) *Where

func Ne

func Ne(column string, value interface{}) *Where

func NotIn

func NotIn(column string, value interface{}) *Where

func (*Where) Build

func (w *Where) Build() (string, []interface{})

type Wheres

type Wheres []*Where

func NewWheres

func NewWheres() Wheres

func (Wheres) And

func (w Wheres) And(wheres ...*Where) Wheres

func (Wheres) Or

func (w Wheres) Or(wheres ...*Where) Wheres