package main import ( "database/sql" "fmt" "log" "net/http" "github.com/bmizerany/pat" _ "github.com/lib/pq" ) func main() { fmt.Printf("hello, world\n") db, err := sql.Open("postgres", "user=sysvitals dbname=sysvitals host=/var/run/postgresql") if err != nil { log.Fatal(err) } rows, err := db.Query("SELECT * FROM user_groups") if err != nil { log.Fatal(err) } for rows.Next() { var userId, groupId int rows.Scan(&userId, &groupId) fmt.Printf("user: %d, group: %d\n", userId, groupId) } muxer := pat.New() muxer.Get("/", http.HandlerFunc(handleRoot)) muxer.Get("/server/:server/raw", http.HandlerFunc(handleRaw)) http.Handle("/", muxer) err = http.ListenAndServe(":8892", nil) log.Fatal(err) } func handleRoot(w http.ResponseWriter, req *http.Request) { fmt.Fprintf(w, "welcome to the sysvitals api") } func handleRaw(w http.ResponseWriter, req *http.Request) { params := req.URL.Query() server := params.Get(":server") fmt.Fprintf(w, "raw; server: %s", server) }