How do I manage transactions in Go using an ORM?

How do I manage transactions in Go using an ORM?

To manage transactions in Go with an ORM, you typically start a transaction, perform your operations, and then commit or rollback.

Can you show me a code example?

Sure! Here's a simple example using GORM:

db.Transaction(func(tx *gorm.DB) error {
    if err := tx.Create(&user).Error; err != nil {
        return err
    }
    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, ensuring that no partial changes are saved to the database.

Are there any best practices for transaction management?

Yes, always keep transactions short, handle errors properly, and avoid long-running transactions to prevent locking issues.