where

Documentation

Index

• type Where
  • func AND(where *Where) *Where
  • func BETWEEN(column string, from, to any) *Where
  • func EQ(column string, value any, ignore ...any) *Where
  • func FUZZ(column string, value string, escape ...bool) *Where
  • func GT(column string, value any, ignore ...any) *Where
  • func GTE(column string, value any, ignore ...any) *Where
  • func IN(column string, values ...any) *Where
  • func LIKE(column string, value string, escape ...bool) *Where
  • func LT(column string, value any, ignore ...any) *Where
  • func LTE(column string, value any, ignore ...any) *Where
  • func NBETWEEN(column string, from, to any) *Where
  • func NEQ(column string, value any, ignore ...any) *Where
  • func NIN(column string, values ...any) *Where
  • func OR(where *Where) *Where
  • func (own *Where) AND(where *Where) *Where
  • func (own *Where) Clone() *Where
  • func (own *Where) IsEmpty() bool
  • func (own *Where) OR(where *Where) *Where
  • func (own *Where) String() string

Types

type Where

type Where struct {
	Dest []byte
	Args []any
}

func AND

func AND(where *Where) *Where

func BETWEEN

func BETWEEN(column string, from, to any) *Where

BETWEEN 范围匹配：BETWEEN 1 AND 100

func EQ

func EQ(column string, value any, ignore ...any) *Where

EQ 等于：column = value

func FUZZ

func FUZZ(column string, value string, escape ...bool) *Where

FUZZ 完全模糊匹配：LIKE "a" ===> LIKE "%a%"

func GT

func GT(column string, value any, ignore ...any) *Where

GT 大于：column > value

func GTE

func GTE(column string, value any, ignore ...any) *Where

GTE 大于等于：column >= value

func IN

func IN(column string, values ...any) *Where

IN 枚举匹配：IN (1, 2, 3, 4)

func LIKE

func LIKE(column string, value string, escape ...bool) *Where

LIKE 模糊匹配：LIKE "a"，LIKE "%a"，LIKE "a%"，LIKE "%a%"

func LT

func LT(column string, value any, ignore ...any) *Where

GTE 小于：column < value

func LTE

func LTE(column string, value any, ignore ...any) *Where

GTE 小于等于：column <= value

func NBETWEEN

func NBETWEEN(column string, from, to any) *Where

NBETWEEN 不在匹配范围中：NOT BETWEEN 1 AND 100

func NEQ

func NEQ(column string, value any, ignore ...any) *Where

NEQ 不等于：column != value

func NIN

func NIN(column string, values ...any) *Where

NIN 不在枚举范围中：NOT IN (1, 2, 3, 4)

func OR

func OR(where *Where) *Where

func (*Where) AND

func (own *Where) AND(where *Where) *Where

func (*Where) Clone

func (own *Where) Clone() *Where

func (*Where) IsEmpty

func (own *Where) IsEmpty() bool

func (*Where) OR

func (own *Where) OR(where *Where) *Where

func (*Where) String

func (own *Where) String() string