assist

package module

Go to main page

Versions in this module

v0

v0.6.0-rc1

Aug 18, 2023

v0.6.0-rc0

Aug 17, 2023

v0.5.5

Aug 14, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) FieldName(prefixes ...string) string

type Field

+ func (e Field) FieldName(prefixes ...string) string

v0.5.4

Aug 3, 2023

v0.5.3

Aug 3, 2023

v0.5.2

Aug 3, 2023

v0.5.1

Jul 28, 2023

Changes in this version

type Conditions

+ func (c *Conditions) Configure(funcs ...func(*Conditions) *Conditions) *Conditions

type Executor

+ func (x *Executor[T]) IntoRawDB() *gorm.DB

v0.5.0

Jul 25, 2023

v0.4.1

Jul 24, 2023

Changes in this version

type Bool

+ func (field Bool) ValuePointer(value *bool) SetExpr

type Float

+ func (field Float[T]) ValuePointer(value *T) SetExpr

type Integer

+ func (field Integer[T]) ValuePointer(value *T) SetExpr

type String

+ func (field String) ValuePointer(value *string) SetExpr

type Time

+ func (field Time) ValuePointer(value *time.Time) SetExpr

v0.4.0

Jul 24, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) SetCol(e2 Expr) SetExpr

type Field

+ func (e Field) SetCol(e2 Expr) SetExpr

v0.3.4

Jul 20, 2023

v0.3.3

Jul 19, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) ValueAny(value any) SetExpr

+ func (e Asterisk) ValueNull() SetExpr

type Field

+ func (e Field) ValueAny(value any) SetExpr

+ func (e Field) ValueNull() SetExpr

v0.3.2

Jul 19, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) SetExpr() any

+ func (e Asterisk) SetSubQuery(subQuery *gorm.DB) SetExpr

type Bool

+ func (field Bool) Value(value bool) SetExpr

+ func (field Bool) ValueZero() SetExpr

type Bytes

+ func (field Bytes) Value(value []byte) SetExpr

+ func (field Bytes) ValueZero() SetExpr

type Columns

+ func (cs Columns) Set(subQuery *gorm.DB) SetExpr

type Condition

+ func OmitExpr(columns ...Expr) Condition

type Conditions

+ func (c *Conditions) OmitExpr(columns ...Expr) *Conditions

type Executor

+ func (x *Executor[T]) AssignExpr(attrs ...SetExpr) *Executor[T]

+ func (x *Executor[T]) AttrsExpr(attrs ...SetExpr) *Executor[T]

+ func (x *Executor[T]) OmitExpr(columns ...Expr) *Executor[T]

+ func (x *Executor[T]) UpdateColumnExpr(column Expr, value any) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdateColumnsExpr(columns ...SetExpr) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdateExpr(column Expr, value any) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdatesExpr(columns ...SetExpr) (rowsAffected int64, err error)

type Field

+ func (e Field) SetExpr() any

+ func (e Field) SetSubQuery(subQuery *gorm.DB) SetExpr

+ func (field Field) Value(value any) SetExpr

type Float

+ func (field Float[T]) Value(value T) SetExpr

+ func (field Float[T]) ValueZero() SetExpr

type Integer

+ func (field Integer[T]) Value(value T) SetExpr

+ func (field Integer[T]) ValueZero() SetExpr

+ type SetExpr interface

+ SetExpr func() any

type String

+ func (field String) Value(value string) SetExpr

+ func (field String) ValueZero() SetExpr

type Time

+ func (field Time) Value(value time.Time) SetExpr

+ func (field Time) ValueZero() SetExpr

v0.3.2-rc3

Jul 19, 2023

v0.3.2-rc2

Jul 19, 2023

v0.3.2-rc1

Jul 19, 2023

v0.3.1

Jul 18, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) FindInSetCol(e2 Expr) Expr

+ func (e Asterisk) FindInSetColWith(e2 Expr) Expr

type Field

+ func (e Field) FindInSetCol(e2 Expr) Expr

+ func (e Field) FindInSetColWith(e2 Expr) Expr

v0.3.0

Jul 18, 2023

Changes in this version

type Asterisk

+ func (e Asterisk) EqSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) FindInSetSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) GtSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) GteSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) InSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) LtSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) LteSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) NeqSubQuery(subQuery *gorm.DB) Expr

+ func (e Asterisk) NotInSubQuery(subQuery *gorm.DB) Expr

type Executor

+ func (x *Executor[T]) IntoExistExpr() Expr

+ func (x *Executor[T]) IntoNotExistExpr() Expr

+ func (x *Executor[T]) IntoSubQueryExpr() Field

+ func (x *Executor[T]) PluckExpr(column Expr, value any) error

+ func (x *Executor[T]) PluckExprBool(column Expr) (slice []bool, err error)

+ func (x *Executor[T]) PluckExprInt(column Expr) (slice []int, err error)

+ func (x *Executor[T]) PluckExprInt16(column Expr) (slice []int16, err error)

+ func (x *Executor[T]) PluckExprInt32(column Expr) (slice []int32, err error)

+ func (x *Executor[T]) PluckExprInt64(column Expr) (slice []int64, err error)

+ func (x *Executor[T]) PluckExprInt8(column Expr) (slice []int8, err error)

+ func (x *Executor[T]) PluckExprString(column Expr) (slice []string, err error)

+ func (x *Executor[T]) PluckExprUint(column Expr) (slice []uint, err error)

+ func (x *Executor[T]) PluckExprUint16(column Expr) (slice []uint16, err error)

+ func (x *Executor[T]) PluckExprUint32(column Expr) (slice []uint32, err error)

+ func (x *Executor[T]) PluckExprUint64(column Expr) (slice []uint64, err error)

