sysvitals/api/main.go

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)
}