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

gosql

package module

Go to main page

Versions in this module

v1

v1.0.4

Sep 26, 2018

v1.0.3

Sep 18, 2018

v1.0.2

Sep 18, 2018

v1.0.1

Sep 18, 2018

Changes in this version

+ func SetLogging(logging bool)

+ type Hook struct

+ Errs []error

+ func NewHook(wrapper *Wrapper) *Hook

+ func (h *Hook) Err(err error) error

+ func (h *Hook) Error() error

+ func (h *Hook) HasError() int

v1.0.0

Sep 5, 2018

Changes in this version

+ var AUTO_CREATE_TIME_FIELDS = []string

+ var AUTO_UPDATE_TIME_FIELDS = []string

+ var Default = "default"

+ var FatalExit = true

+ func Connect(configs map[string]*Config) (err error)

+ func DB(name ...string) *sqlx.DB

+ func Exec(query string, args ...interface{}) (sql.Result, error)

+ func Get(dest interface{}, query string, args ...interface{}) error

+ func Import(f string) ([]sql.Result, error)

+ func IsZero(val reflect.Value) bool

+ func List() map[string]*sqlx.DB

+ func QueryRowx(query string, args ...interface{}) *sqlx.Row

+ func Queryx(query string, args ...interface{}) (*sqlx.Rows, error)

+ func Select(dest interface{}, query string, args ...interface{}) error

+ func SetLogger(l Logger)

+ func Tx(fn func(tx *sqlx.Tx) error) error

+ func Txx(ctx context.Context, fn func(ctx context.Context, tx *sqlx.Tx) error) error

+ type Builder struct

+ func Model(model interface{}, tx ...*sqlx.Tx) *Builder

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

+ func (b *Builder) Count(zeroValues ...string) (num int64, err error)

+ func (b *Builder) Create() (lastInsertId int64, err error)

+ func (b *Builder) Delete(zeroValues ...string) (affected int64, err error)

+ func (b *Builder) Get(zeroValues ...string) (err error)

+ func (b *Builder) Hint(hint string) *Builder

+ func (b *Builder) Limit(i int) *Builder

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

+ func (b *Builder) OrderBy(str string) *Builder

+ func (b *Builder) ShowSQL() *Builder

+ func (b *Builder) Update(zeroValues ...string) (affected int64, err error)

+ func (b *Builder) Where(str string, args ...interface{}) *Builder

+ type Config struct

+ Driver string

+ Dsn string

+ Enable bool

+ MaxIdleConns int

+ MaxLifetime int

+ MaxOpenConns int

+ ShowSql bool

+ type IModel interface

+ DbName func() string

+ PK func() string

+ TableName func() string

+ type ISqlx interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

+ Get func(dest interface{}, query string, args ...interface{}) error

+ QueryRowx func(query string, args ...interface{}) *sqlx.Row

+ Queryx func(query string, args ...interface{}) (*sqlx.Rows, error)

+ Select func(dest interface{}, query string, args ...interface{}) error

+ type Logger interface

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

+ type Mapper struct

+ func Table(t string, tx ...*sqlx.Tx) *Mapper

+ func (m *Mapper) Count() (num int64, err error)

+ func (m *Mapper) Create(data map[string]interface{}) (lastInsertId int64, err error)

+ func (m *Mapper) Delete() (affected int64, err error)

+ func (m *Mapper) ShowSQL() *Mapper

+ func (m *Mapper) Update(data map[string]interface{}) (affected int64, err error)

+ func (m *Mapper) Where(str string, args ...interface{}) *Mapper

+ type QueryStatus struct

+ Args interface{}

+ End time.Time

+ Err error

+ Query string

+ Start time.Time

+ func (q *QueryStatus) String() string

+ type ReflectMapper struct

+ func NewReflectMapper(tagName string) *ReflectMapper

+ func (r *ReflectMapper) FieldMap(v reflect.Value) map[string]reflect.Value

+ type SQLBuilder struct

+ func (s *SQLBuilder) Where(str string, args ...interface{})

+ type Wrapper struct

+ func ShowSql() *Wrapper

+ func Use(db string) *Wrapper

+ func WithTx(tx *sqlx.Tx) *Wrapper

+ func (w *Wrapper) Exec(query string, args ...interface{}) (result sql.Result, err error)

+ func (w *Wrapper) Get(dest interface{}, query string, args ...interface{}) (err error)

+ func (w *Wrapper) Import(f string) ([]sql.Result, error)

+ func (w *Wrapper) QueryRowx(query string, args ...interface{}) (rows *sqlx.Row)

+ func (w *Wrapper) Queryx(query string, args ...interface{}) (rows *sqlx.Rows, err error)

+ func (w *Wrapper) Select(dest interface{}, query string, args ...interface{}) (err error)

+ func (w *Wrapper) Table(t string) *Mapper

+ func (w *Wrapper) Tx(fn func(tx *sqlx.Tx) error) (err error)

+ func (w *Wrapper) Txx(ctx context.Context, fn func(ctx context.Context, tx *sqlx.Tx) error) (err error)