+ func (x *Executor[T]) PluckExprUint8(column Expr) (slice []uint8, err error)

type Field

+ func SubQuery(db *gorm.DB) Field

+ func (e Field) EqSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) FindInSetSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) GtSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) GteSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) InSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) LtSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) LteSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) NeqSubQuery(subQuery *gorm.DB) Expr

+ func (e Field) NotInSubQuery(subQuery *gorm.DB) Expr

v0.2.2

Jul 6, 2023

Changes in this version

type String

+ func (field String) Hidden(left, right int, pad string) String

+ func (field String) HiddenPrefix(right int, pad string) String

+ func (field String) HiddenSuffix(left int, pad string) String

v0.2.1

Jun 27, 2023

Changes in this version

type Condition

+ func TableExpr(fromSubs ...From) Condition

type Conditions

+ func (c *Conditions) Assign(attrs ...any) *Conditions

+ func (c *Conditions) Attrs(attrs ...any) *Conditions

+ func (c *Conditions) Clauses(conds ...clause.Expression) *Conditions

+ func (c *Conditions) Joins(query string, args ...any) *Conditions

+ func (c *Conditions) Limit(limit int) *Conditions

+ func (c *Conditions) Not(query any, args ...any) *Conditions

+ func (c *Conditions) Offset(offset int) *Conditions

+ func (c *Conditions) Omit(columns ...string) *Conditions

+ func (c *Conditions) Or(query any, args ...any) *Conditions

+ func (c *Conditions) Preload(query string, args ...any) *Conditions

+ func (c *Conditions) Scopes(cs ...Condition) *Conditions

+ func (c *Conditions) Unscoped() *Conditions

v0.2.0

Jun 26, 2023

Changes in this version

type Condition

+ func CrossJoinsExpr(tableName string, conds ...Expr) Condition

+ func CrossJoinsXExpr(tableName, alias string, conds ...Expr) Condition

+ func DistinctExpr(columns ...Expr) Condition

+ func GroupExpr(columns ...Expr) Condition

+ func InnerJoinsExpr(tableName string, conds ...Expr) Condition

+ func InnerJoinsXExpr(tableName, alias string, conds ...Expr) Condition

+ func LeftJoinsExpr(tableName string, conds ...Expr) Condition

+ func LeftJoinsXExpr(tableName, alias string, conds ...Expr) Condition

+ func OrderExpr(columns ...Expr) Condition

+ func RightJoinsExpr(tableName string, conds ...Expr) Condition

+ func RightJoinsXExpr(tableName, alias string, conds ...Expr) Condition

+ func SelectExpr(columns ...Expr) Condition

type Conditions

+ func (c *Conditions) CrossJoinsExpr(tableName string, conds ...Expr) *Conditions

+ func (c *Conditions) CrossJoinsXExpr(tableName, alias string, conds ...Expr) *Conditions

+ func (c *Conditions) DistinctExpr(columns ...Expr) *Conditions

+ func (c *Conditions) GroupExpr(columns ...Expr) *Conditions

+ func (c *Conditions) InnerJoinsExpr(tableName string, conds ...Expr) *Conditions

+ func (c *Conditions) InnerJoinsXExpr(tableName, alias string, conds ...Expr) *Conditions

+ func (c *Conditions) LeftJoinsExpr(tableName string, conds ...Expr) *Conditions

+ func (c *Conditions) LeftJoinsXExpr(tableName, alias string, conds ...Expr) *Conditions

+ func (c *Conditions) OrderExpr(columns ...Expr) *Conditions

+ func (c *Conditions) RightJoinsExpr(tableName string, conds ...Expr) *Conditions

+ func (c *Conditions) RightJoinsXExpr(tableName, alias string, conds ...Expr) *Conditions

+ func (c *Conditions) SelectExpr(columns ...Expr) *Conditions

v0.1.8

Jun 21, 2023

Changes in this version

type Float

+ func (e Float[T]) AddCol(col Expr) Float[T]

+ func (e Float[T]) DivCol(col Expr) Float[T]

+ func (e Float[T]) MulCol(col Expr) Float[T]

+ func (e Float[T]) SubCol(col Expr) Float[T]

type Integer

+ func (e Integer[T]) AddCol(col Expr) Integer[T]

+ func (e Integer[T]) DivCol(col Expr) Integer[T]

+ func (e Integer[T]) MulCol(col Expr) Integer[T]

+ func (e Integer[T]) SubCol(col Expr) Integer[T]

type String

+ func (e String) AddCol(col Expr) String

+ func (e String) ConcatCol(cols ...Expr) String

+ func (e String) DivCol(col Expr) String

+ func (e String) MulCol(col Expr) String

+ func (e String) SubCol(col Expr) String

type Time

+ func (e Time) AddCol(col Expr) Time

+ func (e Time) DivCol(col Expr) Time

+ func (e Time) MulCol(col Expr) Time

+ func (e Time) SubCol(col Expr) Time

v0.1.7

Jun 10, 2023

Changes in this version

type Bool

+ func (field Bool) FindInSet(targetList string) Expr

type Columns

+ func (cs Columns) FindInSet(subQuery *gorm.DB) Expr

type Condition

+ func GormAssign(attrs ...any) Condition

+ func GormAttrs(attrs ...any) Condition

+ func GormClauses(conds ...clause.Expression) Condition

+ func GormDistinct(args ...any) Condition

+ func GormGroup(name string) Condition

+ func GormHaving(query any, args ...any) Condition

+ func GormInnerJoins(query string, args ...any) Condition

+ func GormJoins(query string, args ...any) Condition

+ func GormLimit(limit int) Condition

