in go-db-comparison/benchmarks/benchmark.go [86:105]
func DbSqlQueryStudentWithLimit(limit int) {
var students []Student
rows, err := db.Query("SELECT * FROM students limit ?", limit)
if err != nil {
log.Fatalf("DbSqlQueryStudentWithLimit %d %v", limit, err)
}
defer rows.Close()
// Loop through rows, using Scan to assign column data to struct fields.
for rows.Next() {
var s Student
if err := rows.Scan(&s.ID, &s.Fname, &s.Lname, &s.DateOfBirth, &s.Email, &s.Address, &s.Gender); err != nil {
log.Fatalf("DbSqlQueryStudentWithLimit %d %v", limit, err)
}
students = append(students, s)
}
if err := rows.Err(); err != nil {
log.Fatalf("DbSqlQueryStudentWithLimit %d %v", limit, err)
}
}