Help us shape the future of Go! Take the 2026 Go Developer Survey

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
- API
  
  Reference documentation for the pkg.go.dev API
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

gdao

package module

Go to main page

Versions in this module

v1

v1.2.3

Jun 10, 2026

v1.2.2

Oct 18, 2024

v1.2.1

Oct 8, 2024

v1.2.0

Sep 26, 2024

v1.1.2

Sep 22, 2024

Changes in this version

+ func PreCompile(limit uint32)

v1.1.1

Sep 5, 2024

Changes in this version

type GStruct

+ TableName func() string

type Table

+ func (t *Table[T]) TableName() string

v1.1.0

Aug 5, 2024

Changes in this version

+ const COCKROACHDB

+ const DB2

+ const DERBY

+ const ENTERPRISEDB

+ const FIREBIRD

+ const GREENPLUM

+ const HSQLDB

+ const INFORMIX

+ const INGRES

+ const MARIADB

+ const MYSQL

+ const NETEZZA

+ const OCEANBASE

+ const OPENGAUSS

+ const ORACLE

+ const POSTGRESQL

+ const SAPHANA

+ const SQLITE

+ const SQLSERVER

+ const SYBASE

+ const TERADATA

+ const TIDB

+ const VERTICA

+ func BindDataSource(db *sql.DB, dbtype DBType, tableNames ...string)

+ func BindDataSourceWithClass[T TableBase[T]](db *sql.DB, dbtype DBType)

+ func BindMapperDataSource(namespace string, db *sql.DB, dbtype DBType)

+ func BindMapperIdDataSource(namespace, id string, db *sql.DB, dbtype DBType)

+ func ExecuteBatch(sql string, args [][]any) ([]int64, error)

+ func ExecuteQueryBean(sql string, args ...any) (*base.DataBean, error)

+ func ExecuteQueryBeans(sql string, args ...any) ([]*base.DataBean, error)

+ func ExecuteQueryList[T any](sql string, args ...any) (r []*T, err error)

+ func ExecuteQuery[T any](sql string, args ...any) (r *T, err error)

+ func ExecuteUpdate(sql string, args ...any) (int64, error)

+ func GetDefaultDBHandle() DBhandle

+ func Init(db *sql.DB, dbtype DBType)

+ func NewDBHandle(db *sql.DB, dbtype DBType) DBhandle

+ func NewTransaction() (r Transaction, err error)

+ func NewTransactionWithDBhandle(db DBhandle) (r Transaction, err error)

+ func Scan[T any](dataBean *DataBean) (t *T, err error)

+ func SetLogger(on bool)

+ func UnbindDataSource(tableNames ...string)

+ func UnbindDataSourceWithClass[T TableBase[T]]()

+ func UnbindMapperDataSource(namespace string)

+ func UnbindMapperIdDataSource(namespace, id string)

+ type GStruct interface

+ AddBatch func()

+ Copy func(h P) P

+ Decode func(bs []byte) (err error)

+ Delete func() (int64, error)

+ Encode func() ([]byte, error)

+ ExecBatch func() ([]int64, error)

+ GroupBy func(columns ...Column[T]) *Table[T]

+ Having func(havings ...*Having[T]) *Table[T]

+ Insert func() (int64, error)

+ Limit func(limit int64)

+ Limit2 func(offset, limit int64)

+ MustMaster func(must bool)

+ OrderBy func(sorts ...*Sort[T]) *Table[T]

+ Select func(columns ...Column[T]) (_r P, err error)

+ Selects func(columns ...Column[T]) (_r []P, err error)

+ String func() string

+ TABLENAME func() string

+ Update func() (int64, error)

+ UseCache func(use bool)

+ UseCommentLine func(commentline string)

+ UseDBHandle func(db DBhandle) *Table[T]

+ UseTransaction func(transaction Transaction)

+ Where func(wheres ...*Where[T]) *Table[T]

+ type Scanner interface

+ Scan func(fieldname string, value any)

+ ToGdao func()

+ type Table struct

+ func (t *Table[T]) AddBatch()

+ func (t *Table[T]) Decode(data []byte) (map[string]any, error)

+ func (t *Table[T]) Delete() (int64, error)

+ func (t *Table[T]) Encode(m map[string]any) ([]byte, error)

+ func (t *Table[T]) ExecBatch() ([]int64, error)

+ func (t *Table[T]) GroupBy(columns ...Column[T]) *Table[T]

+ func (t *Table[T]) Having(havings ...*Having[T]) *Table[T]

+ func (t *Table[T]) Init(s string, columns []Column[T])

+ func (t *Table[T]) Insert() (int64, error)

+ func (t *Table[T]) IsInit() bool

+ func (t *Table[T]) Limit(limit int64)

+ func (t *Table[T]) Limit2(offset, limit int64)

+ func (t *Table[T]) MustMaster(must bool)

+ func (t *Table[T]) OrderBy(sorts ...*Sort[T]) *Table[T]

+ func (t *Table[T]) Put0(k string, v any)

+ func (t *Table[T]) Select(columns ...Column[T]) (_r *T, err error)

+ func (t *Table[T]) Selects(columns ...Column[T]) (_r []*T, err error)

+ func (t *Table[T]) TABLENAME() string

+ func (t *Table[T]) Update() (int64, error)

+ func (t *Table[T]) UseCache(use bool)

+ func (t *Table[T]) UseCommentLine(commentline string)

+ func (t *Table[T]) UseDBHandle(db DBhandle) *Table[T]

+ func (t *Table[T]) UseTransaction(transaction Transaction)

+ func (t *Table[T]) Where(wheres ...*Where[T]) *Table[T]

+ func (t Table[T]) ClassName()