func Query(db *asynql.DB) error {
rows1 := db.Query(`SELECT id, name FROM test_table`)
row2 := db.QueryRow(`SELECT COUNT(*) FROM test_table`)
r1 := <-rows1
if err := r1.Err(); err != nil {
return err
}
defer r1.Close()
for r1.Next() {
var id int
var name string
if err := r1.Scan(&id, &name); err != nil {
return err
}
fmt.Printf("id: %v, name: %v\n", id, name)
}
if err := r1.Err(); err != nil {
return err
}
var count int
r2 := <-row2
if err := r2.Scan(&count); err != nil {
return err
}
fmt.Printf("count: %v\n", count)
return nil
}
