# HG changeset patch
# User catherine@cordelia
# Date 1254507057 14400
# Node ID b9fedbfbec7936ef8e717c965a6e536b10342a1a
# Parent  18330ebc1cc433dfdff2848da52160eee2cc6c35
ls now works with suggested changes to Gerald

diff -r 18330ebc1cc4 -r b9fedbfbec79 sqlpython/schemagroup.py
--- a/sqlpython/schemagroup.py	Wed Sep 02 10:12:17 2009 -0400
+++ b/sqlpython/schemagroup.py	Fri Oct 02 14:10:57 2009 -0400
@@ -21,6 +21,7 @@
                 ):
                 self.schemas[schemaname] = self.childtype(schemaname,
                                                           self)
+'SELECT owner, max(last_ddl_time) FROM all_objects GROUP BY owner'
 
 
 class OracleSchema(gerald.OracleSchema):
diff -r 18330ebc1cc4 -r b9fedbfbec79 sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Wed Sep 02 10:12:17 2009 -0400
+++ b/sqlpython/sqlpyPlus.py	Fri Oct 02 14:10:57 2009 -0400
@@ -1441,9 +1441,11 @@
         '''
         seek = '^%s$' % (arg.replace('*', '.*').replace('?','.'). \
                          replace('%', '.*'))
-        gerald = self.connections[self.connection_number]['gerald']
+#        import pdb; pdb.set_trace()
+        schemas = self.connections[self.connection_number]['schemas'].schemas
+        schema = schemas[self.connections[self.connection_number]['user']].schema
         result = []
-        for (name, obj) in gerald.schema.items():
+        for (name, obj) in schema.items():
             if hasattr(obj, 'type'):
                 dbtype = obj.type
             else:
diff -r 18330ebc1cc4 -r b9fedbfbec79 sqlpython/sqlpython.py
--- a/sqlpython/sqlpython.py	Wed Sep 02 10:12:17 2009 -0400
+++ b/sqlpython/sqlpython.py	Fri Oct 02 14:10:57 2009 -0400
@@ -9,7 +9,7 @@
 # See also http://twiki.cern.ch/twiki/bin/view/PSSGroup/SqlPython
 
 import cmd2,getpass,binascii,cx_Oracle,re,os,platform
-import sqlalchemy, pyparsing
+import sqlalchemy, pyparsing, schemagroup
 __version__ = '1.6.8'    
 
 class Parser(object):