How to use transactions

[KabudoWiseMan]

I'm new to sqlc and I don't really understand the example "Using transactions" in docs. So how can I create a function that uses a transaction as for database/sql:

function FuncTx() {
	// some code
	tx, err := db.BeginTx(ctx, nil)
	if err != nil {
		log.Fatal(err)
	}
	// do something
	tx.Commit()
}

[Jille]

You can simply pass the tx to the New() function of the generated package.

function FuncTx() {
	// some code
	tx, err := db.BeginTx(ctx, nil)
	if err != nil {
		log.Fatal(err)
	}
	q := db.New(tx)
	r, err := q.GetRecord(ctx, 1)
	// ...
	tx.Commit()
}

[Jille]

I've submitted a PR to update the docs: #1583