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

sqltest

package

Go to main page

Versions in this module

v2

v2.0.2

Jan 9, 2026

v2.0.1

Jan 9, 2026

Changes in this version

+ var SQL = sqlcode.MustInclude(sqlcode.Options{}, sqlfs)

+ func DumpRows(rows *sql.Rows)

+ func QueryDump(dbi interface{}, qry string, args ...interface{})

+ func QueryInt(dbi CtxQuerier, qry string, args ...interface{}) (result int)

+ func QueryString(dbi CtxQuerier, qry string, args ...interface{}) (result string)

+ func QueryTime(dbi CtxQuerier, qry string, args ...interface{}) (result time.Time)

+ type CtxExecer interface

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

+ type CtxQuerier interface

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

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type Fixture struct

+ DB *sql.DB

+ DBName string

+ Driver SqlDriverType

+ func NewFixture() *Fixture

+ func (f *Fixture) IsPostgresql() bool

+ func (f *Fixture) IsSqlServer() bool

+ func (f *Fixture) Quote(value string) string

+ func (f *Fixture) RunIfMssql(t *testing.T, name string, fn func(t *testing.T))

+ func (f *Fixture) RunMigrationFile(filename string)

+ func (f *Fixture) Teardown()

+ type MapRow map[string]interface

+ type MapRows []MapRow

+ func QueryMaps(dbi CtxQuerier, qry string, args ...interface{}) MapRows

+ func RowsMap(columns []string, rows Rows) (outRows MapRows)

+ type Row []interface

+ type Rows []Row

+ func Query(dbi CtxQuerier, qry string, args ...interface{}) Rows

+ func RowIteratorToSlice(rows *sql.Rows) (columns []string, result Rows)

+ type SqlDriverType int

+ const SqlDriverMssql

+ const SqlDriverPgx

+ type StdoutLogger struct

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

+ func (s StdoutLogger) Println(v ...interface{})