xsql

May 30, 2024

Changes in this version

+ type HasQueryParams interface

+ QueryParams func() QueryParams

+ type QueryParams interface

+ Args func() []any

+ GetEnum func(pos uint32) (int32, bool)

+ GetFlags func() []int32

+ IsSet func(pos uint32) bool

+ Name func() string

+ func GetQueryParams(args ...any) QueryParams

+ type QueryParamsBuilder struct

+ func NewQueryParams(queryName string) *QueryParamsBuilder

+ func (b *QueryParamsBuilder) AddArgs(v ...any)

+ func (b *QueryParamsBuilder) Args() []any

+ func (b *QueryParamsBuilder) GetEnum(pos uint32) (int32, bool)

+ func (b *QueryParamsBuilder) GetFlags() []int32

+ func (b *QueryParamsBuilder) IsSet(pos uint32) bool

+ func (b *QueryParamsBuilder) Name() string

+ func (b *QueryParamsBuilder) Reset()

+ func (b *QueryParamsBuilder) Set(pos uint32, v any)

+ func (b *QueryParamsBuilder) SetEnum(pos uint32, v int32)

+ func (b *QueryParamsBuilder) SetFlags(v ...int32)

Dec 19, 2023

Changes in this version

type Dialect

+ func (d *Dialect) GetOrCreateQuery(name string, create func(name string) Builder) string

type SQLDialect

+ GetOrCreateQuery func(name string, create func(name string) Builder) string

Nov 26, 2023

Changes in this version

type Builder

+ UseNewLines func(op bool) Builder

type Dialect

+ func (b *Dialect) UseNewLines(op bool)

type SQLDialect

+ func UseNewLines(op bool) SQLDialect

+ UseNewLines func(op bool)

type Stmt

+ func (q *Stmt) UseNewLines(op bool) Builder

Nov 18, 2023

Changes in this version

type Dialect

+ func (d *Dialect) PutCachedQuery(name, sql string)

type SQLDialect

+ PutCachedQuery func(name, query string)

Nov 17, 2023

Changes in this version

+ var NoDialect = &Dialect

+ var Postgres = &Dialect

+ var SQLServer = &Dialect

+ func SetDialect(newDefaultDialect *Dialect)

+ type Builder interface

+ Args func() []any

+ Bind func(data any) Builder

+ Clause func(expr string, args ...any) Builder

+ Clone func() Builder

+ Close func()

+ DeleteFrom func(tableName string) Builder

+ Dest func() []any

+ Exec func(ctx context.Context, db Executor) (sql.Result, error)

+ ExecAndClose func(ctx context.Context, db Executor) (sql.Result, error)

+ Expr func(expr string, args ...any) Builder

+ From func(expr string, args ...any) Builder

+ FullJoin func(table string, on string) Builder

+ GroupBy func(expr string) Builder

+ Having func(expr string, args ...any) Builder

+ In func(args ...any) Builder

+ InsertInto func(tableName string) Builder

+ Invalidate func()

+ Join func(table string, on string) Builder

+ LeftJoin func(table string, on string) Builder

+ Limit func(limit any) Builder

+ Name func() string

+ NewRow func() Row

+ Offset func(offset any) Builder

+ OrderBy func(expr ...string) Builder

+ Paginate func(page int, pageSize int) Builder

+ Query func(ctx context.Context, db Executor, handler func(rows *sql.Rows)) error

+ QueryAndClose func(ctx context.Context, db Executor, handler func(rows *sql.Rows)) error

+ QueryRow func(ctx context.Context, db Executor) error

+ QueryRowAndClose func(ctx context.Context, db Executor) error

+ Returning func(expr string) Builder

+ RightJoin func(table string, on string) Builder

+ Select func(expr string, args ...any) Builder

+ Set func(field string, value any) Builder

+ SetExpr func(field string, expr string, args ...any) Builder

+ SetName func(name string) Builder

+ String func() string

+ SubQuery func(prefix string, suffix string, query Builder) Builder

+ To func(dest ...any) Builder

+ Union func(all bool, query Builder) Builder

+ Update func(tableName string) Builder

+ Where func(expr string, args ...any) Builder

+ With func(queryName string, query Builder) Builder

+ func DeleteFrom(tableName string) Builder

+ func From(expr string, args ...any) Builder

