expr

Documentation

Index

• Variables
• func And(expr ...string) litsql.Expression
• func AndExpr(expr ...litsql.Expression) litsql.Expression
• func Arg(value any) litsql.Expression
• func ArgDBNamed(name string) litsql.Expression
• func ArgFunc(f func() (any, error)) litsql.Expression
• func ArgNamed(name string) litsql.Expression
• func Args(values []any) []litsql.Expression
• func ArgsDBNamed(names ...string) []litsql.Expression
• func ArgsFunc(fs []func() (any, error)) []litsql.Expression
• func ArgsNamed(names ...string) []litsql.Expression
• func CastSlice[E litsql.Expression](list []E) []litsql.Expression
• func Clause(query string, args ...any) litsql.Expression
• func Func(f func() (litsql.Expression, error)) litsql.Expression
• func If(condition bool, e litsql.Expression) litsql.Expression
• func IfElse(condition bool, etrue, efalse litsql.Expression) litsql.Expression
• func In(values []any) litsql.Expression
• func InP(values []any) litsql.Expression
• func InPT[T any](values []T) litsql.Expression
• func InT[T any](values []T) litsql.Expression
• func Join(exprs ...litsql.Expression) litsql.Expression
• func JoinSep(sep string, exprs ...litsql.Expression) litsql.Expression
• func MapSlice[T any](source []T, mapFunc func(T) litsql.Expression) []litsql.Expression
• func Or(expr ...string) litsql.Expression
• func OrExpr(expr ...litsql.Expression) litsql.Expression
• func Paren(expr ...string) litsql.Expression
• func ParenExpr(expr ...litsql.Expression) litsql.Expression
• func PrefixIf(condition bool, prefix litsql.Expression, e litsql.Expression) litsql.Expression
• func Quote(aa ...string) litsql.Expression
• func QuoteCheck(aa ...string) litsql.Expression
• func String(str string) litsql.Expression
• func StringList(str []string) []litsql.Expression
• func StringListQuote(str []string) []litsql.Expression
• func StringListQuoteCheck(str []string) []litsql.Expression
• func StringQuote(str string) litsql.Expression
• func StringQuoteCheck(str string) litsql.Expression
• func WriterAddSeparator(topLevel bool) litsql.Expression
• type Raw
  • func (r Raw) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

Variables

var (
	Space      = Raw(internal.Space)
	CommaSpace = Raw(internal.CommaSpace)
	NewLine    = Raw(internal.NewLine)
	OpenPar    = Raw(internal.OpenPar)
	ClosePar   = Raw(internal.ClosePar)

	CommaWriterNewLine   = Join(Raw(internal.Comma), WriterNewLine)
	CommaWriterSeparator = Join(Raw(internal.Comma), WriterSeparator)
)

var ErrNoNamedArgs = errors.New("Dialect does not support named arguments")

var WriterNewLine = litsql.ExpressionFunc(func(w litsql.Writer, d litsql.Dialect, start int) ([]any, error) {
	w.WriteNewLine()
	return nil, nil
})

WriterNewLine calls litsql.Writer.WriteNewline.

var WriterSeparator = litsql.ExpressionFunc(func(w litsql.Writer, d litsql.Dialect, start int) ([]any, error) {
	w.WriteSeparator()
	return nil, nil
})

WriterSeparator calls litsql.Writer.WriteSeparator.

Functions

func And

func And(expr ...string) litsql.Expression

And outputs the list of expressions separated by " AND ".

func AndExpr

func AndExpr(expr ...litsql.Expression) litsql.Expression

AndExpr outputs the list of expressions separated by " AND ".

func Arg

func Arg(value any) litsql.Expression

Arg outputs the dialect-specific argument matcher, and wraps the passed value.

func ArgDBNamed

func ArgDBNamed(name string) litsql.Expression

ArgDBNamed outputs the dialect-specific argument matcher, and wraps the passed value as a named argument.

func ArgFunc

func ArgFunc(f func() (any, error)) litsql.Expression

ArgFunc returns the argument value in a callback.

func ArgNamed

func ArgNamed(name string) litsql.Expression

ArgNamed outputs the dialect-specific argument matcher, and wraps the passed value as a named argument.

func Args

func Args(values []any) []litsql.Expression

Args wraps multiple values in a slice of Arg.

func ArgsDBNamed

