From 2bb87671b1c5b59d6c770627b99a17a784f81e1d Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Mon, 7 Sep 2015 01:08:00 -0400
Subject: stub in details page

---
 lib/db/index.js | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

(limited to 'lib/db')

diff --git a/lib/db/index.js b/lib/db/index.js
index 899abcc..7452f3d 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -65,6 +65,14 @@ db.getLatestThreads = function () {
     qb.orderBy("id", "desc").limit(50)
   }).fetchAll()
 }
+db.getThreadsForKeyword = function (keyword) {
+  return Thread.query(function(qb){
+    qb.where("keyword", "=", keyword).orderBy("id", "desc")
+  }).fetchAll()
+}
+db.getThread = function (id) {
+  return Thread.query("where", "id", "=", id).fetch()
+}
 
 /* FILES */
 
@@ -82,7 +90,7 @@ db.getFileSizes = function(ids){
 
 db.getCommentsForThread = function (id, limit, offset){
   return Comment.query(function(qb){
-    qb.where("thread", "=", id).orderBy("id", "desc")
+    qb.where("thread", "=", id).orderBy("id", "asc")
     if (limit) {
       qb = qb.limit(limit)
     }
@@ -101,9 +109,13 @@ db.getCommentCounts = function(ids){
 }
 
 /* KEYWORDS */
+
 db.getKeywords = function (keywords){
   return Keyword.query("where", "keyword", "in", keywords).fetchAll()
 }
+db.getKeyword = function (keyword) {
+  return Keyword.query("where", "keyword", "=", keyword).fetch()
+}
 
 
 /* PRIVATE MESSAGES */
@@ -114,4 +126,4 @@ db.getMessage = function (id){
     message.set("body", message.get("body").toString() )
     return message
   })
-}
\ No newline at end of file
+}
-- 
cgit v1.2.3-70-g09d2