Mercurial > sqlpython

changeset 177:87eb1c6ed59b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixed comments bug
author catherine@dellzilla
date Tue, 28 Oct 2008 16:12:58 -0400
parents 210d01022343
children 3ce72ea76768
files sqlpython/sqlpyPlus.py
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpython/sqlpyPlus.py	Tue Oct 28 16:06:45 2008 -0400
+++ b/sqlpython/sqlpyPlus.py	Tue Oct 28 16:12:58 2008 -0400
@@ -660,8 +660,10 @@
         if object_type:
             self.curs.execute(queries['tabComments'],{'table_name':object_name, 'owner':owner})
             self.stdout.write("%s %s.%s: %s\n" % (object_type, owner, object_name, self.curs.fetchone()[0]))
-            query = 'oneColComments' if colName else 'colComments'
-            self.do_select(queries[query],bindVarsIn={'owner':owner, 'object_name': object_name, 'column_name': colName})
+            if colName:
+                self.do_select(queries['oneColComments'],bindVarsIn={'owner':owner, 'object_name': object_name, 'column_name': colName})
+            else:
+                self.do_select(queries['colComments'],bindVarsIn={'owner':owner, 'object_name': object_name})
 
     def resolve(self, identifier):
         """Checks (my objects).name, (my synonyms).name, (public synonyms).name