From a1b33089877660ba33331d76281e68790f35ae44 Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Fri, 15 Dec 2017 06:52:54 +0100
Subject: keywords list

---
 bucky/db/index.js | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'bucky/db/index.js')

diff --git a/bucky/db/index.js b/bucky/db/index.js
index f92ba2f..74ff788 100644
--- a/bucky/db/index.js
+++ b/bucky/db/index.js
@@ -220,6 +220,9 @@ db.getKeywords = function (keywords){
 db.getKeyword = function (keyword) {
   return Keyword.query("where", "keyword", "=", keyword).fetch()
 }
+db.getThreadGroups = function (keyword) {
+  return knex.column('keyword').sum('viewed').as('viewed').column('id').column('title').column('lastmodified').column('privacy').select().from('threads').groupBy('keyword')
+}
 db.createKeyword = function(data){
   return new db.Keyword(data).save()
 }
-- 
cgit v1.2.3-70-g09d2