How do I handle transactions in Go SQL migrations?

How do I handle transactions in Go SQL migrations?

In Go, you can use the database/sql package to manage transactions during migrations. You start a transaction using db.Begin(), and then you can execute your migration queries within that transaction.

Can you show me a code example?

Sure! Here's a simple example:

func migrate(db *sql.DB) error {
    tx, err := db.Begin()
    if err != nil {
        return err
    }
    
    _, err = tx.Exec("CREATE TABLE users (id INT, name VARCHAR(100))")
    if err != nil {
        tx.Rollback()
        return err
    }
    
    return tx.Commit()
}

What happens if the migration fails?

If the migration fails, you should call tx.Rollback() to undo any changes made during the transaction, ensuring your database remains consistent.

Is it possible to run multiple migrations in one transaction?

Yes, you can run multiple migrations in a single transaction by executing each migration query within the same transaction block before committing.