mworm

Mar 24, 2026

Changes in this version

type ConditionGroup

+ SubGroups []ConditionGroup

+ func AndGroup(cgs ...ConditionGroup) ConditionGroup

+ func Between(tag string, min, max any) ConditionGroup

+ func Exists(sql string, args ...any) ConditionGroup

+ func NotExists(sql string, args ...any) ConditionGroup

+ func NotIN[T any](tag string, args ...T) ConditionGroup

+ func OrGroup(cgs ...ConditionGroup) ConditionGroup

+ func SubQuery(tag, symbol, sql string, args ...any) ConditionGroup

type OrmModel

+ func (o *OrmModel) Avg(column string) (float64, error)

+ func (o *OrmModel) DoNothing() *OrmModel

+ func (o *OrmModel) DoUpdate(jsonTags ...string) *OrmModel

+ func (o *OrmModel) Max(column string) (float64, error)

+ func (o *OrmModel) Min(column string) (float64, error)

+ func (o *OrmModel) OnConflict(jsonTags ...string) *OrmModel

+ func (o *OrmModel) Sum(column string) (float64, error)

Mar 10, 2026

Changes in this version

type SQLParams

+ Args []any

+ func (sp SQLParams) ExeSql() string

+ func (sp SQLParams) TxExec(tx *sqlx.Tx) (dbsql.Result, error)

+ func (sp SQLParams) TxMustExec(tx *sqlx.Tx) dbsql.Result

Mar 7, 2026

Changes in this version

type JoinTable

+ func INNER_JOIN(i ORMInterface, alias string) *JoinTable

+ func LEFT_JOIN(i ORMInterface, alias string) *JoinTable

+ func NewJoin(joinType JoinType, table, alias string) *JoinTable

+ func RIGHT_JOIN(i ORMInterface, alias string) *JoinTable

+ func (j *JoinTable) On(cgs ...ConditionGroup) *JoinTable

+ func (j *JoinTable) Select(fields ...string) *JoinTable

type JoinType

+ const InnerJoinType

+ const LeftJoinType

+ const RightJoinType

Oct 15, 2025

Changes in this version

type ConditionGroup

+ func Fields(tag ...string) ConditionGroup

type OrmModel

+ func (o *OrmModel) GroupBy(cgs ...ConditionGroup) *OrmModel

+ func (o *OrmModel) Having(exp string, args ...any) *OrmModel

Sep 20, 2025

Changes in this version

type ConditionGroup

+ func NEq(tag string, args ...any) ConditionGroup

+ func NEqLike(tag ...string) ConditionGroup

+ func NEqNull(tag ...string) ConditionGroup

+ func Null(tag ...string) ConditionGroup

+ func NullOR(tag ...string) ConditionGroup

Sep 16, 2025

Changes in this version

type ConditionGroup

+ func AndAuto(tag ...string) ConditionGroup

+ func OrAuto(tag ...string) ConditionGroup

Sep 3, 2025

Changes in this version

+ var DebugMode bool

Aug 22, 2025

Changes in this version

type ConditionGroup

+ Express string

+ func Raw(express string, args ...any) ConditionGroup

Aug 19, 2025

Changes in this version

type OrmModel

+ func (o *OrmModel) AllowEmpty(jsonTag ...string) *OrmModel

Aug 8, 2025

Changes in this version

+ type SQLParams struct

+ Err error

+ Params map[string]interface{}

+ Sql string

+ WithSql string

Aug 6, 2025

Changes in this version

type OrmModel

+ func (o *OrmModel) BuildSQL() (string, map[string]interface{})

Jul 30, 2025

Changes in this version

+ var ErrEmptySQL = &Error

+ var ErrInvalidPageSize = &Error

+ var ErrNilDB = &Error

+ var ErrNoEffect = &Error

+ func Exec(sqlStr string) error

type ConditionGroup

+ func JoinOn(express string) ConditionGroup

+ type Error struct

+ Code int

+ Message string

+ SQL string

+ func (e Error) Error() string

+ type JoinTable struct

+ Alias string

+ Conditions []ConditionGroup

+ SelectField []string

+ Table string

+ Type JoinType

+ func (j *JoinTable) SelectFields(fields ...string) *JoinTable

+ type JoinType int

+ const InnerJoin

+ const LeftJoin

+ const RightJoin

+ func (j JoinType) String() string

type OrmModel

+ func (o *OrmModel) Join(i ORMInterface) *OrmModel

Jul 4, 2025

Changes in this version

+ func JsonTagToJsonbKeys(obj interface{}, prefix string, igTags ...string) string

Jun 26, 2025

Changes in this version

+ func ValueTypeToStr(v any) string

type ConditionGroup

+ Symbol string

+ func AndZero(tag ...string) ConditionGroup

+ func AutoFill() ConditionGroup

+ func AutoFillZero() ConditionGroup

+ func Eq(tag string, args ...any) ConditionGroup

+ func Gt(tag string, args ...any) ConditionGroup

+ func Gte(tag string, args ...any) ConditionGroup

+ func IsNull(tag ...string) ConditionGroup

+ func IsNullOR(tag ...string) ConditionGroup

+ func LikeOR(tag ...string) ConditionGroup

+ func Lt(tag string, args ...any) ConditionGroup

+ func Lte(tag string, args ...any) ConditionGroup

+ func OrZero(tag ...string) ConditionGroup

type PageResult

+ func DebugPAGE[T ORMInterface](entity T, debug bool, page, pageSize int, cgs ...ConditionGroup) (PageResult[T], error)

Jun 25, 2025

Changes in this version

+ func NamedQueryWithMap(query string, fieldMap map[string]any, dest any) error

