def get_articles(request):
query = request.GET.get('query', '')
tq = parse_tq(request.GET.get('tq', ''))
tqx = parse_tqx(request.GET.get('tqx', ''))
select = Article.select()
select = select.limit(tq.get('limit', 1))
select = select.offset(tq.get('offset', 0))
if query:
select = select.where(Article.subject % ('*%s*' % query))
subjects = [ a.subject for a in select ]
LOG.debug(lcs(subjects))
LOG.debug(commonprefix(subjects))
dt = gviz.DataTable({
'posted': ('datetime', 'Posted'),
'poster': ('string', 'Poster'),
'subject': ('string', 'Subject'),
'message_id': ('string', 'ID')
})
dt.LoadData( a._data for a in select )
dt_order = ['subject', 'posted', 'poster', 'message_id']
gviz_json = dt.ToJSonResponse(req_id=tqx.get('reqId', 0),
columns_order=dt_order)
return itty.Response(gviz_json, content_type='application/json')
def get_state(request):
data = {
'jobs': IDXR.task_queue.qsize(),
'articles': Article.select().count(),
'groups': Group.select().count()
}
return itty.Response(json.dumps(data), content_type='application/json')
