Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  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

core

package

Go to main page

Versions in this module

v1

v1.1.0

Jan 29, 2026

Changes in this version

type Builder

+ WithBind any

+ func (b *Builder) Bind(target any) *Builder

+ func (b *Builder) Last() (*sql.Row, error)

v1.0.0

Jan 29, 2026

Changes in this version

type Config

+ MaxIdleConns int

+ MaxOpenConns int

type Connector

+ Read *Builder

+ Write *Builder

v0

v0.5.0

Jan 28, 2026

Changes in this version

+ const Abort

+ const Asc

+ const Desc

+ const Fail

+ const Ignore

+ const Replace

+ const Rollback

+ func FormatValue(v any) string

+ func ValidateColumn(name string) error

+ type Builder struct

+ ConflictMode *conflict

+ DB *sql.DB

+ Error []error

+ GroupByList []string

+ HavingArgs []any

+ HavingList []Where

+ JoinList []Join

+ OrderByList []string

+ SelectList []string

+ TableName *string

+ UpdateList []string

+ WhereArgs []any

+ WhereList []Where

+ WithContext context.Context

+ WithLimit *int

+ WithOffset *int

+ WithTotal bool

+ func NewBuilder(db *sql.DB) *Builder

+ func (b *Builder) Conflict(conflict conflict) *Builder

+ func (b *Builder) Context(ctx context.Context) *Builder

+ func (b *Builder) Count() (int64, error)

+ func (b *Builder) CountContext(ctx context.Context) (int64, error)

+ func (b *Builder) Create(columns ...Column) error

+ func (b *Builder) Decrease(column string, num ...int) *Builder

+ func (b *Builder) Delete(force ...bool) (int64, error)

+ func (b *Builder) ExecAutoAsignContext(query string, args ...any) (sql.Result, error)

+ func (b *Builder) First() (*sql.Row, error)

+ func (b *Builder) FirstContext(ctx context.Context) (*sql.Row, error)

+ func (b *Builder) Get() (*sql.Rows, error)

+ func (b *Builder) GetContext(ctx context.Context) (*sql.Rows, error)

+ func (b *Builder) GetWithTotal() (*sql.Rows, error)

+ func (b *Builder) GetWithTotalContext(ctx context.Context) (*sql.Rows, error)

+ func (b *Builder) GroupBy(columns ...string) *Builder

+ func (b *Builder) Having(condition string, args ...any) *Builder

+ func (b *Builder) HavingBetween(column string, start, end any) *Builder

+ func (b *Builder) HavingEq(column string, value any) *Builder

+ func (b *Builder) HavingGe(column string, value any) *Builder

+ func (b *Builder) HavingGt(column string, value any) *Builder

+ func (b *Builder) HavingIn(column string, values []any) *Builder

+ func (b *Builder) HavingLe(column string, value any) *Builder

+ func (b *Builder) HavingLt(column string, value any) *Builder

+ func (b *Builder) HavingNotEq(column string, value any) *Builder

+ func (b *Builder) HavingNotIn(column string, values []any) *Builder

+ func (b *Builder) HavingNotNull(column string) *Builder

+ func (b *Builder) HavingNull(column string) *Builder

+ func (b *Builder) Increase(column string, num ...int) *Builder

+ func (b *Builder) Insert(data ...map[string]any) (int64, error)

+ func (b *Builder) InsertBatch(data []map[string]any) (int64, error)

