1 files changed, 14 insertions, 2 deletions
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
+}