-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
48 lines (43 loc) · 1.03 KB
/
main.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package main
import (
"github.com/codegangsta/martini"
"github.com/martini-contrib/render"
"net/http"
"database/sql"
_ "github.com/lib/pq"
)
type User struct {
Name string
Email string
}
func SetupDB() *sql.DB{
db, err := sql.Open("postgres", "dbname=gh_development sslmode=disable")
PanicIf(err)
return db
}
func PanicIf(err error){
if err != nil {
panic(err)
}
}
func main() {
m := martini.Classic()
m.Map(SetupDB())
m.Use(render.Renderer(render.Options{Layout: "layout",}))
m.Get("/", func(ren render.Render, r *http.Request, db *sql.DB){
searchTerm := "%" + r.URL.Query().Get("q") + "%"
rows, err := db.Query("SELECT name, email FROM users WHERE name ILIKE $1 OR email ILIKE $1 AND email != 'admin@example.com'", searchTerm)
PanicIf(err)
defer rows.Close()
users := []User{}
for rows.Next() {
u := User{}
PanicIf(rows.Err())
err := rows.Scan(&u.Name, &u.Email)
PanicIf(err)
users = append(users, u)
}
ren.HTML(200, "name", users)
})
m.Run()
}