clause

Documentation

Index

• Constants
• Variables
• func Limit(limit, offset int) func(tx *gorm.DB) *gorm.DB
• func OnConflict(onConflict []interface{}, doUpdates []interface{}) clause.OnConflict
• func OrderBy(quoteTo func(string) string, orderBy map[string]string, tableName string) func(tx *gorm.DB) *gorm.DB
• func OrderByFilter(quoteTo func(string) string, orderBy map[string]string, ...) (string, []string, error)
• func Returning(columns ...string) clause.Returning
• func Where(quoteTo func(string) string, query string, args ...interface{}) func(tx *gorm.DB) *gorm.DB
• func WhereFilter(quoteTo func(string) string, expression *ExpressionWhere, ...) (string, []interface{}, []string, error)
• type ExpressionWhere
• type FieldOrderBy
• type FieldSearchable
• type Order
• type Search
• type Type

Constants

const (
	OrderByAsc  string = "ASC"
	OrderByDesc string = "DESC"
)

Variables

var (
	ErrFilterUnknownOperator = apperr.New("filter_unknown_operator", apperr.WithTextTranslate(i18n.ErrFilterUnknownOperator), apperr.WithCode(code.InvalidArgument))
	ErrFilterInvalidOperator = apperr.New("filter_invalid_operator", apperr.WithTextTranslate(i18n.ErrFilterInvalidOperator), apperr.WithCode(code.InvalidArgument))
	ErrFilterUnknownColumn   = apperr.New("filter_unknown_column", apperr.WithTextTranslate(i18n.ErrFilterUnknownColumn), apperr.WithCode(code.InvalidArgument))
	ErrFilterInvalidValue    = apperr.New("filter_invalid_value", apperr.WithTextTranslate(i18n.ErrFilterInvalidValue), apperr.WithCode(code.InvalidArgument))
)

var (
	ErrOrderByUnknownColumn = apperr.New("order_by_unknown_column", apperr.WithTextTranslate(i18n.ErrOrderByUnknownColumn), apperr.WithCode(code.InvalidArgument))
)

Functions

func Limit

func Limit(limit, offset int) func(tx *gorm.DB) *gorm.DB

func OnConflict

func OnConflict(onConflict []interface{}, doUpdates []interface{}) clause.OnConflict

func OrderBy

func OrderBy(quoteTo func(string) string, orderBy map[string]string, tableName string) func(tx *gorm.DB) *gorm.DB

func OrderByFilter

func OrderByFilter(quoteTo func(string) string, orderBy map[string]string, fieldOrderBy FieldOrderBy) (string, []string, error)

func Returning

func Returning(columns ...string) clause.Returning

func Where

func Where(quoteTo func(string) string, query string, args ...interface{}) func(tx *gorm.DB) *gorm.DB

func WhereFilter

func WhereFilter(quoteTo func(string) string, expression *ExpressionWhere, fieldSearchable FieldSearchable) (string, []interface{}, []string, error)

Types

type ExpressionWhere

type ExpressionWhere struct {
	Expressions []ExpressionWhere
	Column      string
	Operation   string
	Value       string
}

type FieldOrderBy

type FieldOrderBy map[string]Order

type FieldSearchable

type FieldSearchable map[string]Search

type Order

type Order struct {
	Column string
	Join   string
}

type Search

type Search struct {
	Column string
	Type   Type
	Join   string
}

type Type

type Type string

const (
	String   Type = "string"
	Int      Type = "int"
	Bool     Type = "bool"
	DateTime Type = "datetime"
)