SQL Transaction

[pr09jat]

How do I perform an SQL transaction? I want to insert data into two tables in a single transaction, but I can't find any documents that refer to it.

[stephenafamo]

Start your transaction as normal, and then pass the tx to the functions.

tx, _ := db.BeginTx(ctx, nil)
users, err := models.Users.Query().All(ctx, tx)

If you're using bob.DB, you can also do

err := db.RunInTx(ctx, nil, func(ctx context.Context, tx bob.Executor) {
     users, err := models.Users.Query().All(ctx, tx)
})