+ func GormNot(query any, args ...any) Condition

+ func GormOffset(offset int) Condition

+ func GormOmit(columns ...string) Condition

+ func GormOr(query any, args ...any) Condition

+ func GormOrder(value any) Condition

+ func GormPreload(query string, args ...any) Condition

+ func GormSelect(query any, args ...any) Condition

+ func GormTable(name string, args ...any) Condition

+ func GormUnscoped() Condition

+ func GormWhere(query any, args ...any) Condition

type Float

+ func (field Float[T]) FindInSet(targetList string) Expr

type Integer

+ func (field Integer[T]) FindInSet(targetList string) Expr

type Time

+ func (field Time) FindInSet(targetList string) Expr

v0.1.6

Jun 5, 2023

Changes in this version

type Bytes

+ func (field Bytes) InAny(value any) Expr

+ func (field Bytes) NotInAny(value any) Expr

type Float

+ func (field Float[T]) InAny(value any) Expr

+ func (field Float[T]) NotInAny(value any) Expr

type Integer

+ func (field Integer[T]) InAny(value any) Expr

+ func (field Integer[T]) NotInAny(value any) Expr

type String

+ func (field String) InAny(value any) Expr

+ func (field String) NotInAny(value any) Expr

type Time

+ func (field Time) InAny(value any) Expr

+ func (field Time) NotInAny(value any) Expr

v0.1.5

Jun 2, 2023

Changes in this version

type Condition

+ func Distinct(columns ...Expr) Condition

type Conditions

+ func (c Conditions) Distinct(columns ...Expr) Conditions

type Executor

+ func (x *Executor[T]) DistinctExpr(columns ...Expr) *Executor[T]

+ func (x *Executor[T]) FirstFloat32() (v float32, err error)

+ func (x *Executor[T]) FirstInt16() (v int16, err error)

+ func (x *Executor[T]) FirstInt32() (v int32, err error)

+ func (x *Executor[T]) FirstInt8() (v int8, err error)

+ func (x *Executor[T]) FirstUint() (v uint, err error)

+ func (x *Executor[T]) FirstUint16() (v uint16, err error)

+ func (x *Executor[T]) FirstUint32() (v uint32, err error)

+ func (x *Executor[T]) FirstUint64() (v uint64, err error)

+ func (x *Executor[T]) FirstUint8() (v uint8, err error)

+ func (x *Executor[T]) PluckInt16(column string) (slice []int16, err error)

+ func (x *Executor[T]) PluckInt32(column string) (slice []int32, err error)

+ func (x *Executor[T]) PluckInt8(column string) (slice []int8, err error)

+ func (x *Executor[T]) PluckUint(column string) (slice []uint, err error)

+ func (x *Executor[T]) PluckUint16(column string) (slice []uint16, err error)

+ func (x *Executor[T]) PluckUint32(column string) (slice []uint32, err error)

+ func (x *Executor[T]) PluckUint64(column string) (slice []uint64, err error)

+ func (x *Executor[T]) PluckUint8(column string) (slice []uint8, err error)

+ func (x *Executor[T]) ScanFloat32() (v float32, err error)

+ func (x *Executor[T]) ScanInt16() (v int16, err error)

+ func (x *Executor[T]) ScanInt32() (v int32, err error)

+ func (x *Executor[T]) ScanInt8() (v int8, err error)

+ func (x *Executor[T]) ScanUint() (v uint, err error)

+ func (x *Executor[T]) ScanUint16() (v uint16, err error)

+ func (x *Executor[T]) ScanUint32() (v uint32, err error)

+ func (x *Executor[T]) ScanUint64() (v uint64, err error)

+ func (x *Executor[T]) ScanUint8() (v uint8, err error)

+ func (x *Executor[T]) TakeFloat32() (v float32, err error)

+ func (x *Executor[T]) TakeInt16() (v int16, err error)

+ func (x *Executor[T]) TakeInt32() (v int32, err error)

+ func (x *Executor[T]) TakeInt8() (v int8, err error)

+ func (x *Executor[T]) TakeUint() (v uint, err error)

+ func (x *Executor[T]) TakeUint16() (v uint16, err error)

+ func (x *Executor[T]) TakeUint32() (v uint32, err error)

+ func (x *Executor[T]) TakeUint64() (v uint64, err error)

+ func (x *Executor[T]) TakeUint8() (v uint8, err error)

v0.1.4

Jun 1, 2023

v0.1.3

Jun 1, 2023

Changes in this version

type Executor

+ func (x *Executor[T]) IntoDB() (db *gorm.DB)

+ func (x *Executor[T]) UpdateColumnsMap(value map[string]any) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdatesMap(value map[string]any) (rowsAffected int64, err error)

v0.1.2

May 29, 2023

Changes in this version

type Executor

+ func (x *Executor[T]) FirstBool() (v bool, err error)

+ func (x *Executor[T]) FirstFloat64() (v Float64, err error)

+ func (x *Executor[T]) FirstInt() (v int, err error)

+ func (x *Executor[T]) FirstInt64() (v int64, err error)

+ func (x *Executor[T]) FirstString() (v string, err error)

+ func (x *Executor[T]) PluckBool(column string) (slice []bool, err error)

+ func (x *Executor[T]) PluckInt(column string) (slice []int, err error)

+ func (x *Executor[T]) PluckInt64(column string) (slice []int64, err error)

+ func (x *Executor[T]) PluckString(column string) (slice []string, err error)

+ func (x *Executor[T]) ScanBool() (v bool, err error)

+ func (x *Executor[T]) ScanFloat64() (v Float64, err error)

+ func (x *Executor[T]) ScanInt() (v int, err error)

