superbasic

Sep 15, 2022

Changes in this version

+ type Caser struct

+ Then Expression

+ Value T

+ func Case(value T, then Expression) Caser[T]

type Expression

+ func Switch(value T, cases ...Caser[T]) Expression

Sep 2, 2022

Changes in this version

+ func Map(from []From, mapper func(From) To) []To

Sep 2, 2022

Changes in this version

+ func Replace(placeholder string, sql string) (string, int)

type Error

+ Err error

+ func (e Error) Error() string

+ func (e Error) ToSQL() (string, []any, error)

+ func (e Error) Unwrap() error

type ExpressionError

+ Position int

type NumberOfArgumentsError

+ Arguments int

+ Placeholders int

+ SQL string

Aug 11, 2022

Changes in this version

+ func Finalize(placeholder string, expr Expression) (string, []any, error)

type Expression

+ func Slice(s []T) []Expression

+ type ExpressionIndexError struct

+ Index int

+ func (e ExpressionIndexError) Error() string

Aug 6, 2022

Changes in this version

+ type Compiler struct

+ Expressions []any

+ Template string

+ func (c Compiler) ToSQL() (string, []any, error)

+ type Joiner struct

+ Expressions []Expression

+ Sep string

+ func (j Joiner) ToSQL() (string, []any, error)

Aug 6, 2022

Changes in this version

type Append

+ func (b Append) ToSQL() (string, []any, error)

type Builder

+ func Build() *Builder

+ func (b *Builder) Append(expressions ...Expression) *Builder

+ func (b *Builder) If(condition bool, then Expression) *Builder

+ func (b *Builder) IfElse(condition bool, then Expression, els Expression) *Builder

+ func (b *Builder) Join(sep string, expressions ...Expression) *Builder

+ func (b *Builder) SQL(sql string, args ...any) *Builder

+ func (b *Builder) Space() *Builder

type Join

+ Expressions []Expression

+ Sep string

+ func (j Join) ToSQL() (string, []any, error)

+ type Raw struct

+ Args []any

+ Err error

+ SQL string

+ func (e Raw) ToSQL() (string, []any, error)

Aug 6, 2022

Changes in this version

type Expr

+ Args []any

+ Err error

+ SQL string

type ExpressionError

+ Err error

+ func (e ExpressionError) Unwrap() error

type NumberOfArgumentsError

+ Got int

+ Want int

type Query

+ Window Expression

+ With Expression

Aug 3, 2022

Changes in this version

type Insert

+ Data [][]any

type Update

+ Sets []Expression

Jul 31, 2022

Changes in this version

type DeleteBuilder

+ func (db *DeleteBuilder) WhereExpr(expr Expression) *DeleteBuilder

type InsertBuilder

+ func (ib *InsertBuilder) Values(values ...any) *InsertBuilder

type SelectBuilder

+ func SelectExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) FromExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) GroupByExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) HavingExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) OrderByExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) Select(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) SelectExpr(expr Expression) *SelectBuilder

+ func (sb *SelectBuilder) WhereExpr(expr Expression) *SelectBuilder

type UpdateBuilder

+ func (ub *UpdateBuilder) Set(sql string, args ...any) *UpdateBuilder

+ func (ub *UpdateBuilder) SetExpr(set Expression) *UpdateBuilder

+ func (ub *UpdateBuilder) WhereExpr(expr Expression) *UpdateBuilder

Jul 29, 2022

Changes in this version

+ type DeleteBuilder struct

+ func (db *DeleteBuilder) ToSQL() (string, []any, error)

+ func (db *DeleteBuilder) Where(expr any) *DeleteBuilder

+ func (db *DeleteBuilder) WhereSQL(sql string, args ...any) *DeleteBuilder

+ type InsertBuilder struct

+ func (ib *InsertBuilder) AddRow(values ...any) *InsertBuilder

+ func (ib *InsertBuilder) Columns(columns ...string) *InsertBuilder

+ func (ib *InsertBuilder) ToSQL() (string, []any, error)

+ type SelectBuilder struct

+ func SelectSQL(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) From(expr any) *SelectBuilder

+ func (sb *SelectBuilder) FromSQL(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) GroupBy(expr any) *SelectBuilder

+ func (sb *SelectBuilder) GroupBySQL(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) Having(expr any) *SelectBuilder

+ func (sb *SelectBuilder) HavingSQL(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) Limit(limit uint64) *SelectBuilder

+ func (sb *SelectBuilder) Offset(offset uint64) *SelectBuilder

+ func (sb *SelectBuilder) OrderBy(expr any) *SelectBuilder

+ func (sb *SelectBuilder) OrderBySQL(sql string, args ...any) *SelectBuilder

+ func (sb *SelectBuilder) ToSQL() (string, []any, error)

+ func (sb *SelectBuilder) Where(expr any) *SelectBuilder

+ func (sb *SelectBuilder) WhereSQL(sql string, args ...any) *SelectBuilder

+ type UpdateBuilder struct

+ func (ub *UpdateBuilder) AddSet(set any) *UpdateBuilder

+ func (ub *UpdateBuilder) AddSetSQL(sql string, args ...any) *UpdateBuilder

+ func (ub *UpdateBuilder) ToSQL() (string, []any, error)

+ func (ub *UpdateBuilder) Where(expr any) *UpdateBuilder

+ func (ub *UpdateBuilder) WhereSQL(sql string, args ...any) *UpdateBuilder

Jul 28, 2022

Changes in this version

type Expression

+ func BetweenIdent(ident string, lower, higher any) Expression

+ func CastIdent(ident string, as string) Expression

+ func EqualsIdent(ident string, value any) Expression

