MySQL for Python MySQLdb-SVN

--- a/branches/ZMySQLDA-2/ZMySQLDA/DABase.py
+++ b/branches/ZMySQLDA-2/ZMySQLDA/DABase.py
@@ -89,7 +89,6 @@
 
 import Shared.DC.ZRDB.Connection, sys
 from Globals import HTMLFile
-from ImageFile import ImageFile
 from ExtensionClass import Base
 import Acquisition
 
@@ -98,60 +97,28 @@
 
     manage_options=Shared.DC.ZRDB.Connection.Connection.manage_options+(
         {'label': 'Browse', 'action':'manage_browse'},
-        # {'label': 'Design', 'action':'manage_tables'},
         )
 
-    manage_tables=HTMLFile('tables',globals())
     manage_browse=HTMLFile('browse',globals())
 
     info=None
         
     def tpValues(self):
-        #if hasattr(self, '_v_tpValues'): return self._v_tpValues
         r=[]
-        # self._v_tables=tables=TableBrowserCollection()
-        #tables=tables.__dict__
         c=self._v_database_connection
-        try:
-            for d in c.tables(rdb=0):
-                try:
-                    name=d['TABLE_NAME']
-                    b=TableBrowser()
-                    b.__name__=name
-                    b._d=d
-                    b._c=c
-                    #b._columns=c.columns(name)
-                    b.icon=table_icons.get(d['TABLE_TYPE'],'text')
-                    r.append(b)
-                    # tables[name]=b
-                except:
-                    # print d['TABLE_NAME'], sys.exc_type, sys.exc_value
-                    pass
-
-        finally: pass #print sys.exc_type, sys.exc_value
-        #self._v_tpValues=r
+        for d in c.tables(rdb=0):
+            try:
+                name=d['TABLE_NAME']
+                b=TableBrowser()
+                b.__name__=name
+                b._d=d
+                b._c=c
+                b.icon=table_icons.get(d['TABLE_TYPE'],'text')
+                r.append(b)
+            except:
+                pass
         return r
 
-    def __getitem__(self, name):
-        if name=='tableNamed':
-            if not hasattr(self, '_v_tables'): self.tpValues()
-            return self._v_tables.__of__(self)
-        raise KeyError, name
-
-    def manage_wizard(self, tables):
-        " "
-
-    def manage_join(self, tables, select_cols, join_cols, REQUEST=None):
-        """Create an SQL join"""
-
-    def manage_insert(self, table, cols, REQUEST=None):
-        """Create an SQL insert"""
-
-    def manage_update(self, table, keys, cols, REQUEST=None):
-        """Create an SQL update"""
-
-class TableBrowserCollection(Acquisition.Implicit):
-    "Helper class for accessing tables via URLs"
 
 class Browser(Base):
     def __getattr__(self, name):
@@ -172,7 +139,6 @@
     icon='what'
     Description=check=''
     info=HTMLFile('table_info',globals())
-    menu=HTMLFile('table_menu',globals())
 
     def tpValues(self):
         v=values()
@@ -195,43 +161,6 @@
     def Name(self): return self._d['TABLE_NAME']
     def Type(self): return self._d['TABLE_TYPE']
 
-    manage_designInput=HTMLFile('designInput',globals())
-    def manage_buildInput(self, id, source, default, REQUEST=None):
-        "Create a database method for an input form"
-        args=[]
-        values=[]
-        names=[]
-        columns=self._columns
-        for i in range(len(source)):
-            s=source[i]
-            if s=='Null': continue
-            c=columns[i]
-            d=default[i]
-            t=c['Type']
-            n=c['Name']
-            names.append(n)
-            if s=='Argument':
-                values.append("<!--#sql-value %s type=%s-->'" %
-                              (n, vartype(t)))
-                a='%s%s' % (n, boboType(t))
-                if d: a="%s=%s" % (a,d)
-                args.append(a)
-            elif s=='Property':
-                values.append("<!--#sql-value %s type=%s-->'" %
-                              (n, vartype(t)))
-            else:
-                if isStringType(t):
-                    if find(d,"\'") >= 0: d=join(split(d,"\'"),"''")
-                    values.append("'%s'" % d)
-                elif d:
-                    values.append(str(d))
-                else:
-                    raise ValueError, (
-                        'no default was given for <em>%s</em>' % n)
-
-            
-            
-
 class ColumnBrowser(Browser):
     icon='field'