+ func (x *Executor[T]) ScanInt64() (v int64, err error)

+ func (x *Executor[T]) ScanString() (v string, err error)

+ func (x *Executor[T]) TakeBool() (v bool, err error)

+ func (x *Executor[T]) TakeFloat64() (v Float64, err error)

+ func (x *Executor[T]) TakeInt() (v int, err error)

+ func (x *Executor[T]) TakeInt64() (v int64, err error)

+ func (x *Executor[T]) TakeString() (v string, err error)

v0.1.1

May 26, 2023

Changes in this version

type Executor

+ func (x *Executor[T]) Assign(attrs ...any) *Executor[T]

+ func (x *Executor[T]) Attrs(attrs ...any) *Executor[T]

+ func (x *Executor[T]) FindInBatches(dest any, batchSize int, fc func(tx *gorm.DB, batch int) error) error

+ func (x *Executor[T]) FirstOrCreate(dest any) error

+ func (x *Executor[T]) FirstOrInit(dest any) error

+ func (x *Executor[T]) Preload(query string, args ...any) *Executor[T]

+ func (x *Executor[T]) Unscoped() *Executor[T]

v0.1.0

May 25, 2023

Changes in this version

+ type Executor struct

+ func NewExecutor(db *gorm.DB) *Executor[T]

+ func (x *Executor[T]) Clauses(conds ...clause.Expression) *Executor[T]

+ func (x *Executor[T]) Count() (count int64, err error)

+ func (x *Executor[T]) Create(value any) error

+ func (x *Executor[T]) CreateInBatches(value any, batchSize int) error

+ func (x *Executor[T]) CrossJoinsExpr(tableName string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) CrossJoinsXExpr(tableName, alias string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) Debug() *Executor[T]

+ func (x *Executor[T]) Delete() (rowsAffected int64, err error)

+ func (x *Executor[T]) Distinct(args ...any) *Executor[T]

+ func (x *Executor[T]) Exist() (exist bool, err error)

+ func (x *Executor[T]) Find(dest any) error

+ func (x *Executor[T]) FindAll() ([]*T, error)

+ func (x *Executor[T]) First(dest any) error

+ func (x *Executor[T]) FirstOne() (*T, error)

+ func (x *Executor[T]) Group(name string) *Executor[T]

+ func (x *Executor[T]) GroupExpr(columns ...Expr) *Executor[T]

+ func (x *Executor[T]) Having(query any, args ...any) *Executor[T]

+ func (x *Executor[T]) InnerJoins(query string, args ...any) *Executor[T]

+ func (x *Executor[T]) InnerJoinsExpr(tableName string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) InnerJoinsXExpr(tableName, alias string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) Joins(query string, args ...any) *Executor[T]

+ func (x *Executor[T]) Last(dest any) error

+ func (x *Executor[T]) LastOne() (*T, error)

+ func (x *Executor[T]) LeftJoinsExpr(tableName string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) LeftJoinsXExpr(tableName, alias string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) Limit(limit int) *Executor[T]

+ func (x *Executor[T]) LockingShare() *Executor[T]

+ func (x *Executor[T]) LockingUpdate() *Executor[T]

+ func (x *Executor[T]) Not(query any, args ...any) *Executor[T]

+ func (x *Executor[T]) Offset(offset int) *Executor[T]

+ func (x *Executor[T]) Omit(columns ...string) *Executor[T]

+ func (x *Executor[T]) Or(query any, args ...any) *Executor[T]

+ func (x *Executor[T]) Order(value any) *Executor[T]

+ func (x *Executor[T]) OrderExpr(columns ...Expr) *Executor[T]

+ func (x *Executor[T]) Pagination(page, perPage int64, maxPerPages ...int64) *Executor[T]

+ func (x *Executor[T]) Pluck(column string, value any) error

+ func (x *Executor[T]) RightJoinsExpr(tableName string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) RightJoinsXExpr(tableName, alias string, conds ...Expr) *Executor[T]

+ func (x *Executor[T]) Save(value any) error

+ func (x *Executor[T]) Scan(dest any) error

+ func (x *Executor[T]) ScanOne() (*T, error)

+ func (x *Executor[T]) Scopes(funcs ...func(*gorm.DB) *gorm.DB) *Executor[T]

+ func (x *Executor[T]) Select(query any, args ...any) *Executor[T]

+ func (x *Executor[T]) SelectExpr(columns ...Expr) *Executor[T]

+ func (x *Executor[T]) Session(config *gorm.Session) *Executor[T]

+ func (x *Executor[T]) Table(name string, args ...any) *Executor[T]

+ func (x *Executor[T]) TableExpr(fromSubs ...From) *Executor[T]

+ func (x *Executor[T]) Take(dest any) error

+ func (x *Executor[T]) TakeOne() (*T, error)

+ func (x *Executor[T]) Update(column string, value any) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdateColumn(column string, value any) (rowsAffected int64, err error)

+ func (x *Executor[T]) UpdateColumns(value *T) (rowsAffected int64, err error)

+ func (x *Executor[T]) Updates(value *T) (rowsAffected int64, err error)

+ func (x *Executor[T]) Where(query any, args ...any) *Executor[T]

+ func (x *Executor[T]) WithContext(ctx context.Context) *Executor[T]

v0.0.8

May 25, 2023

Changes in this version

type Condition

+ func CrossJoins(tableName string, conds ...Expr) Condition

+ func CrossJoinsX(tableName, alias string, conds ...Expr) Condition

+ func InnerJoins(tableName string, conds ...Expr) Condition

+ func InnerJoinsX(tableName, alias string, conds ...Expr) Condition

+ func LeftJoins(tableName string, conds ...Expr) Condition

