where

Documentation

Index

• Constants
• type Where
  • func Between(column string, v1, v2 interface{}) *Where
  • func Eq(column string, value interface{}) *Where
  • func Gt(column string, value interface{}) *Where
  • func Gte(column string, value interface{}) *Where
  • func In(column string, value interface{}) *Where
  • func IsNotNull(column string) *Where
  • func IsNull(column string) *Where
  • func Like(column string, value interface{}) *Where
  • func Lt(column string, value interface{}) *Where
  • func Lte(column string, value interface{}) *Where
  • func Neq(column string, value interface{}) *Where
  • func NotIn(column string, value interface{}) *Where
  • func (w *Where) Build() (string, []interface{})
• type Wheres
  • func New() Wheres
  • func (w Wheres) And(wheres ...*Where) Wheres
  • func (w Wheres) Or(wheres ...*Where) Wheres

Constants

const (
	IN        = "IN"
	NotIN     = "NOT IN"
	BETWEEN   = "BETWEEN"
	LIKE      = "LIKE"
	IsNULL    = "IS NULL"
	IsNotNULL = "IS NOT NULL"
)

Types

type Where

type Where struct {
	Column    string
	Condition string
	V1        interface{}
	V2        interface{}
	Or        bool
}

func Between

func Between(column string, v1, v2 interface{}) *Where

func Eq

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

func Gt

func Gt(column string, value interface{}) *Where

func Gte

func Gte(column string, value interface{}) *Where

func In

func In(column string, value interface{}) *Where

func IsNotNull

func IsNotNull(column string) *Where

func IsNull

func IsNull(column string) *Where

func Like

func Like(column string, value interface{}) *Where

func Lt

func Lt(column string, value interface{}) *Where

func Lte

func Lte(column string, value interface{}) *Where

func Neq

func Neq(column string, value interface{}) *Where

func NotIn

func NotIn(column string, value interface{}) *Where

func (*Where) Build

func (w *Where) Build() (string, []interface{})

type Wheres

type Wheres []*Where

func New

func New() Wheres

func (Wheres) And

func (w Wheres) And(wheres ...*Where) Wheres

func (Wheres) Or

func (w Wheres) Or(wheres ...*Where) Wheres