Packages/db/Tx

Node: knexgithub.com/sahilkhaire/gox/db

Tx

Overview

Tx wraps a sqlx transaction.

Part of the db package — Node.js analog: knex.

Tx is a type exported by gox. Methods on this type are documented separately.

Signature

type Tx struct {
	SQL *sqlx.Tx
}

Compare: Node.js · Standard Go · gox

Node.js

// Typical knex pattern in Node.js

Standard Go

db, err := sqlx.Connect("postgres", dsn)
db.GetContext(ctx, &row, query, args...)

gox

import "github.com/sahilkhaire/gox/db"

err := db.Transaction(ctx, func(tx *db.Tx) error {
    return tx.Insert(ctx, "users", row)
})

Example

import "github.com/sahilkhaire/gox/db"

err := db.Transaction(ctx, func(tx *db.Tx) error {
    return tx.Insert(ctx, "users", row)
})

Tips

Pass context.Context as the first argument so cancellation and deadlines propagate correctly.

Standard library alternative

Use the standard library directly:

db, err := sqlx.Connect("postgres", dsn)
db.GetContext(ctx, &row, query, args...)

← Back to db package overview