README
¶
Postgres
Usage
Add import in deploy src file.
import (
_ "github.com/aacfactory/fns-contrib/databases/postgres/dialect"
)
Use github.com/aacfactory/fns-contrib/databases/postgres insteadof github.com/aacfactory/fns-contrib/databases/sql/dac.
entry, err = postgres.Insert[Table](ctx, entry)
Documentation
¶
Index ¶
- func ALL[T Table](ctx context.Context, options ...QueryOption) (entries []T, err error)
- func Asc(name string) orders.Orders
- func Between(field string, left any, right any) conditions.Condition
- func Bool(b bool) conditions.Literal
- func ContainsJsonKey(field string, key string) conditions.Condition
- func ContainsJsonObject(field string, object json.RawMessage) conditions.Condition
- func ContainsJsonObjectOfArray(field string, object json.RawMessage) conditions.Condition
- func ContainsJsonObjectsOfArray(field string, all bool, elements ...any) conditions.Condition
- func Count[T Table](ctx context.Context, cond conditions.Condition) (count int64, err error)
- func Delete[T Table](ctx context.Context, entry T) (v T, affected int64, err error)
- func DeleteByCondition[T Table](ctx context.Context, cond conditions.Condition) (affected int64, err error)
- func Desc(name string) orders.Orders
- func Eq(field string, expression any) conditions.Condition
- func Exist[T Table](ctx context.Context, cond conditions.Condition) (has bool, 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 Insert[T Table](ctx context.Context, entry T) (v T, ok bool, err error)
- func InsertMulti[T Table](ctx context.Context, entries []T) (affected int64, err error)
- func InsertOrUpdate[T Table](ctx context.Context, entry T) (v T, err error)
- func InsertWhenExist[T Table](ctx context.Context, entry T, source conditions.QueryExpr) (v T, err error)
- func InsertWhenNotExist[T Table](ctx context.Context, entry T, source conditions.QueryExpr) (v T, err error)
- func Int(n int) conditions.Literal
- func Int64(n int64) conditions.Literal
- func Like(field string, expression string) conditions.Condition
- func LikeContains(field string, expression string) conditions.Condition
- func LikeLast(field string, expression string) conditions.Condition
- func Lit(v string) conditions.Literal
- 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 NotEq(field string, expression any) conditions.Condition
- func NotIn(field string, expression ...any) conditions.Condition
- func One[T Table](ctx context.Context, options ...QueryOption) (entry T, has bool, err error)
- func Page[T Table](ctx context.Context, no int, size int, options ...QueryOption) (page dac.Pager[T], err error)
- func Query[T Table](ctx context.Context, offset int, length int, options ...QueryOption) (entries []T, err error)
- func String(s string) conditions.Literal
- func SubQuery(query any, field string, cond conditions.Condition) conditions.QueryExpr
- 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 Update[T Table](ctx context.Context, entry T) (v T, affected int64, err error)
- func UpdateFields[T Table](ctx context.Context, fields FieldValues, cond conditions.Condition) (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
- type QueryOption
- type QueryOptions
- type Table
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func ALL ¶ added in v1.0.0
func ALL[T Table](ctx context.Context, options ...QueryOption) (entries []T, err error)
func Bool ¶ added in v1.0.0
func Bool(b bool) conditions.Literal
func ContainsJsonKey ¶ added in v0.12.6
func ContainsJsonKey(field string, key string) conditions.Condition
func ContainsJsonObject ¶ added in v0.12.6
func ContainsJsonObject(field string, object json.RawMessage) conditions.Condition
func ContainsJsonObjectOfArray ¶ added in v0.12.6
func ContainsJsonObjectOfArray(field string, object json.RawMessage) conditions.Condition
func ContainsJsonObjectsOfArray ¶ added in v0.12.6
func ContainsJsonObjectsOfArray(field string, all bool, elements ...any) conditions.Condition
func DeleteByCondition ¶ added in v1.0.0
func FAG ¶ added in v1.0.0
func FAG() []modules.FnAnnotationCodeWriter
func Float ¶ added in v1.0.0
func Float(f float32) conditions.Literal
func Float64 ¶ added in v1.0.0
func Float64(f float64) conditions.Literal
func InsertMulti ¶ added in v1.0.0
func InsertWhenExist ¶
func InsertWhenNotExist ¶
func Int ¶ added in v1.0.0
func Int(n int) conditions.Literal
func Int64 ¶ added in v1.0.0
func Int64(n int64) conditions.Literal
func LikeContains ¶ added in v1.0.0
func LikeContains(field string, expression string) conditions.Condition
func Lit ¶ added in v0.12.6
func Lit(v string) conditions.Literal
func LitSubQuery ¶ added in v1.0.0
func LitSubQuery(query string) conditions.QueryExpr
func String ¶ added in v1.0.0
func String(s string) conditions.Literal
func SubQuery ¶ added in v0.12.8
func SubQuery(query any, field string, cond conditions.Condition) conditions.QueryExpr
func Tree ¶ added in v1.0.0
func Tree[T Table](ctx context.Context, options ...QueryOption) (entry T, err error)
func Trees ¶ added in v1.0.0
func Trees[T Table](ctx context.Context, options ...QueryOption) (entries []T, err error)
func Uint ¶ added in v1.0.0
func Uint(n uint) conditions.Literal
func Uint64 ¶ added in v1.0.0
func Uint64(n uint64) conditions.Literal
func UpdateFields ¶ added in v1.0.0
func UpdateFields[T Table](ctx context.Context, fields FieldValues, cond conditions.Condition) (affected int64, err error)
Types ¶
type FieldValues ¶ added in v1.0.0
type FieldValues dac.FieldValues
func Field ¶ added in v1.0.0
func Field(name string, value any) FieldValues
func (FieldValues) Field ¶ added in v1.0.0
func (fields FieldValues) Field(name string, value any) FieldValues
type QueryOption ¶ added in v1.0.0
type QueryOption dac.QueryOption
func Conditions ¶
func Conditions(cond conditions.Condition) QueryOption
func GroupBy ¶ added in v1.0.0
func GroupBy(fields ...string) QueryOption
func Having ¶ added in v1.0.0
func Having(cond conditions.Condition) QueryOption
func Orders ¶
func Orders(order orders.Orders) QueryOption
type QueryOptions ¶ added in v1.0.0
type QueryOptions struct {
dac.QueryOption
}
Source Files
¶
Directories
Click to show internal directories.
Click to hide internal directories.