bsql

README

bsql

bsql wrap golang std sql package, make it more easy to use.

Features

• Easy to bind query result into struct
• Builtin prepared statement for better performance & against SQL injection
• Unify err type, no need check err for different kind of database

Documentation

Index

• Variables
• func Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)
• func GetMaster() (*sql.DB, error)
• func Insert(ctx context.Context, query string, data interface{}, args ...interface{}) (sql.Result, error)
• func QueryRow(ctx context.Context, rst interface{}, query string, args ...interface{}) error
• func QueryRows(ctx context.Context, rst interface{}, query string, args ...interface{}) error
• func RegisterMaster(driverName string, db *sql.DB) error

Variables

var (
	ErrNoDatabaseRegistered = errors.New("no db registered")
	ErrDriverNameNotMatch   = errors.New("driver name not match")
)

var (
	ErrTableNotExists = errors.New("table not exists")
	ErrDuplicateEntry = errors.New("duplicate entry")
	ErrNoRecord       = errors.New("no record")
	ErrUndefined      = errors.New("undefined error")
)

Functions

func Exec

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

func GetMaster

func GetMaster() (*sql.DB, error)

func Insert

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

func QueryRow

func QueryRow(ctx context.Context, rst interface{}, query string, args ...interface{}) error

func QueryRows

func QueryRows(ctx context.Context, rst interface{}, query string, args ...interface{}) error

func RegisterMaster

func RegisterMaster(driverName string, db *sql.DB) error