mysql

Documentation

Index

• Variables
• type ModelQueryBuilder
  • func (qb *ModelQueryBuilder[T]) AddOrder(attr string, asc bool) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddOrder2(attr string, order model.OrderType) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddOrderByOpt(w *OrderOption) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddWhere(attr string, value interface{}, predicate Predicate) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddWhereAnd(value interface{}) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddWhereByOpt(w *WhereOption) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddWhereLogic(value interface{}, logicPredicate Predicate) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) AddWhereOr(value interface{}) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) BuildQuery() *map[string]interface{}
  • func (qb *ModelQueryBuilder[T]) ClearOrders() *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) ClearWheres() *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) Count(db *gorm.DB) (int64, error)
  • func (qb *ModelQueryBuilder[T]) Delete(db *gorm.DB) (err error)
  • func (qb *ModelQueryBuilder[T]) First(db *gorm.DB) (*T, error)
  • func (qb *ModelQueryBuilder[T]) Limit(limit int64) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) Offset(offset int64) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) OrderById(asc bool) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) QueryAll(db *gorm.DB) ([]T, error)
  • func (qb *ModelQueryBuilder[T]) QueryOne(db *gorm.DB) (*T, error)
  • func (qb *ModelQueryBuilder[T]) Updates(db *gorm.DB, m map[string]interface{}) (err error)
  • func (qb *ModelQueryBuilder[T]) WhereId(p Predicate, value string) *ModelQueryBuilder[T]
  • func (qb *ModelQueryBuilder[T]) WhereIdIn(value []string) *ModelQueryBuilder[T]
• type MySqlConfig
• type OrderOption
• type Predicate
• type Repo
  • func New(cfg *MySqlConfig, logger *zap.Logger) (Repo, error)
• type TracePlugin
  • func (op *TracePlugin) Initialize(db *gorm.DB) (err error)
  • func (op *TracePlugin) Name() string
• type WhereOption

Variables

var (
	EqualPredicate              = Predicate("=")
	NotEqualPredicate           = Predicate("<>")
	GreaterThanPredicate        = Predicate(">")
	GreaterThanOrEqualPredicate = Predicate(">=")
	SmallerThanPredicate        = Predicate("<")
	SmallerThanOrEqualPredicate = Predicate("<=")
	InPredicate                 = Predicate("in")
	NotInPredicate              = Predicate("not in")
	AndPredicate                = Predicate("and")
	OrPredicate                 = Predicate("or")
	LikePredicate               = Predicate("LIKE")
)

Types

type ModelQueryBuilder

type ModelQueryBuilder[T interface{}] struct {
	// contains filtered or unexported fields
}

func (*ModelQueryBuilder[T]) AddOrder

func (qb *ModelQueryBuilder[T]) AddOrder(attr string, asc bool) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddOrder2

func (qb *ModelQueryBuilder[T]) AddOrder2(attr string, order model.OrderType) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddOrderByOpt

func (qb *ModelQueryBuilder[T]) AddOrderByOpt(w *OrderOption) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddWhere

func (qb *ModelQueryBuilder[T]) AddWhere(attr string, value interface{}, predicate Predicate) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddWhereAnd

func (qb *ModelQueryBuilder[T]) AddWhereAnd(value interface{}) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddWhereByOpt

func (qb *ModelQueryBuilder[T]) AddWhereByOpt(w *WhereOption) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) AddWhereLogic

func (qb *ModelQueryBuilder[T]) AddWhereLogic(value interface{}, logicPredicate Predicate) *ModelQueryBuilder[T]

or/and logic

func (*ModelQueryBuilder[T]) AddWhereOr

func (qb *ModelQueryBuilder[T]) AddWhereOr(value interface{}) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) BuildQuery

func (qb *ModelQueryBuilder[T]) BuildQuery() *map[string]interface{}

func (*ModelQueryBuilder[T]) ClearOrders

func (qb *ModelQueryBuilder[T]) ClearOrders() *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) ClearWheres

func (qb *ModelQueryBuilder[T]) ClearWheres() *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) Count

func (qb *ModelQueryBuilder[T]) Count(db *gorm.DB) (int64, error)

func (*ModelQueryBuilder[T]) Delete

func (qb *ModelQueryBuilder[T]) Delete(db *gorm.DB) (err error)

func (*ModelQueryBuilder[T]) First

func (qb *ModelQueryBuilder[T]) First(db *gorm.DB) (*T, error)

func (*ModelQueryBuilder[T]) Limit

func (qb *ModelQueryBuilder[T]) Limit(limit int64) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) Offset

func (qb *ModelQueryBuilder[T]) Offset(offset int64) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) OrderById

func (qb *ModelQueryBuilder[T]) OrderById(asc bool) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) QueryAll

func (qb *ModelQueryBuilder[T]) QueryAll(db *gorm.DB) ([]T, error)

func (*ModelQueryBuilder[T]) QueryOne

func (qb *ModelQueryBuilder[T]) QueryOne(db *gorm.DB) (*T, error)

func (*ModelQueryBuilder[T]) Updates

func (qb *ModelQueryBuilder[T]) Updates(db *gorm.DB, m map[string]interface{}) (err error)

func (*ModelQueryBuilder[T]) WhereId

func (qb *ModelQueryBuilder[T]) WhereId(p Predicate, value string) *ModelQueryBuilder[T]

func (*ModelQueryBuilder[T]) WhereIdIn

func (qb *ModelQueryBuilder[T]) WhereIdIn(value []string) *ModelQueryBuilder[T]

type MySqlConfig

type MySqlConfig struct {
	// MySqlHost       `yaml:",inline"` // inline has no effect for inherit, seems that yaml is ok
	Addr            string        `yaml:"addr"`
	Username        string        `yaml:"username"`
	Password        string        `yaml:"password"`
	Db              string        `yaml:"db"`
	MaxOpenConn     int           `yaml:"maxOpenConn"`
	MaxIdleConn     int           `yaml:"maxIdleConn"`
	ConnMaxLifeTime time.Duration `yaml:"connMaxLifeTime"`
}

type OrderOption

type OrderOption struct {
	Attr  string
	Order model.OrderType
}

type Predicate

type Predicate string

Predicate is a string that acts as a condition in the where clause

type Repo

type Repo interface {
	GetDb() *gorm.DB
	DbClose() error
	// contains filtered or unexported methods
}

func New

func New(cfg *MySqlConfig, logger *zap.Logger) (Repo, error)

type TracePlugin

type TracePlugin struct{}

func (*TracePlugin) Initialize

func (op *TracePlugin) Initialize(db *gorm.DB) (err error)

func (*TracePlugin) Name

func (op *TracePlugin) Name() string

type WhereOption

type WhereOption struct {
	Attr      string
	Predicate Predicate
	Value     interface{}
}