Golang database/sql.Tx.Stmt function example

package database/sql

Stmt returns a transaction-specific prepared statement from an existing statement.

Golang database/sql.Tx.Stmt function usage example ( from http://golang.org/pkg/database/sql/#Tx.Stmt )

 updateMoney, err := db.Prepare("UPDATE balance SET money=money+? WHERE id=?")
 ...
 tx, err := db.Begin()
 ...
 res, err := tx.Stmt(updateMoney).Exec(123.45, 98293203) 
 // where the final statement is executed with money + 123.45 and id = 98293203

Reference :

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

Advertisement