3 files changed, 44 insertions, 16 deletions

diff --git a/zig-comments/src/main.zig b/zig-comments/src/main.zig
index 951f5f0..0a7bca1 100644
--- a/zig-comments/src/main.zig
+++ b/zig-comments/src/main.zig
@@ -75,17 +75,43 @@ fn constresponse(res: *std.http.Server.Response, rr: []const u8, status: std.htt
     try res.finish();
 }
 
-fn get_comments(res: *std.http.Server.Response, ctx: Ctx, _: Params) Err!void {
-    _ = ctx;
-    // Run SQL
-    // Render comments template
-    //zws.parse
+fn get_comments(res: *std.http.Server.Response, ctx: Ctx, params: Params) Err!void {
+    _ = params;
+    var p = try zws.Path.parse(res.allocator, res.request.target);
+    defer p.deinit();
+    const url: []const u8 = try p.get_query_param("url") orelse {
+        try badrequest(res, ctx);
+        return;
+    };
+
+    const Comment = struct {
+        author: []const u8,
+        comment: []const u8,
+        ts: []const u8,
+    };
+    var comments = std.ArrayList(Comment).init(res.allocator);
+    var stmt = try ctx.db.prepare_statement(res.allocator,
+        \\ select author,comment,ts from comments where url = $1 order by ts
+    );
+    defer stmt.deinit();
+    try stmt.bind(0, url);
+    while (try stmt.step()) {
+        const cmt = try stmt.read_struct(Comment);
+        try comments.append(cmt);
+    }
 
     const rr = @embedFile("templates/comments.html");
-    res.transfer_encoding = .{ .content_length = rr.len };
+    const tt = comptime mustache.parseComptime(rr, .{}, .{});
+    res.transfer_encoding = .chunked;
     try res.headers.append("content-type", "text/html");
     try res.do();
-    try res.writeAll(rr);
+
+    const data = struct {
+        comments: []const Comment,
+    };
+    try mustache.render(tt, data{
+        .comments = comments.items,
+    }, res.writer());
     try res.finish();
 }
 
diff --git a/zig-comments/src/pq.zig b/zig-comments/src/pq.zig
index 52220fa..a4fc382 100644
--- a/zig-comments/src/pq.zig
+++ b/zig-comments/src/pq.zig
@@ -60,7 +60,7 @@ pub const Stmt = struct {
     db: Db,
     query: [:0]const u8,
     aa: std.heap.ArenaAllocator,
-    
+
     n_params: usize = 0,
     param_values: [MAX_PARAMS][*c]const u8 = undefined,
     did_exec: bool = false,
@@ -71,7 +71,9 @@ pub const Stmt = struct {
 
     pub fn deinit(self: *Stmt) void {
         self.aa.deinit();
-        pq.PQclear(self.c_res);
+        if (self.c_res != null) {
+            pq.PQclear(self.c_res);
+        }
     }
 
     pub fn step(self: *Stmt) !bool {
@@ -132,7 +134,7 @@ pub const Stmt = struct {
         const ti = @typeInfo(T);
         var t: T = undefined;
         inline for (ti.Struct.fields) |field| {
-            const name: [:0]const u8 = &addZ(field.name.len,field.name[0..].*);
+            const name: [:0]const u8 = &addZ(field.name.len, field.name[0..].*);
             const val = try self.read_columnN(name, field.type);
             @field(t, field.name) = val;
         }
@@ -143,7 +145,7 @@ pub const Stmt = struct {
 // https://github.com/ziglang/zig/issues/16116
 pub fn addZ(comptime length: usize, value: [length]u8) [length:0]u8 {
     var terminated_value: [length:0]u8 = undefined;
-    terminated_value[length] = 0;   
+    terminated_value[length] = 0;
     @memcpy(&terminated_value, &value);
     return terminated_value;
 }
diff --git a/zig-comments/src/templates/comments.html b/zig-comments/src/templates/comments.html
index a1d8b76..e2fc6da 100644
--- a/zig-comments/src/templates/comments.html
+++ b/zig-comments/src/templates/comments.html
@@ -1,9 +1,9 @@
 <ul class="comments">
-{{ #comments }}
+{{#comments}}
   <li class="comment">
-    <span class="comment author">{{ author }}</span>
-    <p class="comment content">{{ comment }}</p>
-    <span class="comment timestamp">{{ ts }}</span>
+    <span class="comment author">{{author}}</span>
+    <p class="comment content">{{comment}}</p>
+    <span class="comment timestamp">{{ts}}</span>
   </li>
-{{ /comments }}
+{{/comments}}
 </ul>