Mercurial > sqlpython

changeset 111:289b0a472b65

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
print results in describe
author catherine@Elli.myhome.westell.com
date Fri, 13 Jun 2008 15:53:03 -0400
parents 1cd9ec129372
children 5e57765073f4 6e346ae994b9
files sqlpyPlus.py
diffstat 1 files changed, 28 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpyPlus.py	Mon Jun 09 23:13:50 2008 -0400
+++ b/sqlpyPlus.py	Fri Jun 13 15:53:03 2008 -0400
@@ -415,7 +415,26 @@
                   (self.tblname, self.output_row_as_xml(row), self.tblname)
                   for row in self.rows]
         return '\n'.join(result)
-
+
+    html_template = """<html>
+  <head>
+    <title py:content="tblname">Table Name</title>
+  </head>
+  <body>
+    <table py:attr={'id':tblname}>
+      <tr>
+        <th py:for="colname in colnames">
+          <span py:replace="colname">Column Name</span>
+        </th>
+      </tr>
+      <tr py:for="row in rows">
+        <td py:for="itm in row">
+          <span py:replace="str_or_empty(itm)">Value</span>
+        </td>
+      </tr>
+    </table>
+  </body>
+</html>"""
     def output_as_html_table(self):
         result = ''.join('<th>%s</th>' % c for c in self.colnames)
         result = ['  <tr>\n    %s\n  </tr>' % result]
@@ -428,7 +447,13 @@
 %s
 </table>''' % (self.tblname, '\n'.join(result))
         return result
-
+
+    #TODO: use serious templating to make these user-tweakable
+
+    def output_as_markup(self, genshi_template):
+        return None
+        #self.tblname, self.colnames, self.rows
+            
     def output_as_list(self, align):
         result = []
         colnamelen = max(len(colname) for colname in self.colnames) + 1        
@@ -590,7 +615,7 @@
             self.curs.execute(descQueries['PackageObjects'][0], {'package_name':object_name, 'owner':owner})
             packageContents = self.curs.fetchall()
             for (packageObj_name,) in packageContents:
-                print packageObj_name
+                self.stdout.write(packageObj_name + '\n')
                 self.do_select(descQueries['PackageObjArgs'][0],bindVarsIn={'package_name':object_name, 'owner':owner, 'object_name':packageObj_name})
     do_desc = do_describe