+ func GreaterIdent(ident string, value any) Expression

+ func GreaterOrEqualsIdent(ident string, value any) Expression

+ func InIdent(ident string, value any) Expression

+ func IsNotNullIdent(ident string) Expression

+ func IsNullIdent(ident string) Expression

+ func LessIdent(ident string, value any) Expression

+ func LessOrEqualsIdent(ident string, value any) Expression

+ func LikeIdent(ident string, value any) Expression

+ func NotBetweenIdent(ident string, lower, higher any) Expression

+ func NotEqualsIdent(ident string, value any) Expression

+ func NotInIdent(ident string, value any) Expression

+ func NotLikeIdent(ident string, value any) Expression

Jul 28, 2022

Changes in this version

type Expression

+ func Between(ident string, lower, higher any) Expression

+ func Cast(value any, as string) Expression

+ func IsNotNull(ident string) Expression

+ func IsNull(ident string) Expression

+ func Like(ident string, value any) Expression

+ func NotBetween(ident string, lower, higher any) Expression

+ func NotIn(ident string, values ...any) Expression

+ func NotLike(ident string, value any) Expression

Jul 28, 2022

Changes in this version

+ func ToPositional(placeholder string, expr Expression) (string, []any, error)

+ type ExpressionError struct

+ func (e ExpressionError) Error() string

+ func (e ExpressionError) ToSQL() (string, []any, error)

+ type NumberOfArgumentsError struct

+ func (e NumberOfArgumentsError) Error() string

+ func (e NumberOfArgumentsError) ToSQL() (string, []any, error)

Jul 28, 2022

Changes in this version

type Expression

+ func Compile(template string, expressions ...Sqlizer) Expression

+ func Idents(idents ...string) Expression

+ func In(ident string, values ...any) Expression

+ func Value(a any) Expression

+ func (e Expression) ToPositional(placeholder string) (string, []any, error)

Jul 27, 2022

Changes in this version

+ var ErrInvalidExpression = errors.New("invalid expression")

Jul 26, 2022

Changes in this version

+ type Columns []string

+ func (i Columns) ToSQL() (string, []any, error)

type Values

+ func (v Values) ToSQL() (string, []any, error)

Jul 26, 2022

Changes in this version

type Expression

+ func And(expr ...Sqlizer) Expression

+ func Equals(ident string, value any) Expression

+ func Greater(ident string, value any) Expression

+ func GreaterOrEquals(ident string, value any) Expression

+ func Less(ident string, value any) Expression

+ func LessOrEquals(ident string, value any) Expression

+ func Not(expr Sqlizer) Expression

+ func NotEquals(ident string, value any) Expression

+ func Or(left, right Sqlizer) Expression

+ type Query struct

+ From any

+ GroupBy any

+ Having any

+ Limit uint64

+ Offset uint64

+ OrderBy any

+ Select any

+ Where any

+ func (q Query) ToSQL() (string, []any, error)

Jul 26, 2022

Changes in this version

+ func ToDDL(expr any) (string, error)

+ func ToSQL(expr any) (string, []any, error)

+ type Builder struct

+ func NewBuilder() *Builder

+ func (b *Builder) ToSQL() (string, []any, error)

+ func (b *Builder) Write(expr any) *Builder

+ func (b *Builder) WriteSQL(sql string, args ...any) *Builder

type Column

+ func (cs Column) ToSQL() (string, []any, error)

type Expression

+ func ToExpression(expr any) (Expression, bool)

type Table

+ func (ct Table) ToSQL() (string, []any, error)

Jul 24, 2022

Changes in this version

type Expression

+ func IfElse(condition bool, then any, els any) Expression

Jul 24, 2022

Changes in this version

+ type Column struct

+ Constraints []ExprDDL

+ Name string

+ Type string

+ func (cs Column) ToDDL() (string, error)

+ type Delete struct

+ From string

+ Where Expr

+ func (d Delete) ToSQL() (string, []any, error)

type Expr

+ ToSQL func() (string, []any, error)

+ type ExprDDL interface

+ ToDDL func() (string, error)

type Expression

+ func Values(data ...[]any) Expression

+ func (e Expression) ToDDL() (string, error)

+ type Insert struct

+ Columns []string

+ Into string

+ Values [][]any

+ func (i Insert) ToSQL() (string, []any, error)

+ type Select struct

+ Columns []Expr

+ Distinct bool

+ From []Expr

+ GroupBy []Expr

+ Having Expr

+ Joins []Expr

+ Limit uint64

+ Offset uint64

+ OrderBy []Expr

+ Where Expr

+ func (s Select) ToSQL() (string, []any, error)

+ type Table struct

+ Columns []ExprDDL

+ Constraints []ExprDDL

+ IfNotExists bool

+ Name string

+ func (ct Table) ToDDL() (string, error)

+ type Update struct

+ Set []Expr

+ Table string

+ Where Expr

+ func (u Update) ToSQL() (string, []any, error)

Jul 24, 2022

Changes in this version

type Expression

+ func Error(err error) Expression

Jul 24, 2022

Changes in this version

+ var ErrInvalidNumberOfArguments = errors.New("invalid number of arguments")

+ func ToPostgres(expr any) (string, []any, error)

+ type Expr interface

+ Expression func() Expression

+ type Expression struct

+ Args []any

+ Err error

+ SQL string

+ func Append(expr ...any) Expression

+ func If(condition bool, then any, els any) Expression

+ func Join(sep string, expr ...any) Expression

+ func SQL(sql string, args ...any) Expression

+ func Skip() Expression

+ func (e Expression) ToSQL() (string, []any, error)

+ type Sqlizer interface

+ ToSQL func() (string, []any, error)