+ func LeftJoinsX(tableName, alias string, conds ...Expr) Condition

+ func RightJoins(tableName string, conds ...Expr) Condition

+ func RightJoinsX(tableName, alias string, conds ...Expr) Condition

type Conditions

+ func (c Conditions) CrossJoins(tableName string, conds ...Expr) Conditions

+ func (c Conditions) CrossJoinsX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) InnerJoins(tableName string, conds ...Expr) Conditions

+ func (c Conditions) InnerJoinsX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) LeftJoins(tableName string, conds ...Expr) Conditions

+ func (c Conditions) LeftJoinsX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) RightJoins(tableName string, conds ...Expr) Conditions

+ func (c Conditions) RightJoinsX(tableName, alias string, conds ...Expr) Conditions

v0.0.7

May 11, 2023

Changes in this version

type Field

+ func (field Field) LTrim(remStr string) String

+ func (field Field) LTrimSpace() String

+ func (field Field) RTrim(remStr string) String

+ func (field Field) RTrimSpace() String

+ func (field Field) Trim(remStr string) String

+ func (field Field) TrimSpace() String

type String

+ func (field String) LTrim(remStr string) String

+ func (field String) LTrimSpace() String

+ func (field String) RTrim(remStr string) String

+ func (field String) RTrimSpace() String

+ func (field String) Trim(remStr string) String

+ func (field String) TrimSpace() String

v0.0.6

May 11, 2023

Changes in this version

+ func IntoIntegerSlice(values []T) []R

v0.0.5

May 8, 2023

v0.0.4

May 4, 2023

v0.0.3

Apr 28, 2023

Changes in this version

+ func IntoSlice(values []T, f func(T) R) []R

v0.0.2

Apr 27, 2023

Changes in this version

type Conditions

+ func (c Conditions) Append(cs ...Condition) Conditions

v0.0.1

Apr 27, 2023

Changes in this version

+ var All = Star

+ var DefaultMaxPerPage = int64(500)

+ var DefaultPerPage = int64(50)

+ var One = NewRaw("1")

+ var Star = NewAsterisk("")

+ func Indirect(value interface{}) reflect.Type

+ func IntoExpression(conds ...Expr) []clause.Expression

+ func Paginate(page, perPage int64) clause.Expression

+ type Asterisk struct

+ func NewAsterisk(table string, opts ...Option) Asterisk

+ func (a Asterisk) Count() Asterisk

+ func (a Asterisk) Distinct() Asterisk

+ func (e Asterisk) AddCol(col Expr) Expr

+ func (e Asterisk) As(alias string) Expr

+ func (e Asterisk) AsWithPrefix(prefix string) Expr

+ func (e Asterisk) Avg() Float64

+ func (e Asterisk) Build(builder clause.Builder)

+ func (e Asterisk) BuildColumn(stmt *gorm.Statement, opts ...BuildOption) string

+ func (e Asterisk) BuildWithArgs(stmt *gorm.Statement) (string, []any)

+ func (e Asterisk) ColumnName() string

+ func (e Asterisk) ConcatCol(cols ...Expr) Expr

+ func (e Asterisk) Desc() Expr

+ func (e Asterisk) DivCol(col Expr) Expr

+ func (e Asterisk) EqCol(col Expr) Expr

+ func (e Asterisk) Expression() clause.Expression

+ func (e Asterisk) GroupConcat() Expr

+ func (e Asterisk) GtCol(col Expr) Expr

+ func (e Asterisk) GteCol(col Expr) Expr

+ func (e Asterisk) IsNotNull() Expr

+ func (e Asterisk) IsNull() Expr

+ func (e Asterisk) Length() Int

+ func (e Asterisk) LtCol(col Expr) Expr

+ func (e Asterisk) LteCol(col Expr) Expr

+ func (e Asterisk) Max() Float64

+ func (e Asterisk) Min() Float64

+ func (e Asterisk) MulCol(col Expr) Expr

+ func (e Asterisk) NeqCol(col Expr) Expr

+ func (e Asterisk) RawExpr() expression

+ func (e Asterisk) SubCol(col Expr) Expr

+ func (e Asterisk) WithTable(table string) Expr

+ type Bool Field

+ func NewBool(table, column string, opts ...Option) Bool

+ func (field Bool) And(value bool) Expr

+ func (field Bool) BitAnd(value bool) Expr

+ func (field Bool) BitOr(value bool) Expr

+ func (field Bool) BitXor(value bool) Expr

+ func (field Bool) Eq(value bool) Expr

+ func (field Bool) IfNull(value bool) Expr

+ func (field Bool) IntoColumns() Columns

+ func (field Bool) Is(value bool) Expr

+ func (field Bool) Neq(value bool) Expr

+ func (field Bool) Not() Expr

+ func (field Bool) Or(value bool) Expr

+ func (field Bool) Xor(value bool) Expr

+ type BuildOption uint

+ const WithAll

+ const WithTable

+ const WithoutQuote

+ type Bytes Field

+ func NewBytes(table, column string, opts ...Option) Bytes

+ func (field Bytes) Between(left []byte, right []byte) Expr

+ func (field Bytes) Eq(value []byte) Expr

+ func (field Bytes) FindInSet(targetList string) Expr

+ func (field Bytes) FindInSetWith(target string) Expr

+ func (field Bytes) FuzzyLike(value string) Expr

+ func (field Bytes) Gt(value []byte) Expr

+ func (field Bytes) Gte(value []byte) Expr

+ func (field Bytes) IfNull(value []byte) Expr

+ func (field Bytes) In(values ...[]byte) Expr

+ func (field Bytes) IntoColumns() Columns

+ func (field Bytes) LeftLike(value string) Expr