type ConditionGroup

+ func Asc(j string) ConditionGroup

+ func Desc(j string) ConditionGroup

+ func Like(jsonTag ...string) ConditionGroup

+ func LikeOr(jsonTag ...string) ConditionGroup

+ type ConditionType int

+ type PageResult struct

+ List []T

+ Page int

+ PageSize int

+ Total int

+ TotalPage int

+ func PAGE[T ORMInterface](entity T, page, pageSize int, cgs ...ConditionGroup) (PageResult[T], error)

+ func (pr PageResult[T]) CalcTotalPage() int

Jun 20, 2025

Changes in this version

+ func JsonbBuildObjString(obj interface{}, prefix ...string) string

May 19, 2024

Changes in this version

type OrmModel

+ func (o *OrmModel) FullSQL() (string, map[string]interface{})

May 19, 2024

Changes in this version

+ func ExecRawSQL(sql string, args ...any) error

May 12, 2024

Changes in this version

type OrmModel

+ func RawNamedSQL(sql string, params any) *OrmModel

+ func (o *OrmModel) Many(dest interface{}) error

+ func (o *OrmModel) One(dest interface{}) error

May 9, 2024

Changes in this version

type OrmModel

+ func (o *OrmModel) ExcludeFields(jsonTag ...string) *OrmModel

May 7, 2024

Changes in this version

type OrmModel

+ func (o *OrmModel) SetField(jsonTag string, arg any) *OrmModel

Apr 14, 2024

Changes in this version

+ func ConvertArray[T int | string](array []T) []string

Apr 9, 2024

Changes in this version

+ func NamedQuery(query string, params map[string]any, dest any) error

+ func Query(query string, dest any) error

type OrmModel

+ func O() *OrmModel

Mar 29, 2024

Changes in this version

+ var SqlxDB *sqlx.DB

+ var TagName = "db"

+ func Batch(ormArray ...*OrmModel) error

+ func BatchArray(ormArray []*OrmModel) error

+ func BatchFunc(f func(tx *sqlx.Tx)) error

+ func BindDB(DB *sqlx.DB) error

+ func NamedExec(sqlStr string, params map[string]interface{}) error

+ func RawSQL(sql string, args ...interface{}) error

+ func StructToMap(item interface{}) (map[string]interface{}, map[string]string)

+ func UnmarshalGetPath(json []byte, val interface{}, path ...interface{}) error

+ type CRUDInterface interface

+ CRUDMode func(mode string) string

+ type ConditionGroup struct

+ Args []any

+ InArgs []string

+ IsNull bool

+ JsonTags []string

+ Logic string

+ NamedExpress string

+ func And(jsonTag ...string) ConditionGroup

+ func And2F(jsonTag string, arg any) ConditionGroup

+ func Exp(express string, args ...any) ConditionGroup

+ func IN[T int | string](jsonTag string, args ...T) ConditionGroup

+ func ISNull(jsonTag ...string) ConditionGroup

+ func ISNullOr(jsonTag ...string) ConditionGroup

+ func Or(jsonTag ...string) ConditionGroup

+ func Or2F(jsonTag string, args ...any) ConditionGroup

+ func (cg ConditionGroup) Transform() string

+ type ORMInterface interface

+ TableName func() string

+ type OrmModel struct

+ func DELETE(i ORMInterface) *OrmModel

+ func INSERT(i ORMInterface) *OrmModel

+ func SELECT(i ORMInterface) *OrmModel

+ func Table(name string) *OrmModel

+ func UPDATE(i ORMInterface) *OrmModel

+ func (o *OrmModel) Asc(jsonTag ...string) *OrmModel

+ func (o *OrmModel) Count(column string) (int64, error)

+ func (o *OrmModel) Delete(i interface{}) *OrmModel

+ func (o *OrmModel) Desc(jsonTag ...string) *OrmModel

+ func (o *OrmModel) EmptyKey(f bool) *OrmModel

+ func (o *OrmModel) Error() error

+ func (o *OrmModel) Exclude(jsonTag ...string) *OrmModel

+ func (o *OrmModel) Exec() error

+ func (o *OrmModel) Fields(jsonTag ...string) *OrmModel

+ func (o *OrmModel) Get(dest interface{}) error

+ func (o *OrmModel) If(ifFunc func(o *OrmModel)) *OrmModel

+ func (o *OrmModel) Insert(i interface{}) *OrmModel

+ func (o *OrmModel) JsonbList(dest interface{}) error

+ func (o *OrmModel) JsonbListString() (string, error)

+ func (o *OrmModel) JsonbMap(dest interface{}, columns ...string) error

+ func (o *OrmModel) JsonbMapString(keys ...string) (string, error)

+ func (o *OrmModel) Limit(row int64) *OrmModel

+ func (o *OrmModel) List(dest interface{}) error

+ func (o *OrmModel) Log(l bool) *OrmModel

+ func (o *OrmModel) NamedSQL() string

+ func (o *OrmModel) Offset(row int64) *OrmModel

+ func (o *OrmModel) RETURNING(single any, list any, jsonTag ...string) error

+ func (o *OrmModel) SQL() string

+ func (o *OrmModel) Select(i interface{}) *OrmModel

+ func (o *OrmModel) Update(i interface{}) *OrmModel

+ func (o *OrmModel) Where(cgs ...ConditionGroup) *OrmModel

+ func (o *OrmModel) WherePK() *OrmModel

+ func (o *OrmModel) With(t string) *OrmModel

+ func (o *OrmModel) WithAsc(fields ...string) *OrmModel

+ func (o *OrmModel) WithDesc(fields ...string) *OrmModel