sq

Documentation

Index

• func ArgFunc(fn func() (any, error)) litsql.Argument
• func Build(q litsql.Query, options ...BuildQueryOption) (string, []any, error)
• func DBNamedArg(name string, options ...ArgOption) litsql.Argument
• func NamedArg(name string, options ...ArgOption) litsql.Argument
• func NewWriter(w io.Writer, options ...WriterOption) litsql.Writer
• func ParseArgValues(args []any, values litsql.ArgValues) ([]any, error)
• func ParseArgs(args []any, values any) ([]any, error)
• type ArgOption
  • func WithDefaultValue(defaultValue any) ArgOption
• type BuildQuery
• type BuildQueryOption
  • func WithBuildParseArgValues(argValues litsql.ArgValues) BuildQueryOption
  • func WithBuildParseArgs(argValues any) BuildQueryOption
  • func WithBuildWriterOptions(writerOptions ...WriterOption) BuildQueryOption
• type Builder
  • func NewQueryBuilder(d litsql.Dialect) *Builder
  • func (s *Builder) AddQueryClause(q litsql.QueryClause)
  • func (s *Builder) Dialect() litsql.Dialect
  • func (s *Builder) QueryClauseList() ([]litsql.QueryClause, error)
• type Mod
• type ModTag
• type ModTagImpl
• type Query
• type QueryMod
  • func QueryModFunc[T any](f func(apply litsql.QueryBuilder)) QueryMod[T]
• type QueryModApply
• type WriterOption
  • func WithWriterIndentStr(indentStr string) WriterOption
  • func WithWriterUseNewLine(useNewLine bool) WriterOption

Functions

func ArgFunc

func ArgFunc(fn func() (any, error)) litsql.Argument

ArgFunc returns the argument value in a callback.

func Build

func Build(q litsql.Query, options ...BuildQueryOption) (string, []any, error)

Build builds a query string and its arguments.

func DBNamedArg

func DBNamedArg(name string, options ...ArgOption) litsql.Argument

DBNamedArg adds a DB-native named argument (for databases that support it). The end value will be wrapped in [sql.Named].

func NamedArg

func NamedArg(name string, options ...ArgOption) litsql.Argument

NamedArg adds a named argument for replacement with ParseArgs.

func NewWriter

func NewWriter(w io.Writer, options ...WriterOption) litsql.Writer

NewWriter creates the default implementation if litsql.Writer.

func ParseArgValues

func ParseArgValues(args []any, values litsql.ArgValues) ([]any, error)

ParseArgValues replaces all litsql.Argument instances in args with named values.

func ParseArgs

func ParseArgs(args []any, values any) ([]any, error)

ParseArgs replaces all litsql.Argument instances in args with named values.

Types

type ArgOption

type ArgOption func(options *argOptions)

func WithDefaultValue

func WithDefaultValue(defaultValue any) ArgOption

WithDefaultValue sets a default value if the argument name was not passed.

type BuildQuery

type BuildQuery interface {
	Build(options ...BuildQueryOption) (string, []any, error)
}

BuildQuery builds query strings and arguments.

type BuildQueryOption

type BuildQueryOption = internal.BuildQueryOption

func WithBuildParseArgValues

func WithBuildParseArgValues(argValues litsql.ArgValues) BuildQueryOption

WithBuildParseArgValues adds named argument values.

func WithBuildParseArgs

func WithBuildParseArgs(argValues any) BuildQueryOption

WithBuildParseArgs adds named argument values.

func WithBuildWriterOptions

func WithBuildWriterOptions(writerOptions ...WriterOption) BuildQueryOption

WithBuildWriterOptions adds writer options.

type Builder

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

Builder implements litsql.QueryBuilder.

func NewQueryBuilder

func NewQueryBuilder(d litsql.Dialect) *Builder

func (*Builder) AddQueryClause

func (s *Builder) AddQueryClause(q litsql.QueryClause)

func (*Builder) Dialect

func (s *Builder) Dialect() litsql.Dialect

func (*Builder) QueryClauseList

func (s *Builder) QueryClauseList() ([]litsql.QueryClause, error)

type Mod

type Mod[T, A any] interface {
	ModTag[T]
	Apply(A)
}

Mod is a mod for a generic type.

type ModTag

type ModTag[T any] interface {
	// contains filtered or unexported methods
}

ModTag is used just for interface tagging, so implementations for each dialect aren't accept on others.

type ModTagImpl

type ModTagImpl[T any] struct {
}

type Query

type Query[T any] interface {
	litsql.QueryBuilder
	litsql.Query
	QueryModApply[T]
	BuildQuery
}

Query is the interface for base queries.

type QueryMod

type QueryMod[T any] interface {
	ModTag[T]
	Apply(qb litsql.QueryBuilder)
}

QueryMod is a mod for litsql.QueryBuilder.

func QueryModFunc

func QueryModFunc[T any](f func(apply litsql.QueryBuilder)) QueryMod[T]

type QueryModApply

type QueryModApply[T any] interface {
	Apply(...QueryMod[T])
}

type WriterOption

type WriterOption = internal.WriterOption

func WithWriterIndentStr

func WithWriterIndentStr(indentStr string) WriterOption

WithWriterIndentStr sets the indent string (used only if WithWriterUseNewLine is true). Default is " " (two spaces).

func WithWriterUseNewLine

func WithWriterUseNewLine(useNewLine bool) WriterOption

WithWriterUseNewLine sets whether to use newlines in the output or not. Default is true.