Golang database/sql.DB.Query function examples

package database/sql

Query executes a query that returns rows, typically a SELECT. The args are for any placeholder parameters in the query.

Golang database/sql.DB.Query function usage examples

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

 age := 27
 rows, err := db.Query("SELECT name FROM users WHERE age=?", age)
 if err != nil {
 log.Fatal(err)
 }
 defer rows.Close()
 for rows.Next() {
 var name string
 if err := rows.Scan(&name); err != nil {
 log.Fatal(err)
 }
 fmt.Printf("%s is %d\n", name, age)
 }

 if err := rows.Err(); err != nil {
 log.Fatal(err)
 }

Example 2:

 microsecsSupported := false
 zeroDateSupported := false
 var rows *sql.Rows
 var err error
 rows, err = dbt.db.Query(`SELECT cast("00:00:00.1" as TIME(1)) = "00:00:00.1"`)
 if err == nil {
  rows.Scan(&microsecsSupported)
  rows.Close()
 }
 rows, err = dbt.db.Query(`SELECT cast("0000-00-00" as DATE) = "0000-00-00"`)
 if err == nil {
  rows.Scan(&zeroDateSupported)
  rows.Close()
 }

References :

https://github.com/go-sql-driver/mysql/blob/master/driver_test.go

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

Advertisement