Mercurial > sqlpython
diff sqlpyPlus.py @ 111:289b0a472b65
print results in describe
| author | catherine@Elli.myhome.westell.com |
|---|---|
| date | Fri, 13 Jun 2008 15:53:03 -0400 |
| parents | 38ee1ca92801 |
| children | 5e57765073f4 6e346ae994b9 |
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