+ func (field Bytes) Like(value string) Expr

+ func (field Bytes) Lt(value []byte) Expr

+ func (field Bytes) Lte(value []byte) Expr

+ func (field Bytes) Neq(value []byte) Expr

+ func (field Bytes) NotBetween(left []byte, right []byte) Expr

+ func (field Bytes) NotIn(values ...[]byte) Expr

+ func (field Bytes) NotLike(value string) Expr

+ func (field Bytes) NotRegxp(value string) Expr

+ func (field Bytes) Regexp(value string) Expr

+ func (field Bytes) SubstringIndex(delim string, count int) Bytes

+ type Columns []Expr

+ func NewColumns(cols ...Expr) Columns

+ func (cs Columns) Eq(subQuery *gorm.DB) Expr

+ func (cs Columns) Gt(subQuery *gorm.DB) Expr

+ func (cs Columns) Gte(subQuery *gorm.DB) Expr

+ func (cs Columns) In(subQueryOrValue any) Expr

+ func (cs Columns) Lt(subQuery *gorm.DB) Expr

+ func (cs Columns) Lte(subQuery *gorm.DB) Expr

+ func (cs Columns) Neq(subQuery *gorm.DB) Expr

+ func (cs Columns) NotIn(subQueryOrValue any) Expr

+ type Condition = func(*gorm.DB) *gorm.DB

+ func CrossJoin(tableName string, conds ...Expr) Condition

+ func CrossJoinX(tableName, alias string, conds ...Expr) Condition

+ func Group(columns ...Expr) Condition

+ func Having(columns ...Expr) Condition

+ func InnerJoin(tableName string, conds ...Expr) Condition

+ func InnerJoinX(tableName, alias string, conds ...Expr) Condition

+ func Join(tableName string, conds ...Expr) Condition

+ func JoinX(tableName, alias string, conds ...Expr) Condition

+ func LeftJoin(tableName string, conds ...Expr) Condition

+ func LeftJoinX(tableName, alias string, conds ...Expr) Condition

+ func LockingShare() Condition

+ func LockingUpdate() Condition

+ func Order(columns ...Expr) Condition

+ func Pagination(page, perPage int64) Condition

+ func RightJoin(tableName string, conds ...Expr) Condition

+ func RightJoinX(tableName, alias string, conds ...Expr) Condition

+ func Select(columns ...Expr) Condition

+ func Table(fromSubs ...From) Condition

+ func Where(columns ...Expr) Condition

+ type Conditions []Condition

+ func NewConditions() Conditions

+ func (c Conditions) Build() []Condition

+ func (c Conditions) CrossJoin(tableName string, conds ...Expr) Conditions

+ func (c Conditions) CrossJoinX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) Group(columns ...Expr) Conditions

+ func (c Conditions) Having(columns ...Expr) Conditions

+ func (c Conditions) InnerJoin(tableName string, conds ...Expr) Conditions

+ func (c Conditions) InnerJoinX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) Join(tableName string, conds ...Expr) Conditions

+ func (c Conditions) JoinX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) LeftJoin(tableName string, conds ...Expr) Conditions

+ func (c Conditions) LeftJoinX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) LockingShare() Conditions

+ func (c Conditions) LockingUpdate() Conditions

+ func (c Conditions) Order(columns ...Expr) Conditions

+ func (c Conditions) Pagination(page, perPage int64) Conditions

+ func (c Conditions) RightJoin(tableName string, conds ...Expr) Conditions

+ func (c Conditions) RightJoinX(tableName, alias string, conds ...Expr) Conditions

+ func (c Conditions) Select(columns ...Expr) Conditions

+ func (c Conditions) Table(fromSubs ...From) Conditions

+ func (c Conditions) Where(columns ...Expr) Conditions

+ type Decimal = Float[string]

+ func NewDecimal(table, column string, opts ...Option) Decimal

+ type Expr interface

+ AddCol func(col Expr) Expr

+ As func(alias string) Expr

+ AsWithPrefix func(prefix string) Expr

+ BuildColumn func(*gorm.Statement, ...BuildOption) string

+ BuildWithArgs func(*gorm.Statement) (query string, args []any)

+ ColumnName func() string

+ ConcatCol func(cols ...Expr) Expr

+ DivCol func(col Expr) Expr

+ Expression func() clause.Expression

+ MulCol func(col Expr) Expr

+ RawExpr func() expression

+ SubCol func(col Expr) Expr

+ func And(exprs ...Expr) Expr

+ func EmptyExpr() Expr

+ func Exist(subQuery *gorm.DB) Expr

+ func Not(exprs ...Expr) Expr

+ func NotExist(subQuery *gorm.DB) Expr

+ func Or(exprs ...Expr) Expr

+ type Field struct

+ func NewField(table, column string, opts ...Option) Field

+ func (e Field) AddCol(col Expr) Expr

+ func (e Field) As(alias string) Expr

+ func (e Field) AsWithPrefix(prefix string) Expr

+ func (e Field) Avg() Float64

+ func (e Field) Build(builder clause.Builder)

+ func (e Field) BuildColumn(stmt *gorm.Statement, opts ...BuildOption) string

+ func (e Field) BuildWithArgs(stmt *gorm.Statement) (string, []any)

+ func (e Field) ColumnName() string

+ func (e Field) ConcatCol(cols ...Expr) Expr

+ func (e Field) Count() Int

+ func (e Field) Desc() Expr

+ func (e Field) Distinct() Int

+ func (e Field) DivCol(col Expr) Expr

+ func (e Field) EqCol(col Expr) Expr

+ func (e Field) Expression() clause.Expression

+ func (e Field) GroupConcat() Expr