+ func InsertInto(tableName string) Builder

+ func New(verb string, args ...any) Builder

+ func Select(expr string, args ...any) Builder

+ func Update(tableName string) Builder

+ func With(queryName string, query Builder) Builder

+ type Dialect struct

+ func (b *Dialect) DeleteFrom(tableName string) Builder

+ func (b *Dialect) From(expr string, args ...any) Builder

+ func (b *Dialect) InsertInto(tableName string) Builder

+ func (b *Dialect) New(verb string, args ...any) Builder

+ func (b *Dialect) Provider() string

+ func (b *Dialect) Select(expr string, args ...any) Builder

+ func (b *Dialect) Update(tableName string) Builder

+ func (b *Dialect) With(queryName string, query Builder) Builder

+ func (d *Dialect) ClearCache()

+ func (d *Dialect) GetCachedQuery(name string) (string, bool)

+ type Executor interface

+ ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row

+ type Row interface

+ Set func(field string, value any) Row

+ SetExpr func(field string, expr string, args ...any) Row

+ type SQLDialect interface

+ ClearCache func()

+ DeleteFrom func(tableName string) Builder

+ From func(expr string, args ...any) Builder

+ GetCachedQuery func(name string) (string, bool)

+ InsertInto func(tableName string) Builder

+ New func(verb string, args ...any) Builder

+ Provider func() string

+ Select func(expr string, args ...any) Builder

+ Update func(tableName string) Builder

+ With func(queryName string, query Builder) Builder

+ type Stmt struct

+ func (q *Stmt) Args() []any

+ func (q *Stmt) Bind(data any) Builder

+ func (q *Stmt) Clause(expr string, args ...any) Builder

+ func (q *Stmt) Clone() Builder

+ func (q *Stmt) Close()

+ func (q *Stmt) DeleteFrom(tableName string) Builder

+ func (q *Stmt) Dest() []any

+ func (q *Stmt) Exec(ctx context.Context, db Executor) (sql.Result, error)

+ func (q *Stmt) ExecAndClose(ctx context.Context, db Executor) (sql.Result, error)

+ func (q *Stmt) Expr(expr string, args ...any) Builder

+ func (q *Stmt) From(expr string, args ...any) Builder

+ func (q *Stmt) FullJoin(table, on string) Builder

+ func (q *Stmt) GroupBy(expr string) Builder

+ func (q *Stmt) Having(expr string, args ...any) Builder

+ func (q *Stmt) In(args ...any) Builder

+ func (q *Stmt) InsertInto(tableName string) Builder

+ func (q *Stmt) Invalidate()

+ func (q *Stmt) Join(table, on string) Builder

+ func (q *Stmt) LeftJoin(table, on string) Builder

+ func (q *Stmt) Limit(limit any) Builder

+ func (q *Stmt) Name() string

+ func (q *Stmt) NewRow() Row

+ func (q *Stmt) Offset(offset any) Builder

+ func (q *Stmt) OrderBy(expr ...string) Builder

+ func (q *Stmt) Paginate(page, pageSize int) Builder

+ func (q *Stmt) Query(ctx context.Context, db Executor, handler func(rows *sql.Rows)) error

+ func (q *Stmt) QueryAndClose(ctx context.Context, db Executor, handler func(rows *sql.Rows)) error

+ func (q *Stmt) QueryRow(ctx context.Context, db Executor) error

+ func (q *Stmt) QueryRowAndClose(ctx context.Context, db Executor) error

+ func (q *Stmt) Returning(expr string) Builder

+ func (q *Stmt) RightJoin(table, on string) Builder

+ func (q *Stmt) Select(expr string, args ...any) Builder

+ func (q *Stmt) Set(field string, value any) Builder

+ func (q *Stmt) SetExpr(field, expr string, args ...any) Builder

+ func (q *Stmt) SetName(name string) Builder

+ func (q *Stmt) String() string

+ func (q *Stmt) SubQuery(prefix, suffix string, b Builder) Builder

+ func (q *Stmt) To(dest ...any) Builder

+ func (q *Stmt) Union(all bool, b Builder) Builder

+ func (q *Stmt) Update(tableName string) Builder

+ func (q *Stmt) Where(expr string, args ...any) Builder

+ func (q *Stmt) With(queryName string, query Builder) Builder

+ func (q *Stmt) WriteString(s string)