Mercurial > sqlpython

changeset 207:0351e977c245

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
folded in sessinfo fix
author catherine@dellzilla
date Thu, 18 Dec 2008 10:20:59 -0500
parents c3dc0c6b6d8c (diff) ed46f2dba929 (current diff)
children 545d98ed07f3
files sqlpython/sqlpyPlus.py
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpython/sqlpyPlus.py	Thu Dec 18 10:10:27 2008 -0500
+++ b/sqlpython/sqlpyPlus.py	Thu Dec 18 10:20:59 2008 -0500
@@ -660,11 +660,11 @@
             if len(parts) == 2:
                 owner, object_name = parts
                 object_type = self.select_scalar_list('SELECT object_type FROM all_objects WHERE owner = :owner AND object_name = :object_name',
-                                  {'owner': owner, 'object_name': object_name}
+                                  {'owner': owner, 'object_name': object_name.upper()}
                                   )[0]
             elif len(parts) == 1:
                 object_name = parts[0]
-                self.curs.execute(queries['resolve'], {'objName':object_name})
+                self.curs.execute(queries['resolve'], {'objName':object_name.upper()})
                 object_type, object_name, owner = self.curs.fetchone()
         except (TypeError, IndexError):
             print 'Could not resolve object %s.' % identifier
@@ -931,7 +931,7 @@
 
     def do_refs(self, arg):
         result = []
-        (type, owner, table_name) = self.resolve(arg)        
+        (type, owner, table_name) = self.resolve(arg.upper())        
         self.curs.execute("""SELECT constraint_name, r_owner, r_constraint_name 
                              FROM   all_constraints 
                              WHERE  constraint_type = 'R'