martini.go

package main

import (
    // "fmt"
    "log"
    "net/http"
    "runtime"
    "github.com/go-martini/martini"
    "github.com/jmoiron/sqlx"
    "github.com/martini-contrib/render"
    _ "github.com/lib/pq"
)

type App struct {
    Id          string
    Name        string
    CallbackUrl string
}

func main() {
    runtime.GOMAXPROCS(runtime.NumCPU())
    m := martini.Classic()

    m.Use(render.Renderer())

    m.Get("/", func(r render.Render) {

        db, err := sqlx.Open("postgres", "postgres://root:@localhost:1532/twofactor_dev?sslmode=disable")
        if err != nil {
            log.Fatal(err)
        }
        apps := []App{}
        err = db.Select(&apps, "SELECT id, name, callback_url AS CallbackUrl FROM apps ORDER BY name ASC")

        if err != nil {
            log.Fatal(err)
        }

        r.JSON(http.StatusOK, apps)
    })

    m.Run()
}