Database transactions in Go

transact.go

package main

import (
	"context"
	"database/sql"
	_ "github.com/mattn/go-sqlite3"
	"log"
)

func main() {
	db, err := sql.Open("sqlite3", "goodnessuc.db") // SQLite
	if err != nil {
		log.Fatalln(err)
	}

	// create a context for the transaction
	ctx := context.Background()

	//begin the transaction
	transaction, err := db.BeginTx(ctx, nil)
	if err != nil {
		log.Println("Error beginning the transaction", err)
	}
	insert, err := transaction.PrepareContext(ctx, "INSERT INTO accounts (username, balance) VALUES (?, ?)")
	insert.Exec("David", 8958)
	if err != nil {
		err := transaction.Rollback()
		if err != nil {
			log.Println("Error rolling back transaction on the insertion", err)
		}
	}

	row := transaction.QueryRow("SELECT * FROM accounts WHERE balance=5000")
	var (
		username string
		balance  int
	)

	err = row.Scan(&username, &balance)
	if err != nil {
		transaction.Rollback()
		log.Println("Error querying the row", err)

	}

	// Commit the changes
	err = transaction.Commit()
	if err != nil {
		log.Fatal(err)
	}

}