dbutil

Documentation

Index

• func BulkInsert(db *sqlx.DB, tableName string, columns []string, rows [][]interface{}) (err error)
• func GetScalar(db *sqlx.DB, query string, args ...interface{}) (value interface{}, err error)
• func GetScalars(db *sqlx.DB, query string, args ...interface{}) (slice []interface{}, err error)
• func Tx(db *sqlx.DB, action func(tx *sqlx.Tx) error) (err error)

Functions

func BulkInsert

func BulkInsert(db *sqlx.DB, tableName string, columns []string, rows [][]interface{}) (err error)

Does a bulk insert of data into a single table using a transaction to make it quick:

func GetScalar

func GetScalar(db *sqlx.DB, query string, args ...interface{}) (value interface{}, err error)

Gets a single scalar value from a DB query:

func GetScalars

func GetScalars(db *sqlx.DB, query string, args ...interface{}) (slice []interface{}, err error)

Gets a slice of scalar values from a DB query:

func Tx

func Tx(db *sqlx.DB, action func(tx *sqlx.Tx) error) (err error)

Execute a database action in a transaction: