## -*- coding: utf-8 -*-
<%doc>
camcops_server/templates/snippets/query_result_core.mako
===============================================================================
Copyright (C) 2012, University of Cambridge, Department of Psychiatry.
Created by Rudolf Cardinal (rnc1001@cam.ac.uk).
This file is part of CamCOPS.
CamCOPS is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
CamCOPS is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with CamCOPS. If not, see <https://www.gnu.org/licenses/>.
===============================================================================
Creates an HTML table from a query result (from SQLAlchemy Core).
</%doc>
<%page args="descriptions, rows, null_html='<i>NULL</i>'"/>
<%!
from mako.filters import html_escape
def filter_value(value, null_html):
if value is None:
return null_html
return html_escape(str(value))
%>
<table>
<tr>
%for desc in descriptions:
<th>${ desc or "" }</th>
%endfor
</tr>
%for row in rows:
<tr>
%for value in row:
<td>${ filter_value(value, null_html) | n }</td>
%endfor
</tr>
%endfor
</table>