func ArgsDBNamed(names ...string) []litsql.Expression

ArgsDBNamed wraps multiple values in a slice of ArgDBNamed.

func ArgsFunc

func ArgsFunc(fs []func() (any, error)) []litsql.Expression

ArgsFunc wraps multiple values in a slice of ArgFunc.

func ArgsNamed

func ArgsNamed(names ...string) []litsql.Expression

ArgsNamed wraps multiple values in a slice of ArgNamed.

func CastSlice

func CastSlice[E litsql.Expression](list []E) []litsql.Expression

CastSlice converts a slice of Expression-implemented items to a slice of litsql.Expression.

func Clause

func Clause(query string, args ...any) litsql.Expression

Clause parses the query, replacing any "?" with the dialect-specific argument matcher, and wraps the passed arguments. If the argument is a litsql.Expression, it will be output in-place.

func Func

func Func(f func() (litsql.Expression, error)) litsql.Expression

Func calls the function to return the expression to output.

func If

func If(condition bool, e litsql.Expression) litsql.Expression

If returns "e" if condition == true, nil otherwise.

func IfElse

func IfElse(condition bool, etrue, efalse litsql.Expression) litsql.Expression

IfElse returns "etrue" if condition == true, "efalse" otherwise.

func In

func In(values []any) litsql.Expression

In outputs the list of values as Arg separated by commas.

func InP

func InP(values []any) litsql.Expression

InP outputs the list of values as Arg separated by commas, wrapped in parentheses.

func InPT

func InPT[T any](values []T) litsql.Expression

InPT outputs the list of values as Arg separated by commas, wrapped in parentheses.

func InT

func InT[T any](values []T) litsql.Expression

InT outputs the list of values as Arg separated by commas.

func Join

func Join(exprs ...litsql.Expression) litsql.Expression

Join combines a list of litsql.Expression in a single expression, without a separator.

func JoinSep

func JoinSep(sep string, exprs ...litsql.Expression) litsql.Expression

JoinSep combines a list of litsql.Expression in a single expression, using the passed separator.

func MapSlice

func MapSlice[T any](source []T, mapFunc func(T) litsql.Expression) []litsql.Expression

MapSlice converts a slice of data to a slice of litsql.Expression using a map function.

func Or

func Or(expr ...string) litsql.Expression

Or outputs the list of expressions separated by " OR ".

func OrExpr

func OrExpr(expr ...litsql.Expression) litsql.Expression

OrExpr outputs the list of expressions separated by " OR ".

func Paren

func Paren(expr ...string) litsql.Expression

Paren returns an expression what outputs the list of expressions comma-separated with parenthesis around.

func ParenExpr

func ParenExpr(expr ...litsql.Expression) litsql.Expression

ParenExpr returns an expression what outputs the list of expressions comma-separated with parenthesis around.

func PrefixIf

func PrefixIf(condition bool, prefix litsql.Expression, e litsql.Expression) litsql.Expression

PrefixIf returns an expression with the passed prefix if condition == true, only the expression if false.

func Quote

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

Quote outputs quoted and joined, something like "users"."id".

func QuoteCheck

func QuoteCheck(aa ...string) litsql.Expression

QuoteCheck outputs quoted and joined, something like "users"."id", only if each string needs to be quoted.

func String

func String(str string) litsql.Expression

String returns a raw string expression.

func StringList

func StringList(str []string) []litsql.Expression

StringList converts a slice of strings to a slice of raw string expressions.

func StringListQuote

func StringListQuote(str []string) []litsql.Expression

StringListQuote converts a slice of strings to a slice of quoted raw string expressions.

func StringListQuoteCheck

func StringListQuoteCheck(str []string) []litsql.Expression

StringListQuoteCheck converts a slice of strings to a slice of checked quoted raw string expressions.

func StringQuote

func StringQuote(str string) litsql.Expression

StringQuote returns a quoted string expression.

func StringQuoteCheck

func StringQuoteCheck(str string) litsql.Expression

StringQuoteCheck returns a checked quoted string expression (only quote if needed).

func WriterAddSeparator

func WriterAddSeparator(topLevel bool) litsql.Expression

WriterAddSeparator calls litsql.Writer.AddSeparator.

Types

type Raw

type Raw string

Raw is an litsql.Expression that outputs the string itself as-is.

func (Raw) WriteSQL

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