How can I perform a database rollback in Go?

How can I perform a database rollback in Go?

To perform a database rollback in Go, you typically use a transaction. First, start a transaction, then execute your queries. If something goes wrong, you can call the Rollback method.

Can you show me a code example?

Sure! Here's a simple example:

package main

import (
    "database/sql"
    _ "github.com/lib/pq"
    "log"
)

func main() {
    db, err := sql.Open("postgres", "user=username dbname=mydb sslmode=disable")
    if err != nil {
        log.Fatal(err)
    }
    
    tx, err := db.Begin()
    if err != nil {
        log.Fatal(err)
    }
    
    _, err = tx.Exec("INSERT INTO users(name) VALUES($1)", "John")
    if err != nil {
        tx.Rollback() // Rollback if there's an error
        log.Fatal(err)
    }
    
    err = tx.Commit() // Commit if everything is fine
    if err != nil {
        log.Fatal(err)
    }
}

This code starts a transaction, attempts to insert a user, and rolls back if there's an error.

What happens if I don't call Rollback?

If you don't call Rollback and an error occurs, the transaction will remain open, which can lead to database locks and other issues. It's important to handle transactions properly to maintain database integrity.