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

mysql

package

Go to main page

Versions in this module

v1

v1.0.8

Oct 19, 2021

v1.0.7

Oct 18, 2021

v1.0.6

Oct 18, 2021

v1.0.5

Oct 9, 2021

v1.0.4

Oct 9, 2021

v0

v0.0.3

Oct 8, 2021

v0.0.2

Sep 30, 2021

v0.0.1

Mar 14, 2021

Changes in this version

+ var AcquireQuery = func() *Query

+ var ErrNoMasterConn = errors.New("mysql group: no master connection available")

+ var ErrNoSlaveConn = errors.New("mysql group: no slave connection available")

+ var ReleaseQuery = func(query *Query)

+ func FormatRows(rows *sql.Rows, handler RowFormat)

+ func ToMap(rows *sql.Rows) ([]map[string]string, error)

+ type ExecResult struct

+ AffectedRows int64

+ LastInsertId int64

+ type Group struct

+ func NewGroup(groupOption *GroupOption) *Group

+ func (g *Group) BatchInsert(table string, rows []map[string]interface{}) (result *ExecResult, err error)

+ func (g *Group) Begin() (trans *Transaction, err error)

+ func (g *Group) BeginTx(ctx context.Context, opts *sql.TxOptions) (trans *Transaction, err error)

+ func (g *Group) DeleteAll(table string, where map[string]interface{}) (result *ExecResult, err error)

+ func (g *Group) Find(query *Query, useMaster bool) (rows *sql.Rows, err error)

+ func (g *Group) GetBadPool(isMaster bool) (list []int)

+ func (g *Group) GetMaster() (index int, mPoll *Pool)

+ func (g *Group) GetSlave() (index int, mPoll *Pool)

+ func (g *Group) Insert(table string, columns map[string]interface{}) (result *ExecResult, err error)

+ func (g *Group) MasterExec(handler func(mPool *Pool) (interface{}, error)) (result interface{}, err error)

+ func (g *Group) SelectPool(isMaster bool) (index int, mPool *Pool)

+ func (g *Group) SlaveQuery(handler func(mPool *Pool) (interface{}, error)) (result interface{}, err error)

+ func (g *Group) UpdateAll(table string, set map[string]interface{}, where map[string]interface{}) (result *ExecResult, err error)

+ type GroupOption struct

+ Masters []PoolOption

+ RetryInterval int64

+ Slaves []PoolOption

+ type Pool struct

+ func NewPool(option *PoolOption) (*Pool, error)

+ func (p *Pool) BatchInsert(table string, rows *[]map[string]interface{}) (result *ExecResult, err error)

+ func (p *Pool) Begin() (trans *Transaction, err error)

+ func (p *Pool) BeginTx(ctx context.Context, opts *sql.TxOptions) (trans *Transaction, err error)

+ func (p *Pool) Db() *sql.DB

+ func (p *Pool) DeleteAll(table string, where map[string]interface{}) (result *ExecResult, err error)

+ func (p *Pool) Execute(sqlStr string, args ...interface{}) (result *ExecResult, err error)

+ func (p *Pool) Find(query *Query) (*sql.Rows, error)

+ func (p *Pool) Insert(table string, columns *map[string]interface{}) (result *ExecResult, err error)

+ func (p *Pool) Query(sqlStr string, args ...interface{}) (rows *sql.Rows, err error)

+ func (p *Pool) UpdateAll(table string, set map[string]interface{}, where map[string]interface{}) (result *ExecResult, err error)

+ type PoolOption struct

+ Dsn string

+ MaxConnLifetime int

+ MaxIdleConns int

+ MaxOpenConns int

+ type Query struct

+ func (q *Query) From(table string) *Query

+ func (q *Query) Group(fields ...string) *Query

+ func (q *Query) Having(having string) *Query

+ func (q *Query) Limit(offset int64, limit int64) *Query

+ func (q *Query) Offset(offset int64) *Query

+ func (q *Query) Order(orders ...string) *Query

+ func (q *Query) Query(pool *Pool) (*sql.Rows, error)

+ func (q *Query) QueryByGroup(group *Group, useMaster bool) (*sql.Rows, error)

+ func (q *Query) Select(columns ...string) *Query

+ func (q *Query) Where(where map[string]interface{}) *Query

+ type RowFormat func(fieldValue map[string][]byte)

+ type Transaction struct

+ func (t *Transaction) BatchInsert(table string, rows *[]map[string]interface{}) (result *ExecResult, err error)

+ func (t *Transaction) Commit() error

+ func (t *Transaction) DeleteAll(table string, where map[string]interface{}) (result *ExecResult, err error)

+ func (t *Transaction) Execute(sqlStr string, args ...interface{}) (sql.Result, error)

+ func (t *Transaction) Find(query *Query) (*sql.Rows, error)

+ func (t *Transaction) Insert(table string, columns *map[string]interface{}) (result *ExecResult, err error)

+ func (t *Transaction) Query(sqlStr string, args ...interface{}) (*sql.Rows, error)

+ func (t *Transaction) Rollback() error

+ func (t *Transaction) UpdateAll(table string, set map[string]interface{}, where map[string]interface{}) (result *ExecResult, err error)