postgres

package module

v0.10.2 Latest Latest Go to latest Published: Feb 13, 2022 License: Apache-2.0 Imports: 15 Imported by: 5

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/aacfactory/fns-contrib

Links

Open Source Insights

README ¶

Postgres

Documentation ¶

Index ¶

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
- 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
- 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 LoadMakeupHook
type Order
- func Asc(column string) *Order
- func Desc(column string) *Order
type Orders
- func NewOrders() *Orders
- func (o *Orders) Asc(column string) *Orders
- func (o *Orders) Desc(column string) *Orders
type PageInfo
- 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
- func NewRange(offset int, limit int) *Range
type Select
- func LitSelect(query string) Select
type Table

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func Count ¶

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

func Delete ¶

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

func Exist ¶

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

func Insert ¶

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

func InsertOrUpdate ¶

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

func InsertWhenExist ¶

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

func InsertWhenNotExist ¶

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

func LitValue ¶

func LitValue(v string) *lit

func Modify ¶

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

func Query ¶

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

func QueryDirect ¶

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

func QueryOne ¶

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

func QueryWithRange ¶

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

Types ¶

type Condition ¶

type Condition struct {
	Column    string
	Operation string
	Values    []interface{}
}

func Between ¶

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

func Eq ¶

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

func GT ¶

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

func GTE ¶

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

func IN ¶

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

func LT ¶

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

func LTE ¶

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

func Like ¶

func Like(column string, value string) *Condition

func LikeLeft ¶

func LikeLeft(column string, value string) *Condition

func LikeRight ¶

func LikeRight(column string, value string) *Condition

func NotDeleted ¶

func NotDeleted(deletedByColumnName string) *Condition

func NotEq ¶

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

type Conditions ¶

type Conditions struct {
	// contains filtered or unexported fields
}

func NewConditions ¶

func NewConditions(cond *Condition) *Conditions

func (*Conditions) And ¶

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

func (*Conditions) AndConditions ¶

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

func (*Conditions) Or ¶

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

func (*Conditions) OrConditions ¶

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

func (*Conditions) QueryAndArguments ¶

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

type LoadMakeupHook ¶ added in v0.10.2

type LoadMakeupHook interface {
	Makeup(ctx fns.Context) (err errors.CodeError)
}

type Order ¶

type Order struct {
	Column string
	Desc   bool
}

func Asc ¶

func Asc(column string) *Order

func Desc ¶

func Desc(column string) *Order

type Orders ¶

type Orders struct {
	// contains filtered or unexported fields
}

func NewOrders ¶

func NewOrders() *Orders

func (*Orders) Asc ¶

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

func (*Orders) Desc ¶

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

type PageInfo ¶

type PageInfo struct {
	No    int
	Num   int
	Total int
}

func Page ¶

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

func (*PageInfo) Empty ¶

func (p *PageInfo) Empty() bool

type Range ¶

type Range struct {
	Offset int
	Limit  int
}

func NewRange ¶

func NewRange(offset int, limit int) *Range

type Select ¶

type Select interface {
	Build(args *sql.Tuple) (query string)
}

func LitSelect ¶

func LitSelect(query string) Select

type Table ¶

type Table interface {
	TableName() (schema string, table string)
}

Source Files ¶

View all Source files

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