Simple ad-hoc query for count

gistfile1.go

var db *sql.DB

func Count() (int, error) {
    rows, err := db.Query("SELECT COUNT(*) AS count FROM users")
    
    if err != nil { 
        return nil, err 
    }

    var count int

    // populate the count
    defer rows.Close()
    for rows.Next() { 
        rows.Scan(&count) 
    }

    return result.Count, nil
}