gnue/common/src/dbdrivers db2/DBdriver.py odbc-...

[Jason Cater]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Jason Cater <address@hidden>    02/01/28 17:09:37

Modified files:
        common/src/dbdrivers/db2: DBdriver.py 
Added files:
        common/src/dbdrivers/odbc-db2: DBdriver.py __init__.py 

Log message:
        work on DB2 introspection + introduction of a DB2-over-OBDC driver

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/db2/DBdriver.py.diff?tr1=1.10&tr2=1.11&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/odbc-db2/DBdriver.py?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/odbc-db2/__init__.py?rev=1.1

Patches:
Index: gnue/common/src/dbdrivers/db2/DBdriver.py
diff -c gnue/common/src/dbdrivers/db2/DBdriver.py:1.10 
gnue/common/src/dbdrivers/db2/DBdriver.py:1.11
*** gnue/common/src/dbdrivers/db2/DBdriver.py:1.10      Thu Jan 10 16:09:51 2002
--- gnue/common/src/dbdrivers/db2/DBdriver.py   Mon Jan 28 17:09:37 2002
***************
*** 130,136 ****
  
    # Find a schema object with specified name
    def getSchemaByName(self, name, type=None):
!      return None
  
  
    # Get fields for a table
--- 130,170 ----
  
    # Find a schema object with specified name
    def getSchemaByName(self, name, type=None):
! 
!     where_user = ""
!     parts = string.split(string.upper(name),'.')
!     name = parts[-1]
!     if len(parts) > 1:
!       schema = " and tabschema='%s'" % parts[-2]
!     else:
!       schema =
! 
!     statement = \
!       "select tabschema||'.'||tabname||'.'||type full_name, " + \
!         "tabschema||'.'||tabname table_name, " + \
!         "type table_type " + \
!         "from syscat.tables where tabname == '%s' and status = 'N' %s " \
!               % (name, schema) + \
!           "order by tabname "
! 
!     GDebug.printMesg(5,statement)
! 
!     cursor = self._dataConnection.cursor()
!     cursor.execute(statement)
! 
!     list = []
!     for rs in cursor.fetchall():
!       list.append(GDataObjects.Schema(attrs={'id':string.lower(rs[0]), 
'name':rs[1],
!                          'type':rs[2]},
!                          getChildSchema=self.__getFieldSchema))
! 
!     cursor.close()
! 
!     try:
!       return list[0]
!     except:
!       return None
! 
  
  
    # Get fields for a table
***************
*** 203,210 ****
  
  class DB2_DataObject_SQL(DB2_DataObject, \
        DBSIG_DataObject_SQL):
!   def __init__(self): 
!     # Call DBSIG init first because DB2_DataObject needs to overwrite 
      # some of its values
      DBSIG_DataObject_SQL.__init__(self)
      DB2_DataObject.__init__(self)
--- 237,244 ----
  
  class DB2_DataObject_SQL(DB2_DataObject, \
        DBSIG_DataObject_SQL):
!   def __init__(self):
!     # Call DBSIG init first because DB2_DataObject needs to overwrite
      # some of its values
      DBSIG_DataObject_SQL.__init__(self)
      DB2_DataObject.__init__(self)