Mercurial > sqlpython

changeset 205:c3dc0c6b6d8c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
synch
author catherine@dellzilla
date Thu, 18 Dec 2008 10:14:32 -0500
parents 1c3df79fd088
children 0351e977c245
files sqlpython/sqlpyPlus.py
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpython/sqlpyPlus.py	Fri Dec 12 10:14:09 2008 -0500
+++ b/sqlpython/sqlpyPlus.py	Thu Dec 18 10:14:32 2008 -0500
@@ -655,11 +655,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
@@ -929,7 +929,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'