Mercurial > sqlpython

changeset 148:fcb19853cd94

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
improved accessibility of html template
author catherine@Elli.myhome.westell.com
date Thu, 25 Sep 2008 16:37:16 -0400
parents a2731c87b837
children 3b1e25cc0e38
files sqlpyPlus.py
diffstat 1 files changed, 7 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpyPlus.py	Thu Sep 25 16:20:08 2008 -0400
+++ b/sqlpyPlus.py	Thu Sep 25 16:37:16 2008 -0400
@@ -423,14 +423,16 @@
     <title py:content="tblname">Table Name</title>
   </head>
   <body>
-    <table py:attrs="{'id':tblname}">
+    <table py:attrs="{'id':tblname, 
+     'summary':'Result set from query on table ' + tblname}">
       <tr>
-        <th py:for="colname in colnames">
+        <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="row in rows">
-        <td py:for="itm in row">
+      <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>
@@ -472,7 +474,7 @@
             result = '\n'.join(result)
         elif outformat == '\\h':
             result = self.html_template.generate(**self.__dict__)
-        elif outformat == '\\t':
+        elif outformat == '\\t': # transposed
             rows = [self.colnames]
             rows.extend(list(self.rows))
             transpr = [[rows[y][x] for y in range(len(rows))]for x in range(len(rows[0]))] # matrix transpose