+ func (b *Builder) InsertConflict(conflict conflict, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertConflictReturningID(conflict conflict, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertContexConflict(ctx context.Context, conflict conflict, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertContext(ctx context.Context, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertContextConflictReturningID(ctx context.Context, conflict conflict, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertContextReturningID(ctx context.Context, data ...map[string]any) (int64, error)

+ func (b *Builder) InsertReturningID(data ...map[string]any) (int64, error)

+ func (b *Builder) Join(table, on string) *Builder

+ func (b *Builder) LeftJoin(table, on string) *Builder

+ func (b *Builder) Limit(num ...int) *Builder

+ func (b *Builder) Offset(num int) *Builder

+ func (b *Builder) OrHaving(condition string, args ...any) *Builder

+ func (b *Builder) OrHavingBetween(column string, start, end any) *Builder

+ func (b *Builder) OrHavingEq(column string, value any) *Builder

+ func (b *Builder) OrHavingGe(column string, value any) *Builder

+ func (b *Builder) OrHavingGt(column string, value any) *Builder

+ func (b *Builder) OrHavingIn(column string, values []any) *Builder

+ func (b *Builder) OrHavingLe(column string, value any) *Builder

+ func (b *Builder) OrHavingLt(column string, value any) *Builder

+ func (b *Builder) OrHavingNotEq(column string, value any) *Builder

+ func (b *Builder) OrHavingNotIn(column string, values []any) *Builder

+ func (b *Builder) OrHavingNotNull(column string) *Builder

+ func (b *Builder) OrHavingNull(column string) *Builder

+ func (b *Builder) OrWhere(condition string, args ...any) *Builder

+ func (b *Builder) OrWhereBetween(column string, start, end any) *Builder

+ func (b *Builder) OrWhereEq(column string, value any) *Builder

+ func (b *Builder) OrWhereGe(column string, value any) *Builder

+ func (b *Builder) OrWhereGt(column string, value any) *Builder

+ func (b *Builder) OrWhereIn(column string, values []any) *Builder

+ func (b *Builder) OrWhereLe(column string, value any) *Builder

+ func (b *Builder) OrWhereLt(column string, value any) *Builder

+ func (b *Builder) OrWhereNotEq(column string, value any) *Builder

+ func (b *Builder) OrWhereNotIn(column string, values []any) *Builder

+ func (b *Builder) OrWhereNotNull(column string) *Builder

+ func (b *Builder) OrWhereNull(column string) *Builder

+ func (b *Builder) OrderBy(column string, direction ...direction) *Builder

+ func (b *Builder) Raw() *sql.DB

+ func (b *Builder) Select(columns ...string) *Builder

+ func (b *Builder) Table(name string) *Builder

+ func (b *Builder) Toggle(column string) *Builder

+ func (b *Builder) Total() *Builder

+ func (b *Builder) Update(data ...map[string]any) (int64, error)

+ func (b *Builder) UpdateContext(ctx context.Context, data ...map[string]any) (int64, error)

+ func (b *Builder) Where(condition string, args ...any) *Builder

+ func (b *Builder) WhereBetween(column string, start, end any) *Builder

+ func (b *Builder) WhereEq(column string, value any) *Builder

+ func (b *Builder) WhereGe(column string, value any) *Builder

+ func (b *Builder) WhereGt(column string, value any) *Builder

+ func (b *Builder) WhereIn(column string, values []any) *Builder

+ func (b *Builder) WhereLe(column string, value any) *Builder

+ func (b *Builder) WhereLt(column string, value any) *Builder

+ func (b *Builder) WhereNotEq(column string, value any) *Builder

+ func (b *Builder) WhereNotIn(column string, values []any) *Builder

+ func (b *Builder) WhereNotNull(column string) *Builder

+ func (b *Builder) WhereNull(column string) *Builder

+ type Column struct

+ AutoIncrease bool

+ Default any

+ ForeignKey *Foreign

+ IsNullable bool

+ IsPrimary bool

+ IsUnique bool

+ Name string

+ Type string

+ type Config struct

+ Key string

+ Lifetime int

+ Path string

+ type Connector struct

+ Map map[string]*sql.DB

+ Mu sync.Mutex

+ func (d *Connector) Close()

+ func (d *Connector) DB(key string) (*Builder, error)

+ func (d *Connector) Exec(key, query string, args ...any) (sql.Result, error)

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

+ func (d *Connector) Query(key, query string, args ...any) (*sql.Rows, error)

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

+ type Foreign struct

+ Column string

+ Table string

+ type Join struct

+ Mode string

+ On string

+ Table string

+ type Union struct

+ All bool

+ Builder *Builder

+ type Where struct

+ Condition string

+ Operator string