condition

package
v0.9.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 17, 2024 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Apply

func Apply(sb *sqlbuilder.SelectBuilder, conditions ...Condition)

func ApplyDelete added in v0.5.0

func ApplyDelete(sb *sqlbuilder.DeleteBuilder, conditions ...Condition)

func ApplySelect added in v0.5.0

func ApplySelect(sb *sqlbuilder.SelectBuilder, conditions ...Condition)

func ApplyUpdate added in v0.5.0

func ApplyUpdate(sb *sqlbuilder.UpdateBuilder, conditions ...Condition)

Types

type Chain added in v0.8.0

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

func NewChain added in v0.8.0

func NewChain() Chain

func NewChainWithConditions added in v0.8.0

func NewChainWithConditions(conditions ...Condition) Chain

func (Chain) Between added in v0.8.0

func (c Chain) Between(field string, value any) Chain

func (Chain) Equal added in v0.8.0

func (c Chain) Equal(field string, value any) Chain

func (Chain) GreaterEqualThan added in v0.8.0

func (c Chain) GreaterEqualThan(field string, value any) Chain

func (Chain) GreaterThan added in v0.8.0

func (c Chain) GreaterThan(field string, value any) Chain

func (Chain) In added in v0.8.0

func (c Chain) In(field string, values any) Chain

func (Chain) LessEqualThan added in v0.8.0

func (c Chain) LessEqualThan(field string, value any) Chain

func (Chain) LessThan added in v0.8.0

func (c Chain) LessThan(field string, value any) Chain

func (Chain) Like added in v0.8.0

func (c Chain) Like(field string, value any) Chain

func (Chain) Limit added in v0.8.0

func (c Chain) Limit(value any) Chain

func (Chain) NotEqual added in v0.8.0

func (c Chain) NotEqual(field string, value any) Chain

func (Chain) NotIn added in v0.8.0

func (c Chain) NotIn(field string, value any) Chain

func (Chain) NotLike added in v0.8.0

func (c Chain) NotLike(field string, value any) Chain

func (Chain) Offset added in v0.8.0

func (c Chain) Offset(value any) Chain

func (Chain) Or added in v0.8.0

func (c Chain) Or(fields []string, values []any) Chain

func (Chain) OrderBy added in v0.8.0

func (c Chain) OrderBy(value any) Chain

func (Chain) Page added in v0.8.0

func (c Chain) Page(page, pageSize int) Chain

func (Chain) ToCondition added in v0.8.0

func (c Chain) ToCondition() []Condition

type Condition

type Condition struct {
	Skip     bool
	SkipFunc func() bool

	// or condition
	Or bool

	OrOperators  []Operator
	OrFields     []string
	OrValues     []any
	OrValuesFunc func() []any

	// and condition
	Field string

	Operator  Operator
	Value     any
	ValueFunc func() any
	// contains filtered or unexported fields
}

func New

func New(conditions ...Condition) []Condition

type Operator added in v0.4.0

type Operator string
const (
	Equal            Operator = "="
	NotEqual         Operator = "!="
	GreaterThan      Operator = ">"
	LessThan         Operator = "<"
	GreaterEqualThan Operator = ">="
	LessEqualThan    Operator = "<="
	In               Operator = "IN"
	NotIn            Operator = "NOT IN"
	Like             Operator = "LIKE"
	NotLike          Operator = "NOT LIKE"
	Limit            Operator = "LIMIT"
	Offset           Operator = "OFFSET"
	Between          Operator = "BETWEEN"
	OrderBy          Operator = "ORDER BY"
	GroupBy          Operator = "GROUP BY"
)

func (Operator) String added in v0.4.0

func (o Operator) String() string

Jump to

Keyboard shortcuts

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