How do I handle transactions in Go with SQL?

How do I handle transactions in Go with SQL?

In Go, you can handle SQL transactions using the database/sql package. You start a transaction with db.Begin(), then execute your queries, and finally commit or rollback the transaction.

Can you show me a code example?

Sure! Here's a simple example:

tx, err := db.Begin()
if err != nil {
    log.Fatal(err)
}

_, err = tx.Exec("INSERT INTO users (name) VALUES (?)", "Alice")
if err != nil {
    tx.Rollback()
    log.Fatal(err)
}

err = tx.Commit()
if err != nil {
    log.Fatal(err)
}

What happens if I encounter an error during the transaction?

If an error occurs, you should call tx.Rollback() to undo any changes made during the transaction. This ensures data integrity.

Is it possible to nest transactions in Go?

Go's database/sql package does not support nested transactions directly. However, you can manage multiple transactions by handling them sequentially.