Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

xsql

package

Go to main page

Versions in this module

v1

v1.0.11

Mar 3, 2023

v1.0.10

Mar 2, 2023

v1.0.9

Feb 28, 2023

Changes in this version

type Selector

+ func (s *Selector) SelectedColumns() []string

v1.0.8

Mar 6, 2022

v1.0.7

Feb 28, 2022

v1.0.6

Feb 18, 2022

v1.0.5

Feb 16, 2022

v1.0.4

Feb 13, 2022

Changes in this version

+ func Shrink(ctx context.Context, duration time.Duration) (time.Duration, context.Context, context.CancelFunc)

+ type Config struct

+ Active int

+ DSN string

+ ExecTimeout time.Duration

+ Idle int

+ IdleTimeout time.Duration

+ QueryTimeout time.Duration

+ ReadDSN []string

+ type DB struct

+ func NewMySQL(c *Config) (*DB, error)

+ func (db *DB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ func (db *DB) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (db *DB) Master() *sql.DB

+ func (db *DB) PingContext(ctx context.Context) error

+ func (db *DB) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ type DBI interface

+ Begin func() (*sql.Tx, error)

+ BeginTx func(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

type DebugDB

+ func (d *DebugDB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*DebugTx, error)

+ type Logger interface

+ Printf func(format string, v ...interface{})

type Op

+ func VailedOp(op string) (vailed bool, t Op)

type Predicate

+ func GenP(field, op, value string) (*Predicate, error)

v1.0.3

Jan 19, 2022

v1.0.2

Jan 13, 2022

Changes in this version

+ const FORCE

+ const ForDefault

+ const ForGroupBy

+ const ForJoin

+ const ForOrderBy

+ const IGNORE

+ const USE

+ func As(ident string, as string) string

+ func Asc(column string) string

+ func Avg(ident string) string

+ func Count(ident string) string

+ func Desc(column string) string

+ func Distinct(idents ...string) string

+ func Int64(ctx context.Context, query Querier, eq ExecQuerier) (int64, error)

+ func Int64s(ctx context.Context, query Querier, eq ExecQuerier) ([]int64, error)

+ func Lower(ident string) string

+ func Max(ident string) string

+ func Min(ident string) string

+ func ScanInt(rows ColumnScanner) (int, error)

+ func ScanInt64(rows ColumnScanner) (int64, error)

+ func ScanOne(rows ColumnScanner, v interface{}) error

+ func ScanSlice(rows ColumnScanner, v interface{}) error

+ func ScanString(rows ColumnScanner) (string, error)

+ func ScanValue(rows ColumnScanner) (driver.Value, error)

+ func String(ctx context.Context, query Querier, eq ExecQuerier) (string, error)

+ func Strings(ctx context.Context, query Querier, eq ExecQuerier) ([]string, error)

+ func Sum(ident string) string

+ type Builder struct

+ func (b *Builder) AddError(err error) *Builder

+ func (b *Builder) Arg(a interface{}) *Builder

+ func (b *Builder) Args(a ...interface{}) *Builder

+ func (b *Builder) Comma() *Builder

+ func (b *Builder) Err() error

+ func (b *Builder) Ident(s string) *Builder

+ func (b *Builder) IdentComma(s ...string) *Builder

+ func (b *Builder) Join(qs ...Querier) *Builder

+ func (b *Builder) JoinComma(qs ...Querier) *Builder

+ func (b *Builder) Len() int

+ func (b *Builder) Nested(f func(*Builder)) *Builder

+ func (b *Builder) Pad() *Builder

+ func (b *Builder) Quote(ident string) string

+ func (b *Builder) Reset() *Builder

+ func (b *Builder) SetDialect(dialect string)

+ func (b *Builder) SetTotal(total int)

+ func (b *Builder) String() string

+ func (b *Builder) WriteByte(c byte) *Builder

+ func (b *Builder) WriteOp(op Op) *Builder

+ func (b *Builder) WriteString(s string) *Builder

+ func (b Builder) Dialect() string

+ func (b Builder) Query() (string, []interface{})

+ func (b Builder) Total() int

+ type ColumnScanner interface

+ Close func() error

+ ColumnTypes func() ([]*sql.ColumnType, error)

+ Columns func() ([]string, error)

+ Err func() error

+ Next func() bool

+ NextResultSet func() bool

+ Scan func(dest ...interface{}) error

+ type DebugDB struct

+ func Debug(db *sql.DB) *DebugDB

+ func (d *DebugDB) Begin() (*DebugTx, error)

+ func (d *DebugDB) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (d *DebugDB) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ type DebugTx struct

+ func (d *DebugTx) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (d *DebugTx) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ type DeleteBuilder struct

+ func Delete(table string) *DeleteBuilder

+ func (d *DeleteBuilder) FromSelect(s *Selector) *DeleteBuilder

+ func (d *DeleteBuilder) Query() (string, []interface{})

+ func (d *DeleteBuilder) Schema(name string) *DeleteBuilder

+ func (d *DeleteBuilder) Table(name string) *DeleteBuilder

+ func (d *DeleteBuilder) Where(p *Predicate) *DeleteBuilder

+ type ExecQuerier interface

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

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

+ type ForWhat string

+ type Func struct

+ func (f *Func) Append(fn func(*Builder)) *Func

+ func (f *Func) Avg(ident string)

+ func (f *Func) Count(ident string)

+ func (f *Func) Lower(ident string)

+ func (f *Func) Max(ident string)

+ func (f *Func) Min(ident string)

+ func (f *Func) String() string

+ func (f *Func) Sum(ident string)

+ type IndexAction string

+ type IndexOptions struct

+ type InsertBuilder struct

+ func Insert(table string) *InsertBuilder

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

+ func (i *InsertBuilder) OnDuplicateKeyUpdate(columns ...string) *InsertBuilder

+ func (i *InsertBuilder) OnDuplicateKeyUpdateExpr(q ...Querier) *InsertBuilder

+ func (i *InsertBuilder) Query() (string, []interface{})

+ func (i *InsertBuilder) Schema(name string) *InsertBuilder

+ func (i *InsertBuilder) Set(column string, v interface{}) *InsertBuilder

+ func (i *InsertBuilder) Table(name string) *InsertBuilder

+ func (i *InsertBuilder) Values(values ...interface{}) *InsertBuilder

+ type LockAction string

+ const NoWait

+ const SkipLocked

+ type LockOption func(*LockOptions)

+ func WithLockAction(action LockAction) LockOption

+ type LockOptions struct

+ Action LockAction

+ Strength LockStrength

+ type LockStrength string

+ const LockShare

+ const LockUpdate

+ type Op int

+ const OpEQ

+ const OpGT

+ const OpGTE

+ const OpIn

+ const OpIsNull

+ const OpLT

+ const OpLTE

+ const OpLike

+ const OpNEQ

+ const OpNotIn

+ const OpNotNull

+ type ParamFormatter interface

+ FormatParam func(placeholder string, info *StmtInfo) string

+ type Predicate struct

+ func And(preds ...*Predicate) *Predicate

+ func CompositeGT(columns []string, args ...interface{}) *Predicate

+ func CompositeLT(columns []string, args ...interface{}) *Predicate

+ func Contains(col, sub string) *Predicate

+ func EQ(col string, value interface{}) *Predicate

+ func EqualFold(col, sub string) *Predicate

+ func ExprP(exr string, args ...interface{}) *Predicate

+ func False() *Predicate

+ func GT(col string, value interface{}) *Predicate

+ func GTE(col string, value interface{}) *Predicate

+ func HasPrefix(col, prefix string) *Predicate

+ func HasSuffix(col, suffix string) *Predicate

+ func In(col string, args ...interface{}) *Predicate

+ func InInts(col string, args ...int) *Predicate

+ func InValues(col string, args ...driver.Value) *Predicate

+ func IsNull(col string) *Predicate

+ func LT(col string, value interface{}) *Predicate

+ func LTE(col string, value interface{}) *Predicate

+ func Like(col, pattern string) *Predicate

+ func NEQ(col string, value interface{}) *Predicate

+ func Not(pred *Predicate) *Predicate

+ func NotIn(col string, args ...interface{}) *Predicate

+ func NotNull(col string) *Predicate

+ func Or(preds ...*Predicate) *Predicate

+ func P(fns ...func(*Builder)) *Predicate

+ func (p *Predicate) Append(f func(*Builder)) *Predicate

+ func (p *Predicate) CompositeGT(columns []string, args ...interface{}) *Predicate

+ func (p *Predicate) CompositeLT(columns []string, args ...interface{}) *Predicate

+ func (p *Predicate) Contains(col, sub string) *Predicate

+ func (p *Predicate) EQ(col string, arg interface{}) *Predicate

+ func (p *Predicate) EqualFold(col, sub string) *Predicate

+ func (p *Predicate) False() *Predicate

+ func (p *Predicate) GT(col string, arg interface{}) *Predicate

+ func (p *Predicate) GTE(col string, arg interface{}) *Predicate

+ func (p *Predicate) HasPrefix(col, prefix string) *Predicate

+ func (p *Predicate) HasSuffix(col, suffix string) *Predicate

+ func (p *Predicate) In(col string, args ...interface{}) *Predicate

+ func (p *Predicate) InInts(col string, args ...int) *Predicate

+ func (p *Predicate) InValues(col string, args ...driver.Value) *Predicate

+ func (p *Predicate) IsNull(col string) *Predicate

+ func (p *Predicate) LT(col string, arg interface{}) *Predicate

+ func (p *Predicate) LTE(col string, arg interface{}) *Predicate

+ func (p *Predicate) Like(col, pattern string) *Predicate

+ func (p *Predicate) NEQ(col string, arg interface{}) *Predicate

+ func (p *Predicate) Not() *Predicate

+ func (p *Predicate) NotIn(col string, args ...interface{}) *Predicate

+ func (p *Predicate) NotNull(col string) *Predicate

+ func (p *Predicate) Query() (string, []interface{})

+ type Querier interface

+ Query func() (string, []interface{})

+ func Expr(exr string, args ...interface{}) Querier

+ func Raw(s string) Querier

+ type Queries []Querier

+ func (n Queries) Query() (string, []interface{})

+ type SelectTable struct

+ func Table(name string) *SelectTable

+ func (s *SelectTable) As(alias string) *SelectTable

+ func (s *SelectTable) C(column string) string

+ func (s *SelectTable) Columns(columns ...string) []string

+ func (s *SelectTable) Schema(name string) *SelectTable

+ func (s *SelectTable) Unquote() *SelectTable

+ type Selector struct

+ func Select(columns ...string) *Selector

+ func (s *Selector) As(alias string) *Selector

+ func (s *Selector) C(column string) string

+ func (s *Selector) Clone() *Selector

+ func (s *Selector) Columns(columns ...string) []string

+ func (s *Selector) Context() context.Context

+ func (s *Selector) Count(columns ...string) *Selector

+ func (s *Selector) Distinct() *Selector

+ func (s *Selector) For(l LockStrength, opts ...LockOption) *Selector

+ func (s *Selector) ForShare(opts ...LockOption) *Selector

+ func (s *Selector) ForUpdate(opts ...LockOption) *Selector

+ func (s *Selector) ForceIndex(indexName ...string) *Selector

+ func (s *Selector) ForceIndexFor(forwhat ForWhat, indexName ...string) *Selector

+ func (s *Selector) From(t TableView) *Selector

+ func (s *Selector) FromSelect(s2 *Selector) *Selector

+ func (s *Selector) GroupBy(columns ...string) *Selector

+ func (s *Selector) Having(p *Predicate) *Selector

+ func (s *Selector) IgnoreIndex(indexName ...string) *Selector

+ func (s *Selector) IgnoreIndexFor(forwhat ForWhat, indexName ...string) *Selector

+ func (s *Selector) Join(t TableView) *Selector

+ func (s *Selector) LeftJoin(t TableView) *Selector

+ func (s *Selector) Limit(limit int) *Selector

+ func (s *Selector) Not() *Selector

+ func (s *Selector) Offset(offset int) *Selector

+ func (s *Selector) On(c1, c2 string) *Selector

+ func (s *Selector) OnP(p *Predicate) *Selector

+ func (s *Selector) Or() *Selector

+ func (s *Selector) OrderBy(columns ...string) *Selector

+ func (s *Selector) OrderExpr(exprs ...Querier) *Selector

+ func (s *Selector) P() *Predicate

+ func (s *Selector) Query() (string, []interface{})

+ func (s *Selector) RightJoin(t TableView) *Selector

+ func (s *Selector) Select(columns ...string) *Selector

+ func (s *Selector) SelectColumnsLen() int

+ func (s *Selector) SetDistinct(v bool) *Selector

+ func (s *Selector) SetP(p *Predicate) *Selector

+ func (s *Selector) Table() *SelectTable

+ func (s *Selector) UseIndex(indexName ...string) *Selector

+ func (s *Selector) UseIndexFor(forwhat ForWhat, indexName ...string) *Selector

+ func (s *Selector) Where(p *Predicate) *Selector

+ func (s *Selector) WithContext(ctx context.Context) *Selector

+ type StmtInfo struct

+ Dialect string

+ type TableView interface

+ type UpdateBuilder struct

+ func Update(table string) *UpdateBuilder

+ func (u *UpdateBuilder) Add(column string, v interface{}) *UpdateBuilder

+ func (u *UpdateBuilder) Empty() bool

+ func (u *UpdateBuilder) FromSelect(s *Selector) *UpdateBuilder

+ func (u *UpdateBuilder) Query() (string, []interface{})

+ func (u *UpdateBuilder) Schema(name string) *UpdateBuilder

+ func (u *UpdateBuilder) Set(column string, v interface{}) *UpdateBuilder

+ func (u *UpdateBuilder) SetNull(column string) *UpdateBuilder

+ func (u *UpdateBuilder) Table(name string) *UpdateBuilder

+ func (u *UpdateBuilder) Where(p *Predicate) *UpdateBuilder

v1.0.1

Jan 12, 2022