Mercurial > sqlpython
view output_templates.py @ 150:b00a020b81c6
ready ? with 1.4.9
author | catherine@dellzilla |
---|---|
date | Fri, 26 Sep 2008 13:03:10 -0400 |
parents | 3b1e25cc0e38 |
children | ebdd20cfba69 |
line wrap: on
line source
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 %}""")