def sql_report_csv(request, report_id):
'''View a single sql report.'''
extuser = request.extuser
report = SqlReport.objects.get(id=report_id)
whereclause = util.get_whereclause(request.GET)
cols, data = report.get_data({"whereclause": whereclause})
return format_csv(data, cols, report.title)
def sql_report(request, report_id, template_name="sql_report.html"):
'''View a single sql report.'''
extuser = request.extuser
report = SqlReport.objects.get(id=report_id)
whereclause = util.get_whereclause(request.GET)
table = report.to_html_table({"whereclause": whereclause})
return render_to_response(request, template_name, {"report": report, "table": table})