def dump(self, resource_id):
context = {
'model': model,
'session': model.Session,
'user': p.toolkit.c.user
}
data_dict = {
'resource_id': resource_id,
'limit': request.GET.get('limit', 100000),
'offset': request.GET.get('offset', 0)
}
action = p.toolkit.get_action('datastore_search')
try:
result = action(context, data_dict)
except p.toolkit.ObjectNotFound:
base.abort(404, p.toolkit._('DataStore resource not found'))
pylons.response.headers['Content-Type'] = 'text/csv'
pylons.response.headers['Content-disposition'] = \
'attachment; filename="{name}.csv"'.format(name=resource_id)
f = StringIO.StringIO()
wr = csv.writer(f, encoding='utf-8')
header = [x['id'] for x in result['fields']]
wr.writerow(header)
for record in result['records']:
wr.writerow([
_json_dump_nested(record[column])
for column in header])
return f.getvalue()
评论列表
文章目录