Golang database/sql.Tx.Exec and Rollback functions examples

package database/sql

Exec executes a query that doesn't return rows. For example: an INSERT and UPDATE.

Rollback aborts the transaction.

Golang database/sql.Tx.Exec and Rollback functions usage examples

Example 1:

 result, err := tx.Exec(`INSERT INTO order_request (member_id) VALUES (?)`, memberId)
 if err != nil {
 log.Print(err.Error())
 }
 orderId, err := result.LastInsertId()

Example 2:

 _, err = tx.Exec("DELETE FROM "+SqlTableName+" WHERE id = $1", id)
 if err != nil {
 tx.Rollback()
 return err
 }

References :

http://golang.org/pkg/database/sql/#Tx.Exec

http://golang.org/pkg/database/sql/#Tx.Rollback

Advertisement