+ func (e Field) GtCol(col Expr) Expr

+ func (e Field) GteCol(col Expr) Expr

+ func (e Field) IsNotNull() Expr

+ func (e Field) IsNull() Expr

+ func (e Field) Length() Int

+ func (e Field) LtCol(col Expr) Expr

+ func (e Field) LteCol(col Expr) Expr

+ func (e Field) Max() Float64

+ func (e Field) Min() Float64

+ func (e Field) MulCol(col Expr) Expr

+ func (e Field) NeqCol(col Expr) Expr

+ func (e Field) RawExpr() expression

+ func (e Field) SubCol(col Expr) Expr

+ func (e Field) WithTable(table string) Expr

+ func (field Field) Add(value any) Field

+ func (field Field) Between(left any, right any) Expr

+ func (field Field) BitAnd(value any) Field

+ func (field Field) BitFlip() Field

+ func (field Field) BitOr(value any) Field

+ func (field Field) BitXor(value any) Field

+ func (field Field) Concat(before, after string) String

+ func (field Field) Date() Time

+ func (field Field) DateDiff(expr2 time.Time) Int

+ func (field Field) DateFormat(format string) String

+ func (field Field) Day() Int

+ func (field Field) DayName() String

+ func (field Field) DayOfMonth() Int

+ func (field Field) DayOfWeek() Int

+ func (field Field) DayOfYear() Int

+ func (field Field) Div(value any) Field

+ func (field Field) Eq(value any) Expr

+ func (field Field) FindInSet(targetList string) Expr

+ func (field Field) FindInSetWith(target string) Expr

+ func (field Field) Floor() Field

+ func (field Field) FloorDiv(value any) Field

+ func (field Field) FromDays() Time

+ func (field Field) FromUnixTime(format ...string) String

+ func (field Field) Gt(value any) Expr

+ func (field Field) Gte(value any) Expr

+ func (field Field) Hour() Int

+ func (field Field) IfNull(value any) Expr

+ func (field Field) In(values ...any) Expr

+ func (field Field) IntoColumns() Columns

+ func (field Field) LeftShift(value any) Field

+ func (field Field) Like(value any) Expr

+ func (field Field) Lt(value any) Expr

+ func (field Field) Lte(value any) Expr

+ func (field Field) MicroSecond() Int

+ func (field Field) Minute() Int

+ func (field Field) Mod(value any) Field

+ func (field Field) Month() Int

+ func (field Field) MonthName() String

+ func (field Field) Mul(value any) Field

+ func (field Field) Neq(value any) Expr

+ func (field Field) NotBetween(left any, right any) Expr

+ func (field Field) NotIn(values ...any) Expr

+ func (field Field) NotLike(value any) Expr

+ func (field Field) NotRegxp(value string) Expr

+ func (field Field) Regexp(value any) Expr

+ func (field Field) Replace(from, to string) String

+ func (field Field) RightShift(value any) Field

+ func (field Field) Round(decimals int) Field

+ func (field Field) Second() Int

+ func (field Field) Sub(value any) Field

+ func (field Field) SubstringIndex(delim string, count int) String

+ func (field Field) Sum() Field

+ func (field Field) UnixTimestamp() Int64

+ func (field Field) Year() Int

+ type Float Field

+ func NewFloat(table, column string, opts ...Option) Float[T]

+ func (field Float[T]) Add(value T) Float[T]

+ func (field Float[T]) Between(left T, right T) Expr

+ func (field Float[T]) Div(value T) Float[T]

+ func (field Float[T]) Eq(value T) Expr

+ func (field Float[T]) Floor() Int

+ func (field Float[T]) FloorDiv(value T) Int

+ func (field Float[T]) Gt(value T) Expr

+ func (field Float[T]) Gte(value T) Expr

+ func (field Float[T]) IfNull(value T) Expr

+ func (field Float[T]) In(values ...T) Expr

+ func (field Float[T]) IntoColumns() Columns

+ func (field Float[T]) Like(value T) Expr

+ func (field Float[T]) Lt(value T) Expr

+ func (field Float[T]) Lte(value T) Expr

+ func (field Float[T]) Mul(value T) Float[T]

+ func (field Float[T]) Neq(value T) Expr

+ func (field Float[T]) NotBetween(left T, right T) Expr

+ func (field Float[T]) NotIn(values ...T) Expr

+ func (field Float[T]) NotLike(value T) Expr

+ func (field Float[T]) Round(decimals int) Float[T]

+ func (field Float[T]) Sub(value T) Float[T]

+ func (field Float[T]) Sum() Float[T]

+ type Float32 = Float[float32]

+ func NewFloat32(table, column string, opts ...Option) Float32

+ type Float64 = Float[float64]

+ func NewFloat64(table, column string, opts ...Option) Float64

+ type From struct

+ Alias string

+ SubQuery *gorm.DB

+ type Int = Integer[int]

+ func NewInt(table, column string, opts ...Option) Int

+ type Int16 = Integer[int16]

+ func NewInt16(table, column string, opts ...Option) Int16

+ type Int32 = Integer[int32]

+ func NewInt32(table, column string, opts ...Option) Int32

+ type Int64 = Integer[int64]

+ func NewInt64(table, column string, opts ...Option) Int64

+ func UnixTimestamp(date ...string) Int64

+ type Int8 = Integer[int8]

+ func NewInt8(table, column string, opts ...Option) Int8

+ type Integer Field

+ func NewInteger(table, column string, opts ...Option) Integer[T]

+ func (field Integer[T]) Add(value T) Integer[T]

+ func (field Integer[T]) Between(left T, right T) Expr

+ func (field Integer[T]) BitAnd(value T) Integer[T]

