expr

Documentation

Index

• func Arg(vals ...any) bob.Expression
• func ArgGroup(vals ...any) bob.Expression
• func Not[T bob.Expression, B builder[T]](exp bob.Expression) T
• func OP(operator string, left, right any) bob.Expression
• func Quote(aa ...string) bob.Expression
• func RawQuery(d bob.Dialect, q string, args ...any) bob.BaseQuery[Clause]
• func X[T bob.Expression, B builder[T]](exp bob.Expression, others ...bob.Expression) T
• type Builder
  • func (e Builder[T, B]) And(args ...bob.Expression) T
  • func (e Builder[T, B]) Arg(vals ...any) T
  • func (e Builder[T, B]) ArgGroup(vals ...any) T
  • func (e Builder[T, B]) Group(exps ...bob.Expression) T
  • func (e Builder[T, B]) Not(exp bob.Expression) T
  • func (e Builder[T, B]) Or(args ...bob.Expression) T
  • func (e Builder[T, B]) Placeholder(n uint) T
  • func (e Builder[T, B]) Quote(aa ...string) T
  • func (e Builder[T, B]) Raw(query string, args ...any) T
  • func (e Builder[T, B]) S(s string) T
• type Chain
  • func (x Chain[T, B]) And(targets ...bob.Expression) T
  • func (x Chain[T, B]) As(alias string) bob.Expression
  • func (x Chain[T, B]) Between(a, b bob.Expression) T
  • func (x Chain[T, B]) Concat(targets ...bob.Expression) T
  • func (x Chain[T, B]) EQ(target bob.Expression) T
  • func (x Chain[T, B]) GT(target bob.Expression) T
  • func (x Chain[T, B]) GTE(target bob.Expression) T
  • func (x Chain[T, B]) In(vals ...bob.Expression) T
  • func (x Chain[T, B]) IsDistinctFrom(exp bob.Expression) T
  • func (x Chain[T, B]) IsNotDistinctFrom(exp bob.Expression) T
  • func (x Chain[T, B]) IsNotNull() T
  • func (x Chain[T, B]) IsNull() T
  • func (x Chain[T, B]) LT(target bob.Expression) T
  • func (x Chain[T, B]) LTE(target bob.Expression) T
  • func (x Chain[T, B]) Like(target bob.Expression) T
  • func (x Chain[T, B]) Minus(target bob.Expression) T
  • func (x Chain[T, B]) NE(target bob.Expression) T
  • func (x Chain[T, B]) NotBetween(a, b bob.Expression) T
  • func (x Chain[T, B]) NotIn(vals ...bob.Expression) T
  • func (x Chain[T, B]) OP(op string, target bob.Expression) T
  • func (x Chain[T, B]) Or(targets ...bob.Expression) T
  • func (x Chain[T, B]) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type Clause
  • func (r Clause) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type Join
  • func (s Join) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)
• type Raw
  • func (r Raw) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

Functions

func Arg

func Arg(vals ...any) bob.Expression

func ArgGroup

func ArgGroup(vals ...any) bob.Expression

Like Arg, but wraps in parentheses

func Not

func Not[T bob.Expression, B builder[T]](exp bob.Expression) T

prefix the expression with a NOT

func OP

func OP(operator string, left, right any) bob.Expression

Generic operator between a left and right val

func Quote

func Quote(aa ...string) bob.Expression

func RawQuery

func RawQuery(d bob.Dialect, q string, args ...any) bob.BaseQuery[Clause]

func X

func X[T bob.Expression, B builder[T]](exp bob.Expression, others ...bob.Expression) T

Build an expression

Types

type Builder

type Builder[T bob.Expression, B builder[T]] struct{}

To be embedded in query mods T is the chain type, this allows dialects to have custom chain methods F is function type, so that the dialect can change where it accepted. E.g. it can be modified to work as a mod B has a New() method that is used to create a new instance of T

func (Builder[T, B]) And

func (e Builder[T, B]) And(args ...bob.Expression) T

And

func (Builder[T, B]) Arg

func (e Builder[T, B]) Arg(vals ...any) T

Comma separated list of arguments

func (Builder[T, B]) ArgGroup

func (e Builder[T, B]) ArgGroup(vals ...any) T

