Mercurial > sqlpython
diff output_templates.py @ 149:3b1e25cc0e38
html output now valid xhtml 1.0 strict
| author | catherine@dellzilla |
|---|---|
| date | Fri, 26 Sep 2008 10:33:37 -0400 |
| parents | |
| children | ebdd20cfba69 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/output_templates.py Fri Sep 26 10:33:37 2008 -0400 @@ -0,0 +1,47 @@ +import genshi.template + +xml_template = genshi.template.NewTextTemplate(""" +<xml> + <${tblname}_resultset>{% for row in rows %} + <$tblname>{% for (colname, itm) in zip(colnames, row) %} + <${colname.lower()}>$itm</${colname.lower()}>{% end %} + </$tblname>{% end %} + </${tblname}_resultset> +</xml>""") + +html_template = genshi.template.MarkupTemplate(""" +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> +<html xmlns:py="http://genshi.edgewall.org/" xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> + <head> + <title py:content="tblname">Table Name</title> + <meta http-equiv="content-type" content="text/html;charset=utf-8" /> + </head> + <body> + <table py:attrs="{'id':tblname, + 'summary':'Result set from query on table ' + tblname}"> + <tr> + <th py:for="colname in colnames" + py:attrs="{'id':'header_' + colname.lower()}"> + <span py:replace="colname.lower()">Column Name</span> + </th> + </tr> + <tr py:for="(colname, row) in zip(colnames, rows)"> + <td py:for="itm in row" py:attrs="{'headers':'header_' + colname.lower()}"> + <span py:replace="str(itm)">Value</span> + </td> + </tr> + </table> + </body> +</html>""") + +list_template = genshi.template.NewTextTemplate(""" +{% for (rowNum, row) in enumerate(rows) %} +**** Row: ${rowNum + 1} +{% for (colname, itm) in zip(colnames, row) %}$colname: $itm +{% end %}{% end %}""") + +aligned_list_template = genshi.template.NewTextTemplate(""" +{% for (rowNum, row) in enumerate(rows) %} +**** Row: ${rowNum + 1} +{% for (colname, itm) in zip(colnames, row) %}${colname.ljust(colnamelen)}: $itm +{% end %}{% end %}""")