pgxz

Sep 8, 2023

Changes in this version

+ func Raw(db *PgDb, sqlStr string, sqlArgs ...any) ([]T, error)

Sep 6, 2023

Changes in this version

+ func GetAllForSingle(db *PgDb, col ICol, options ...IOption) ([]T, error)

Aug 24, 2023

Changes in this version

+ func Select(sql string) *selectOption

Aug 22, 2023

Changes in this version

+ type IPageParams interface

+ GetPageNum func() int64

+ GetPageSize func() int64

+ type PageParams struct

+ PageNum int64

+ PageSize int64

+ func (p PageParams) GetPageNum() int64

+ func (p PageParams) GetPageSize() int64

+ type PageResult struct

+ List []T

+ func Page(db *PgDb, selectSql, filterSql, orderSql string, pageParams IPageParams) (*PageResult[T], error)

+ type Pagination struct

+ IsFirstPage bool

+ IsLastPage bool

+ PageNum int64

+ PageSize int64

+ PageTotal int64

+ Total int64

+ func NewPagination(pageParams IPageParams) Pagination

+ func (p *Pagination) Compute(total int64)

+ func (p *Pagination) GetSkipRows() int64

+ type UserPageParams struct

+ DeptId int64

Aug 21, 2023

Changes in this version

+ var DEBUG = false

+ func GroupBy(sql string) *groupOption

+ func Limit(v int64) *limitOption

+ func Offset(v int64) *offsetOption

+ func OrderBy(sql string) *orderOption

+ func Where(sql string, args ...any) *whereOption

+ type IOption interface

+ ToSql func() string

+ type OptionGroup struct

+ type OptionType uint8

Aug 20, 2023

Changes in this version

+ func GetAll(db *PgDb, col ICol, whereSql string, whereArgs ...any) ([]T, error)

Aug 20, 2023

Changes in this version

+ func Delete(db *PgDb, col ICol, whereSql string, whereArgs ...any) error

type Col

+ func (c *Col) IsSet(key string) bool

type ICol

+ IsSet func(k string) bool

Aug 20, 2023

Changes in this version

type Col

+ func (c *Col) HasKey(key string) bool

+ func (c *Col) Keys() []string

+ func (c *Col) SetMust(fn string, v any)

type ICol

+ HasKey func(k string) bool

+ SetMust func(fn string, v any)

+ type KyeMap map[string]struct

Aug 20, 2023

Changes in this version

+ func CreateAndReturn(db *PgDb, col ICol) (*T, error)

Aug 19, 2023

Changes in this version

+ func Count(db *PgDb, whereSql string, whereArgs ...any) (int64, error)

+ func Create(db *PgDb, col ICol) error

+ func GetOne(db *PgDb, whereSql string, whereArgs ...any) (*T, error)

+ func Update(db *PgDb, updates ICol, whereSql string, whereArgs ...any) error

+ type Col struct

+ func (c *Col) Init()

+ func (c *Col) Mapping() map[string]any

+ func (c *Col) Set(fn string, v any)

+ func (c *Col) SetIfNotNil(fn string, v any)

+ type ICol interface

+ Init func()

+ Keys func() []string

+ Mapping func() map[string]any

+ Set func(fn string, v any)

+ SetIfNotNil func(fn string, v any)

+ TableName func() string

+ type IModel interface

+ TableName func() string

+ type PgDb struct

+ func New(pool *pgxpool.Pool) *PgDb