What is a GORM transaction and how do I use it?

What is a GORM transaction and how do I use it?

A GORM transaction is a way to execute multiple database operations as a single unit of work. It ensures that either all operations succeed or none at all.

Can you show me an example of how to implement a GORM transaction?

Sure! Here's a simple example:

func CreateUserAndProfile(db *gorm.DB, user User, profile Profile) error {
    return db.Transaction(func(tx *gorm.DB) error {
        if err := tx.Create(&user).Error; err != nil {
            return err
        }
        profile.UserID = user.ID
        if err := tx.Create(&profile).Error; err != nil {
            return err
        }
        return nil
    })
}

What happens if one of the operations fails?

If one of the operations fails, the transaction will be rolled back, and none of the changes will be saved to the database.

Are there any best practices for using transactions in GORM?

Yes, it's best to keep transactions short, avoid long-running transactions, and handle errors properly to ensure data integrity.