sqlhelper

package module

v1.0.0 Latest Latest Go to latest Published: Sep 18, 2022 License: Apache-2.0 Imports: 3 Imported by: 0

Details

go get github.com/TPM-Common/Gomon/sqlhelper

This section is empty.

This section is empty.

func SetInsert(ins [][2]any) (cols, nums string, args []any)

func SetWhere(sql *string, args *[]any, query []any, addWhere bool)

type LimitOffset struct {
	Limit  int
	Offset int
}

func (lo LimitOffset) Set(sql *string, args *[]any)

type OrderBy struct {
	Exprs string
	Sort  string
	Nulls string
}

func (ob OrderBy) Set(sql *string, addOrderBy bool)

type OrderBys []OrderBy

func (obs OrderBys) Set(sql *string, addOrderBy bool)

type SearchParams struct {
	WhereLikes  WhereLikes
	OrderBys    OrderBys
	LimitOffset *LimitOffset

	DefaultOrderBy *OrderBy
	MaxResults     int
}

func (s SearchParams) Set(sql *string, args *[]any)

type WhereCondition struct {
	Expression string
	Value      interface{}
}

func (wc WhereCondition) Set(sql *string, args *[]any, addWhere bool)

type WhereLike struct {
	QueryString string
	Column      string
	Inverse     bool
	Insensitive bool
}

func (wl WhereLike) Set(sql *string, args *[]any, addWhere bool)

type WhereLikeOperator struct {
	WhereLike
	Operator string
}

type WhereLikes []WhereLikeOperator

func (wls WhereLikes) Set(sql *string, args *[]any, addWhere bool)