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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
package handlers
import (
"database/sql"
"html/template"
"log"
"net/http"
"paterissa.net/mblog/internal/models"
)
type blogContext struct {
err *log.Logger
db *sql.DB
Rows []models.Post
Name string
}
func (ctx *blogContext) index(w http.ResponseWriter, r *http.Request) {
ctx.Rows = []models.Post{}
if r.URL.Path != "/" {
http.NotFound(w, r)
return
}
offset := r.URL.Query().Get("offset")
if offset == "" {
offset = "20"
}
rows, err := ctx.db.Query("SELECT * FROM posts WHERE id < " + offset + " ORDER BY id DESC LIMIT 20;")
if err != nil {
ctx.err.Print(err.Error())
http.Error(w, "Internal Server Error", 500)
return
}
defer rows.Close()
for rows.Next() {
var p models.Post
if err = rows.Scan(&p.Id, &p.Name, &p.Time, &p.Content); err != nil {
ctx.err.Print(err.Error())
http.Error(w, "Internal Server Error", 500)
return
}
ctx.Rows = append(ctx.Rows, p)
}
files := []string{
"ui/html/base.tmpl.html",
"ui/html/music_player.tmpl.html",
"ui/html/pages/index.tmpl.html",
}
compiled, err := template.ParseFiles(files...)
if err != nil {
ctx.err.Print(err.Error())
http.Error(w, "Internal Server Error", 500)
return
}
err = compiled.ExecuteTemplate(w, "base", ctx)
if err != nil {
ctx.err.Print(err.Error())
http.Error(w, "Internal Server Error", 500)
return
}
}
|
