transact

README

transact

A simple helper for executing SQL queries inside a transaction and automatically handling rollback and commit scenarios.

Example

err := transact.DoContext(ctx, db.DB, func(tx *sql.Tx) error {
    q := `SELECT ...` // any sql query that needs to run in a transaction

    _, err := tx.Exec(ctx, q, someID, count)
    if err != nil {
        return err // any errors will roll the transaction back before returning
    }

    panic("WHAT") // any panic will be recovered, roll the transaction back, and re-panic

    return nil // nil errors will commit the transaction
})
if err != nil {
    return err
}

Documentation

Overview

Package transact provides a simple helper for running sql queries inside a transaction without needing to handle all rollback and commit scenarios manually.

Index

• func Do(db *sql.DB, txFunc func(*sql.Tx) error) (err error)
• func DoContext(ctx context.Context, db *sql.DB, txFunc func(*sql.Tx) error) (err error)

Functions

func Do

func Do(db *sql.DB, txFunc func(*sql.Tx) error) (err error)

Do executes the given txFunc inside of a new transaction handling all possible rollback and commit scenarios.

func DoContext

func DoContext(ctx context.Context, db *sql.DB, txFunc func(*sql.Tx) error) (err error)

DoContext executes the given txFunc inside of a new transaction handling all possible rollback and commit scenarios.