postgres

Dec 19, 2023

Changes in this version

+ func WithTLS(fn RegisterTLSFunc) sql.Option

+ type RegisterTLSFunc func(config *tls.Config) (err error)

Dec 17, 2023

Changes in this version

+ func Begin(ctx context.Context, options ...databases.TransactionOption) (err error)

+ func Commit(ctx context.Context) (err error)

+ func Disuse(ctx context.Context) context.Context

+ func Rollback(ctx context.Context)

+ func ViewALL[V View](ctx context.Context, options ...QueryOption) (entries []V, err error)

+ func ViewOne[V View](ctx context.Context, options ...QueryOption) (entry V, has bool, err error)

+ func Views[V View](ctx context.Context, offset int, length int, options ...QueryOption) (entries []V, err error)

+ type View interface

Dec 3, 2023

Changes in this version

+ func ALL[T Table](ctx context.Context, options ...QueryOption) (entries []T, err error)

+ func Bool(b bool) conditions.Literal

+ func DeleteByCondition[T Table](ctx context.Context, cond conditions.Condition) (affected int64, err error)

+ func FAG() []modules.FnAnnotationCodeWriter

+ func Float(f float32) conditions.Literal

+ func Float64(f float64) conditions.Literal

+ func Gt(field string, expression any) conditions.Condition

+ func Gte(field string, expression any) conditions.Condition

+ func In(field string, expression ...any) conditions.Condition

+ func InsertMulti[T Table](ctx context.Context, entries []T) (affected int64, err error)

+ func Int(n int) conditions.Literal

+ func Int64(n int64) conditions.Literal

+ func LikeContains(field string, expression string) conditions.Condition

+ func LikeLast(field string, expression string) conditions.Condition

+ func LitSubQuery(query string) conditions.QueryExpr

+ func Lt(field string, expression any) conditions.Condition

+ func Lte(field string, expression any) conditions.Condition

+ func Named(name string, value any) sql.NamedArg

+ func New(options ...sql.Option) services.Service

+ func One[T Table](ctx context.Context, options ...QueryOption) (entry T, has bool, err error)

+ func String(s string) conditions.Literal

+ func Time(t time.Time) conditions.Literal

+ func Tree[T Table](ctx context.Context, options ...QueryOption) (entry T, err error)

+ func Trees[T Table](ctx context.Context, options ...QueryOption) (entries []T, err error)

+ func Uint(n uint) conditions.Literal

+ func Uint64(n uint64) conditions.Literal

+ func UpdateFields[T Table](ctx context.Context, fields FieldValues, cond conditions.Condition) (affected int64, err error)

+ func Update[T Table](ctx context.Context, entry T) (v T, affected int64, err error)

+ func Use(ctx context.Context, endpointName []byte) context.Context

+ func WithDatabase(db databases.Database) sql.Option

+ func WithName(name string) sql.Option

+ type FieldValues dac.FieldValues

+ func Field(name string, value any) FieldValues

+ func (fields FieldValues) Field(name string, value any) FieldValues

+ type QueryOption dac.QueryOption

+ func GroupBy(fields ...string) QueryOption

+ func Having(cond conditions.Condition) QueryOption

+ type QueryOptions struct

Nov 7, 2022

Changes in this version

type Condition

+ func BetweenDate(column string, dr *times.DateRange) *Condition

+ func BetweenTime(column string, tr *times.TimeRange) *Condition

+ type SubQuery struct

+ Column string

+ Conditions *Conditions

+ Row Table

+ func NewSubQuery(row Table, column string, conditions *Conditions) (sub *SubQuery)

Oct 16, 2022

Changes in this version

type Condition

+ func ContainsJsonKey(column string, key string) *Condition

+ func ContainsJsonObject(column string, object string) *Condition

+ func ContainsJsonObjectOfArray(column string, object string) *Condition

+ func ContainsJsonObjectsOfArray(column string, all bool, elements ...interface{}) *Condition

+ func LitCond(column string, operator string, value string) *Condition

+ type Lit struct

Jun 22, 2022

Changes in this version

+ func BeginTransaction(ctx context.Context) (err errors.CodeError)

+ func CommitTransaction(ctx context.Context) (err errors.CodeError)

+ func ExecuteContext(ctx context.Context, query string, args ...interface{}) (affected int64, lastInsertId int64, err errors.CodeError)

+ func RollbackTransaction(ctx context.Context) (err errors.CodeError)

+ type Row struct

+ func (row *Row) Column(name string, value interface{}) (has bool, err error)

+ func (row *Row) Empty() (ok bool)

+ func (row *Row) Scan(ctx context.Context, v interface{}) (err error)

+ type Rows struct

+ func QueryContext(ctx context.Context, query string, args ...interface{}) (rows *Rows, err errors.CodeError)

+ func (rows *Rows) Empty() (ok bool)

+ func (rows *Rows) Next() (v *Row, has bool)

+ func (rows *Rows) Scan(ctx context.Context, v interface{}) (err error)

+ func (rows *Rows) Size() int

Feb 20, 2022

Changes in this version

type Condition

+ func NotIn(column string, value interface{}) *Condition

Feb 13, 2022

Changes in this version

+ type LoadMakeupHook interface

+ Makeup func(ctx fns.Context) (err errors.CodeError)

Jan 19, 2022

Changes in this version

+ func Count(ctx fns.Context, cond *Conditions, table Table) (v int, err errors.CodeError)

+ func Delete(ctx fns.Context, row interface{}) (err errors.CodeError)

+ func Exist(ctx fns.Context, cond *Conditions, table Table) (has bool, err errors.CodeError)

+ func Insert(ctx fns.Context, row interface{}) (err errors.CodeError)

+ func InsertOrUpdate(ctx fns.Context, row interface{}) (err errors.CodeError)

+ func InsertWhenExist(ctx fns.Context, row interface{}, source Select) (err errors.CodeError)

+ func InsertWhenNotExist(ctx fns.Context, row interface{}, source Select) (err errors.CodeError)

+ func LitValue(v string) *lit

+ func Modify(ctx fns.Context, row interface{}) (err errors.CodeError)

+ func Query(ctx fns.Context, cond *Conditions, rows interface{}) (fetched bool, err errors.CodeError)

+ func QueryDirect(ctx fns.Context, query string, args *sql.Tuple, rows interface{}) (fetched bool, err error)

+ func QueryOne(ctx fns.Context, cond *Conditions, row interface{}) (fetched bool, err errors.CodeError)

+ func QueryWithRange(ctx fns.Context, cond *Conditions, orders *Orders, rng *Range, ...) (fetched bool, err errors.CodeError)

+ type Condition struct

+ Column string

+ Operation string

+ Values []interface{}

+ func Between(column string, left interface{}, right interface{}) *Condition

+ func Eq(column string, value interface{}) *Condition

+ func GT(column string, value interface{}) *Condition

+ func GTE(column string, value interface{}) *Condition

+ func IN(column string, value interface{}) *Condition

+ func LT(column string, value interface{}) *Condition

+ func LTE(column string, value interface{}) *Condition

+ func Like(column string, value string) *Condition

+ func LikeLeft(column string, value string) *Condition

+ func LikeRight(column string, value string) *Condition

+ func NotDeleted(deletedByColumnName string) *Condition

+ func NotEq(column string, value interface{}) *Condition

+ type Conditions struct

+ func NewConditions(cond *Condition) *Conditions

+ func (c *Conditions) And(v *Condition) *Conditions

+ func (c *Conditions) AndConditions(v *Conditions) *Conditions

+ func (c *Conditions) Or(v *Condition) *Conditions

+ func (c *Conditions) OrConditions(v *Conditions) *Conditions

+ func (c *Conditions) QueryAndArguments() (query string, args *sql.Tuple)

+ type Order struct

+ Column string

+ Desc bool

+ func Asc(column string) *Order

+ func Desc(column string) *Order

+ type Orders struct

+ func NewOrders() *Orders

+ func (o *Orders) Asc(column string) *Orders

+ func (o *Orders) Desc(column string) *Orders

+ type PageInfo struct

+ No int

+ Num int

+ Total int

+ func Page(ctx fns.Context, cond *Conditions, orders *Orders, pageNo int, pageSize int, ...) (page *PageInfo, err errors.CodeError)

+ func (p *PageInfo) Empty() bool

+ type Range struct

+ Limit int

+ Offset int

+ func NewRange(offset int, limit int) *Range

+ type Select interface

+ Build func(args *sql.Tuple) (query string)

+ func LitSelect(query string) Select

+ type Table interface

+ TableName func() (schema string, table string)