Comma separated list of arguments surrounded by parentheses

func (Builder[T, B]) Group

func (e Builder[T, B]) Group(exps ...bob.Expression) T

Add parentheses around an expressions and separate them by commas

func (Builder[T, B]) Not

func (e Builder[T, B]) Not(exp bob.Expression) T

prefix the expression with a NOT

func (Builder[T, B]) Or

func (e Builder[T, B]) Or(args ...bob.Expression) T

Or

func (Builder[T, B]) Placeholder

func (e Builder[T, B]) Placeholder(n uint) T

func (Builder[T, B]) Quote

func (e Builder[T, B]) Quote(aa ...string) T

quoted and joined... something like "users"."id"

func (Builder[T, B]) Raw

func (e Builder[T, B]) Raw(query string, args ...any) T

func (Builder[T, B]) S

func (e Builder[T, B]) S(s string) T

single quoted raw string

type Chain

type Chain[T bob.Expression, B builder[T]] struct {
	Base bob.Expression
}

func (Chain[T, B]) And

func (x Chain[T, B]) And(targets ...bob.Expression) T

AND

func (Chain[T, B]) As

func (x Chain[T, B]) As(alias string) bob.Expression

As does not return a new chain. Should be used at the end of an expression useful for columns

func (Chain[T, B]) Between

func (x Chain[T, B]) Between(a, b bob.Expression) T

BETWEEN a AND b

func (Chain[T, B]) Concat

func (x Chain[T, B]) Concat(targets ...bob.Expression) T

Concatenate: ||

func (Chain[T, B]) EQ

func (x Chain[T, B]) EQ(target bob.Expression) T

Equal

func (Chain[T, B]) GT

func (x Chain[T, B]) GT(target bob.Expression) T

Greater than

func (Chain[T, B]) GTE

func (x Chain[T, B]) GTE(target bob.Expression) T

Greater than or equal to

func (Chain[T, B]) In

func (x Chain[T, B]) In(vals ...bob.Expression) T

IN

func (Chain[T, B]) IsDistinctFrom

func (x Chain[T, B]) IsDistinctFrom(exp bob.Expression) T

IS DISTINCT FROM

func (Chain[T, B]) IsNotDistinctFrom

func (x Chain[T, B]) IsNotDistinctFrom(exp bob.Expression) T

IS NOT DISTINCT FROM

func (Chain[T, B]) IsNotNull

func (x Chain[T, B]) IsNotNull() T

IS NOT NUll

func (Chain[T, B]) IsNull

func (x Chain[T, B]) IsNull() T

IS NUll

func (Chain[T, B]) LT

func (x Chain[T, B]) LT(target bob.Expression) T

Less than

func (Chain[T, B]) LTE

func (x Chain[T, B]) LTE(target bob.Expression) T

Less than or equal to

func (Chain[T, B]) Like

func (x Chain[T, B]) Like(target bob.Expression) T

Like operator

func (Chain[T, B]) Minus

func (x Chain[T, B]) Minus(target bob.Expression) T

Subtract

func (Chain[T, B]) NE

func (x Chain[T, B]) NE(target bob.Expression) T

Not Equal

func (Chain[T, B]) NotBetween

func (x Chain[T, B]) NotBetween(a, b bob.Expression) T

NOT BETWEEN a AND b

func (Chain[T, B]) NotIn

func (x Chain[T, B]) NotIn(vals ...bob.Expression) T

NOT IN

func (Chain[T, B]) OP

func (x Chain[T, B]) OP(op string, target bob.Expression) T

Generic Operator

func (Chain[T, B]) Or

func (x Chain[T, B]) Or(targets ...bob.Expression) T

OR

func (Chain[T, B]) WriteSQL

func (x Chain[T, B]) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

WriteSQL satisfies the bob.Expression interface

type Clause

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

A Raw Clause with arguments

func (Clause) WriteSQL

func (r Clause) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type Join

type Join struct {
	Exprs []bob.Expression
	Sep   string
}

If no separator, a space is used

func (Join) WriteSQL

func (s Join) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)

type Raw

type Raw []byte

func (Raw) WriteSQL

func (r Raw) WriteSQL(w io.Writer, d bob.Dialect, start int) ([]any, error)