The sqle package is an extension of the standard database/sql package.
- fully implements the
database/sqlinterface; - it is fast, sometimes very fast (has a minimum overhead);
Scanmethod can take composite types as arguments, such as pointers to structures (including nested ones), maps and slices;ColumnsandColumnTypesmethods cache the returned result.
This package requires Go 1.8 or later.
go get -u github.com/lazada/sqle
There are two ways of using this package:
- by replacing standard
database/sqlpackage with this package in your imports; - by wrapping specific standard
database/sqlobjects using theWrapfunction.
Additional examples of usage are available in rows_test.go, row_test.go and wrap_test.go.
As it was:
import "database/sql"
type User struct {
Id int32
Name string
Email string
Created time.Time
Updated time.Time
}
db, err := sql.Open(`sqlite3`, `testdata/testdata.db`)
if err != nil {
log.Fatalln(err)
}
user := new(User)
err = db.QueryRowContext(ctx, `SELECT * FROM users WHERE id = ?`, userId).
Scan(&user.Id, &user.Name, &user.Email, &user.Created, &user.Updated)
if err != nil {
log.Fatalln(err)
}It is now:
import sql "github.com/lazada/sqle"
type User struct {
Id int32 `sql:"id"`
Name string `sql:"name"`
Email string `sql:"email"`
Created time.Time `sql:"created"`
Updated time.Time `sql:"updated"`
}
db, err := sql.Open(`sqlite3`, `testdata/testdata.db`)
if err != nil {
log.Fatalln(err)
}
user := new(User)
err = db.QueryRowContext(ctx, `SELECT * FROM users WHERE id = ?`, userId).Scan(user)
if err != nil {
log.Fatalln(err)
}As it was (simplified example):
import "database/sql"
db, err := sql.Open(`sqlite3`, `testdata/testdata.db`)
if err != nil {
log.Fatalln(err)
}
var (
userId int32
userName, userEmail string
userCreated, userUpdated time.Time
)
err = db.QueryRowContext(ctx, `SELECT * FROM users WHERE id = ?`, userId).
Scan(&userId, &userName, &userEmail, &userCreated, &userUpdated)
if err != nil {
log.Fatalln(err)
}
user := map[string]interface{}{
`id`: userId,
`name`: userName,
`email`: userEmail,
`created`: userCreated,
`updated`: userUpdated,
}It is now:
import sql "github.com/lazada/sqle"
db, err := sql.Open(`sqlite3`, `testdata/testdata.db`)
if err != nil {
log.Fatalln(err)
}
user := make(map[string]interface{})
err = db.QueryRowContext(ctx, `SELECT * FROM users WHERE id = ?`, userId).Scan(user)
if err != nil {
log.Fatalln(err)
}