github.com/varialus/godfly@v0.0.0-20130904042352-1934f9f095ab/src/pkg/database/sql/example_test.go (about)

     1  // Copyright 2013 The Go Authors. All rights reserved.
     2  // Use of this source code is governed by a BSD-style
     3  // license that can be found in the LICENSE file.
     4  
     5  package sql_test
     6  
     7  import (
     8  	"database/sql"
     9  	"fmt"
    10  	"log"
    11  )
    12  
    13  var db *sql.DB
    14  
    15  func ExampleDB_Query() {
    16  	age := 27
    17  	rows, err := db.Query("SELECT name FROM users WHERE age=?", age)
    18  	if err != nil {
    19  		log.Fatal(err)
    20  	}
    21  	for rows.Next() {
    22  		var name string
    23  		if err := rows.Scan(&name); err != nil {
    24  			log.Fatal(err)
    25  		}
    26  		fmt.Printf("%s is %d\n", name, age)
    27  	}
    28  	if err := rows.Err(); err != nil {
    29  		log.Fatal(err)
    30  	}
    31  }
    32  
    33  func ExampleDB_QueryRow() {
    34  	id := 123
    35  	var username string
    36  	err := db.QueryRow("SELECT username FROM users WHERE id=?", id).Scan(&username)
    37  	switch {
    38  	case err == sql.ErrNoRows:
    39  		log.Printf("No user with that ID.")
    40  	case err != nil:
    41  		log.Fatal(err)
    42  	default:
    43  		fmt.Printf("Username is %s\n", username)
    44  	}
    45  }