gplus

package

Go to main page

Versions in this module

v0

v0.0.6

Jan 17, 2024

Changes in this version

+ func ExcSQL(querySQL string, opts ...OptionFunc) *gorm.DB

+ func SelectListBySQL[R any](querySQL string, opts ...OptionFunc) ([]*R, *gorm.DB)

+ func SelectOneBySQL[R any](countSQL string, opts ...OptionFunc) (R, *gorm.DB)

+ type SQLSegment interface

v0.0.5

Sep 15, 2023

v0.0.4

Sep 15, 2023

Changes in this version

+ type Comparable interface

type QueryCond

+ func (q *QueryCond[T]) AddAndStrCond(cond string) *QueryCond[T]

+ func (q *QueryCond[T]) AddOrStrCond(cond string) *QueryCond[T]

+ func (q *QueryCond[T]) AndEqCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndGeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndGtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndInCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndLeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndLikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndLikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndLikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndLtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndNeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndNotLikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndNotLikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) AndNotLikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrEqCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrGeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrGtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrInCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrLeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrLikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrLikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrLikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrLtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrNeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrNotLikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrNotLikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) OrNotLikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ type StreamingPage struct

+ ColumnName any

+ Forward bool

+ Limit int

+ Records []*T

+ RecordsMap []T

+ StartValue V

+ Total int64

+ func NewStreamingPage(columnName any, startValue V, limit int) *StreamingPage[T, V]

+ func SelectStreamingPage(page *StreamingPage[T, V], q *QueryCond[T], opts ...OptionFunc) (*StreamingPage[T, V], *gorm.DB)

+ func SelectStreamingPageGeneric(page *StreamingPage[R, V], q *QueryCond[T], opts ...OptionFunc) (*StreamingPage[R, V], *gorm.DB)

v0.0.3

Sep 13, 2023

Changes in this version

+ func LikeLeft(query *QueryCond[any], name string, value any)

+ func LikeRight(query *QueryCond[any], name string, value any)

+ func Tx(txFunc func(tx *gorm.DB) error, opts ...OptionFunc) error

+ type Condition struct

+ ColumnName string

+ ColumnValue any

+ Group string

+ Op string

type QueryCond

+ func BuildQuery(queryParams url.Values) *QueryCond[T]

+ func (q *QueryCond[T]) AndCond(cond bool, fn ...func(q *QueryCond[T])) *QueryCond[T]

