def index(format=None):
request.cache_key['args'] = request.args.items()
q = filter_query(cls.all())
format = response_format(request)
if format == 'csv':
def generate():
for entity in q:
if hasattr(entity, 'as_shallow'):
yield entity.as_shallow()
else:
yield entity.as_dict()
return stream_csv(generate(), filename="%s.csv" % name)
count = q.count()
if q.has_fts:
q = q.order_by('ts_rank_cd(entity.full_text, plainto_tsquery(:ftsq)) DESC')
limit = get_limit()
q = q.limit(limit)
offset = get_offset()
q = q.offset(offset)
return jsonify({
'count': count,
'next': paged_url('.index', limit, offset+limit) if count > offset else False,
'previous': paged_url('.index', limit, offset-limit) if offset > 0 else False,
'limit': limit,
'offset': offset,
'results': q,
'facets': make_facets()
}, shallow=True)
def index(format=None):
request.cache_key['args'] = request.args.items()
q = filter_query(cls.all())
if 'update' in request.args:
# FIXME set time correctly!
lastupdate=datetime.now().replace(hour=1,minute=0,second=0,microsecond=0) - timedelta(days=arg_int('update',1))
q=q.filter(cls.updated_at > lastupdate)
format = response_format(request)
if format == 'csv':
def generate():
for entity in q:
if hasattr(entity, 'as_shallow'):
yield entity.as_shallow()
else:
yield entity.as_dict()
return stream_csv(generate(), filename="%s.csv" % name)
count = q.count()
if q.has_fts:
q = q.order_by('ts_rank_cd(entity.full_text, plainto_tsquery(:ftsq)) DESC')
limit = get_limit()
q = q.limit(limit)
offset = get_offset()
q = q.offset(offset)
return jsonify({
'count': count,
'next': paged_url('.index', limit, offset+limit) if count > offset+limit else False,
'previous': paged_url('.index', limit, offset-limit) if offset > 0 else False,
'limit': limit,
'offset': offset,
'results': q,
'facets': make_facets()
}, shallow=True)
def handle_exceptions(exc):
""" Re-format exceptions to JSON if accept requires that. """
format = response_format(request)
if format == 'json':
body = {'status': exc.code,
'name': exc.name,
'description': exc.get_description(request.environ)}
return jsonify(body, status=exc.code,
headers=exc.get_headers(request.environ))
return exc
@reports.route('/reports/<name>')
def report(name, format=None):
if name not in REPORTS:
return NotFound(name)
func = REPORTS[name]
argspec = inspect.getargspec(func)
args = {}
for k, v in request.args.items():
if k in argspec.args:
args[k] = v
try:
q = func(**args)
except Exception, exc:
return jsonify({'error': unicode(exc)}, status=400)
format = response_format(request)
if format == 'csv':
return stream_csv(get_results(q), filename="%s.csv" % name)
count = q.count()
limit = get_limit()
q = q.limit(limit)
offset = get_offset()
q = q.offset(offset)
return jsonify({
'count': count,
'next': paged_url('.report', limit, offset+limit, name=name),
'previous': paged_url('.report', limit, offset-limit, name=name),
'limit': limit,
'offset': offset,
'query': str(q),