diff options
Diffstat (limited to 'server/kwd.py')
-rw-r--r-- | server/kwd.py | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/server/kwd.py b/server/kwd.py index 88fc799..c5f3403 100644 --- a/server/kwd.py +++ b/server/kwd.py @@ -2,9 +2,9 @@ from config import render, db class Keyword(object): - def GET(self): - keyword_count = db.query('SELECT KEYWORD, COUNT(DISTINCT IPKEY) AS PACKAGES, COUNT(DISTINCT UUID) AS HOSTS FROM GLOBAL_KEYWORDS NATURAL JOIN KEYWORDS NATURAL JOIN INSTALLED_PACKAGES GROUP BY KEYWORD') - keyword_data = dict() - for t in keyword_count: - keyword_data[t['KEYWORD']] = {'HOSTS':t['HOSTS'],'PACKAGES':t['PACKAGES']} - return render.keyword(keyword_data) + def GET(self): + keyword_count = db.query('SELECT KEYWORD, COUNT(DISTINCT IPKEY) AS PACKAGES, COUNT(DISTINCT UUID) AS HOSTS FROM GLOBAL_KEYWORDS NATURAL JOIN KEYWORDS NATURAL JOIN INSTALLED_PACKAGES GROUP BY KEYWORD') + keyword_data = dict() + for t in keyword_count: + keyword_data[t['KEYWORD']] = {'HOSTS':t['HOSTS'],'PACKAGES':t['PACKAGES']} + return render.keyword(keyword_data) |