+ func (field Integer[T]) BitFlip() Integer[T]

+ func (field Integer[T]) BitOr(value T) Integer[T]

+ func (field Integer[T]) BitXor(value T) Integer[T]

+ func (field Integer[T]) Div(value T) Integer[T]

+ func (field Integer[T]) Eq(value T) Expr

+ func (field Integer[T]) FloorDiv(value T) Integer[T]

+ func (field Integer[T]) FromDays() Time

+ func (field Integer[T]) FromUnixTime(format ...string) String

+ func (field Integer[T]) Gt(value T) Expr

+ func (field Integer[T]) Gte(value T) Expr

+ func (field Integer[T]) IfNull(value T) Expr

+ func (field Integer[T]) In(values ...T) Expr

+ func (field Integer[T]) IntoColumns() Columns

+ func (field Integer[T]) LeftShift(value T) Integer[T]

+ func (field Integer[T]) Like(value T) Expr

+ func (field Integer[T]) Lt(value T) Expr

+ func (field Integer[T]) Lte(value T) Expr

+ func (field Integer[T]) Mod(value T) Integer[T]

+ func (field Integer[T]) Mul(value T) Integer[T]

+ func (field Integer[T]) Neq(value T) Expr

+ func (field Integer[T]) NotBetween(left T, right T) Expr

+ func (field Integer[T]) NotIn(values ...T) Expr

+ func (field Integer[T]) NotLike(value T) Expr

+ func (field Integer[T]) RightShift(value T) Integer[T]

+ func (field Integer[T]) Round(value int) Integer[T]

+ func (field Integer[T]) Sub(value T) Integer[T]

+ func (field Integer[T]) Sum() Integer[T]

+ type Option func(clause.Column) clause.Column

+ type Raw = Field

+ func NewRaw(sql string, vars ...any) Raw

+ type String Field

+ func FromUnixTime(date int64, format ...string) String

+ func NewString(table, column string, opts ...Option) String

+ func (field String) Between(left, right string) Expr

+ func (field String) Concat(before, after string) String

+ func (field String) Eq(value string) Expr

+ func (field String) FindInSet(targetList string) Expr

+ func (field String) FindInSetWith(target string) Expr

+ func (field String) FuzzyLike(value string) Expr

+ func (field String) Gt(value string) Expr

+ func (field String) Gte(value string) Expr

+ func (field String) IfNull(value string) Expr

+ func (field String) In(values ...string) Expr

+ func (field String) IntoColumns() Columns

+ func (field String) LeftLike(value string) Expr

+ func (field String) Like(value string) Expr

+ func (field String) Lt(value string) Expr

+ func (field String) Lte(value string) Expr

+ func (field String) Neq(value string) Expr

+ func (field String) NotBetween(left, right string) Expr

+ func (field String) NotIn(values ...string) Expr

+ func (field String) NotLike(value string) Expr

+ func (field String) NotRegxp(value string) Expr

+ func (field String) Regexp(value string) Expr

+ func (field String) Replace(from, to string) String

+ func (field String) SubstringIndex(delim string, count int) String

+ type Time Field

+ func CurDate() Time

+ func CurTime() Time

+ func FromDays(value int) Time

+ func NewTime(table, column string, opts ...Option) Time

+ func Now() Time

+ func (field Time) Add(value time.Duration) Time

+ func (field Time) Between(left time.Time, right time.Time) Expr

+ func (field Time) Date() Time

+ func (field Time) DateDiff(expr2 time.Time) Int

+ func (field Time) DateFormat(format string) String

+ func (field Time) Day() Int

+ func (field Time) DayName() String

+ func (field Time) DayOfMonth() Int

+ func (field Time) DayOfWeek() Int

+ func (field Time) DayOfYear() Int

+ func (field Time) Eq(value time.Time) Expr

+ func (field Time) Gt(value time.Time) Expr

+ func (field Time) Gte(value time.Time) Expr

+ func (field Time) Hour() Int

+ func (field Time) IfNull(value time.Time) Expr

+ func (field Time) In(values ...time.Time) Expr

+ func (field Time) IntoColumns() Columns

+ func (field Time) Lt(value time.Time) Expr

+ func (field Time) Lte(value time.Time) Expr

+ func (field Time) MicroSecond() Int

+ func (field Time) Minute() Int

+ func (field Time) Month() Int

+ func (field Time) MonthName() String

+ func (field Time) Neq(value time.Time) Expr

+ func (field Time) NotBetween(left time.Time, right time.Time) Expr

+ func (field Time) NotIn(values ...time.Time) Expr

+ func (field Time) Second() Int

+ func (field Time) Sub(value time.Duration) Time

+ func (field Time) Sum() Time

+ func (field Time) UnixTimestamp() Int64

+ func (field Time) Year() Int

+ type Uint = Integer[uint]

+ func NewUint(table, column string, opts ...Option) Uint

+ type Uint16 = Integer[uint16]

+ func NewUint16(table, column string, opts ...Option) Uint16

+ type Uint32 = Integer[uint32]

+ func NewUint32(table, column string, opts ...Option) Uint32

+ type Uint64 = Integer[uint64]

+ func NewUint64(table, column string, opts ...Option) Uint64

+ type Uint8 = Integer[uint8]

+ func NewUint8(table, column string, opts ...Option) Uint8

+ type Value clause.Expr

+ func Values(value any) Value

v0.0.1-rc5

Apr 26, 2023

v0.0.1-rc4

Apr 26, 2023

v0.0.1-rc3

Apr 25, 2023

v0.0.1-rc2

Apr 20, 2023

v0.0.1-rc1

Apr 19, 2023

v0.0.1-rc0

Apr 18, 2023

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