+ func (q *QueryCond[T]) EqCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) GeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) GtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) InCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LtCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLikeCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLikeLeft(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLikeLeftCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLikeRight(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLikeRightCond(cond bool, column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Omit(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) OrCond(cond bool, fn ...func(q *QueryCond[T])) *QueryCond[T]

v0.0.2

Jun 19, 2023

Changes in this version

type QueryCond

+ func (q *QueryCond[T]) AddStrCond(cond string) *QueryCond[T]

v0.0.1

Jun 19, 2023

Changes in this version

+ func As(columnName any, asName any) string

+ func Begin(opts ...*sql.TxOptions) *gorm.DB

+ func Cache(models ...any)

+ func Delete(q *QueryCond[T], opts ...OptionFunc) *gorm.DB

+ func DeleteById(id any, opts ...OptionFunc) *gorm.DB

+ func DeleteByIds(ids any, opts ...OptionFunc) *gorm.DB

+ func ExcSql(querySql string, opts ...OptionFunc) *gorm.DB

+ func Exists(q *QueryCond[T], opts ...OptionFunc) (bool, error)

+ func GetModel() *T

+ func Init(db *gorm.DB)

+ func Insert(entity *T, opts ...OptionFunc) *gorm.DB

+ func InsertBatch(entities []*T, opts ...OptionFunc) *gorm.DB

+ func InsertBatchSize(entities []*T, batchSize int, opts ...OptionFunc) *gorm.DB

+ func Pluck(column string, q *QueryCond[T], opts ...OptionFunc) ([]R, *gorm.DB)

+ func PluckDistinct(column string, q *QueryCond[T], opts ...OptionFunc) ([]R, *gorm.DB)

+ func SelectById(id any, opts ...OptionFunc) (*T, *gorm.DB)

+ func SelectByIdGeneric(id any, opts ...OptionFunc) (*R, *gorm.DB)

+ func SelectByIds(ids any, opts ...OptionFunc) ([]*T, *gorm.DB)

+ func SelectCount(q *QueryCond[T], opts ...OptionFunc) (int64, *gorm.DB)

+ func SelectGeneric(q *QueryCond[T], opts ...OptionFunc) (R, *gorm.DB)

+ func SelectList(q *QueryCond[T], opts ...OptionFunc) ([]*T, *gorm.DB)

+ func SelectListBySql(querySql string, opts ...OptionFunc) ([]*R, *gorm.DB)

+ func SelectListGeneric(q *QueryCond[T], opts ...OptionFunc) ([]*R, *gorm.DB)

+ func SelectOne(q *QueryCond[T], opts ...OptionFunc) (*T, *gorm.DB)

+ func SelectOneBySql(countSql string, opts ...OptionFunc) (R, *gorm.DB)

+ func Update(q *QueryCond[T], opts ...OptionFunc) *gorm.DB

+ func UpdateById(entity *T, opts ...OptionFunc) *gorm.DB

+ func UpdateZeroById(entity *T, opts ...OptionFunc) *gorm.DB

+ type Dao struct

+ func (dao Dao[T]) NewQuery() (*QueryCond[T], *T)

+ type Function struct

+ func Avg(columnName any) *Function

+ func Count(columnName any) *Function

+ func Max(columnName any) *Function

+ func Min(columnName any) *Function

+ func Sum(columnName any) *Function

+ func (f *Function) As(asName any) string

+ func (f *Function) Between(start int64, end int64) (string, int64, int64)

+ func (f *Function) Eq(value int64) (string, int64)

+ func (f *Function) Ge(value int64) (string, int64)

+ func (f *Function) Gt(value int64) (string, int64)

+ func (f *Function) In(values ...any) (string, []any)

+ func (f *Function) Le(value int64) (string, int64)

+ func (f *Function) Lt(value int64) (string, int64)

+ func (f *Function) Ne(value int64) (string, int64)

+ func (f *Function) NotBetween(start int64, end int64) (string, int64, int64)

+ func (f *Function) NotIn(values ...any) (string, []any)

+ type Option struct

+ Db *gorm.DB

+ IgnoreTotal bool

+ Omits []any

+ Selects []any

+ type OptionFunc func(*Option)

+ func Db(db *gorm.DB) OptionFunc

+ func IgnoreTotal() OptionFunc

+ func Omit(columns ...any) OptionFunc

+ func Select(columns ...any) OptionFunc

+ func Session(session *gorm.Session) OptionFunc

+ type Page struct

+ CurTime int64

+ Current int

+ Records []*T

+ RecordsMap []T

+ Size int

+ Total int64

+ func NewPage(current, size int) *Page[T]

+ func SelectPage(page *Page[T], q *QueryCond[T], opts ...OptionFunc) (*Page[T], *gorm.DB)

+ func SelectPageGeneric(page *Page[R], q *QueryCond[T], opts ...OptionFunc) (*Page[R], *gorm.DB)

+ type QueryCond struct

+ func NewQuery() (*QueryCond[T], *T)

+ func NewQueryModel() (*QueryCond[T], *T, *R)

+ func (q *QueryCond[T]) And(fn ...func(q *QueryCond[T])) *QueryCond[T]

+ func (q *QueryCond[T]) Between(column any, start, end any) *QueryCond[T]

+ func (q *QueryCond[T]) Case(isTrue bool, handleFunc func()) *QueryCond[T]

+ func (q *QueryCond[T]) Distinct(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) Eq(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Ge(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Group(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) Gt(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Having(having string, args ...any) *QueryCond[T]

+ func (q *QueryCond[T]) In(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) IsNotNull(column any) *QueryCond[T]

+ func (q *QueryCond[T]) IsNull(column any) *QueryCond[T]

+ func (q *QueryCond[T]) Le(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Like(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LikeLeft(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) LikeRight(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Lt(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Ne(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotBetween(column any, start, end any) *QueryCond[T]

+ func (q *QueryCond[T]) NotIn(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) NotLike(column any, val any) *QueryCond[T]

+ func (q *QueryCond[T]) Or(fn ...func(q *QueryCond[T])) *QueryCond[T]

+ func (q *QueryCond[T]) OrderByAsc(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) OrderByDesc(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) Reset() *QueryCond[T]

+ func (q *QueryCond[T]) Select(columns ...any) *QueryCond[T]

+ func (q *QueryCond[T]) Set(column any, val any) *QueryCond[T]

+ type SqlSegment interface

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL