Golang database/sql.Tx.QueryRow function examples

package database/sql

QueryRow executes a query that is expected to return at most one row. QueryRow always return a non-nil value. Errors are deferred until Row's Scan method is called.

Golang database/sql.Tx.QueryRow function usage examples

Example 1:

 var num int
 err = txn.QueryRow("SELECT COUNT(*) FROM temp").Scan(&num)
 if err != nil {
 fmt.Println(err)
 }
 if num != 500 {
 fmt.Printf("expected 500 items, not %d", num)
 }

Example 2:

 var name string

 err = tx.QueryRow(`
 UPDATE jobs
 SET build_number_seq = build_number_seq + 1
 WHERE name = $1
 RETURNING build_number_seq
 `, job).Scan(&name)

 if err != nil {
 return builds.Build{}, err
 }

Reference :

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

Advertisement