1 files changed, 30 insertions, 0 deletions
diff --git a/cmd/web/handlers/blog.go b/cmd/web/handlers/blog.go
index d995583..07ab361 100644
--- a/cmd/web/handlers/blog.go
+++ b/cmd/web/handlers/blog.go
@@ -1,14 +1,19 @@
 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
 }
 
@@ -18,6 +23,31 @@ func (ctx *blogContext) index(w http.ResponseWriter, r *http.Request) {
 		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",