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_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')