Golang database/sql.DB.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.DB.QueryRow function usage examples

Example 1: ( from http://golang.org/pkg/database/sql/#DB.QueryRow )

 id := 123
 var username string
 err := db.QueryRow("SELECT username FROM users WHERE id=?", id).Scan(&username)
 switch {
 case err == sql.ErrNoRows:
 log.Printf("No user with that ID.")
 case err != nil:
 log.Fatal(err)
 default:
 fmt.Printf("Username is %s\n", username)
 }

Example 2:

 // Insert nil
 b = nil
 success := false
 if err = dbt.db.QueryRow("SELECT ? IS NULL", b).Scan(&success); err != nil {
 dbt.Fatal(err)
 }
 if !success {
 dbt.Error("Inserting []byte(nil) as NULL failed")
 }

Reference :

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

Advertisement