gnue-common/src/schema/scripter/processors __in...

[Jason Cater]

CVSROOT:        /cvsroot/gnue
Module name:    gnue-common
Branch:         
Changes by:     Jason Cater <address@hidden>    03/06/28 01:52:22

Modified files:
        src/schema/scripter/processors: __init__.py interbase.py 
                                        oracle.py 
Added files:
        src/schema/scripter/processors: mysql.py 

Log message:
        added mysql schema generator

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/src/schema/scripter/processors/mysql.py?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/src/schema/scripter/processors/__init__.py.diff?tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/src/schema/scripter/processors/interbase.py.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/src/schema/scripter/processors/oracle.py.diff?tr1=1.3&tr2=1.4&r1=text&r2=text

Patches:
Index: gnue-common/src/schema/scripter/processors/__init__.py
diff -c gnue-common/src/schema/scripter/processors/__init__.py:1.3 
gnue-common/src/schema/scripter/processors/__init__.py:1.4
*** gnue-common/src/schema/scripter/processors/__init__.py:1.3  Sat May 17 
16:51:37 2003
--- gnue-common/src/schema/scripter/processors/__init__.py      Sat Jun 28 
01:52:22 2003
***************
*** 1 ****
! vendors = ['postgresql','oracle','interbase']
\ No newline at end of file
--- 1 ----
! vendors = ['postgresql','oracle','interbase','mysql']
Index: gnue-common/src/schema/scripter/processors/interbase.py
diff -c gnue-common/src/schema/scripter/processors/interbase.py:1.2 
gnue-common/src/schema/scripter/processors/interbase.py:1.3
*** gnue-common/src/schema/scripter/processors/interbase.py:1.2 Wed Jun 25 
19:09:50 2003
--- gnue-common/src/schema/scripter/processors/interbase.py     Sat Jun 28 
01:52:22 2003
***************
*** 68,74 ****
      return "date"
  
    def text(self, object):
!     return "blob"
  
    def key(self, object):
      return "integer"
--- 68,77 ----
      return "date"
  
    def text(self, object):
!     if hasattr(object,'length') and object.length <= 2000:
!       return "varchar(%s)" % object.length
!     else:
!       return "blob"
  
    def key(self, object):
      return "integer"
***************
*** 83,96 ****
  
      if object.defaultwith == "serial":
  
!       gen = tablename + '_' + name + '_seq'
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = tablename + "_seq_"
          gen += str(object._parent._children.index(object))
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = tablename + "_" + str(id(object)) + '_seq'
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = 'seq_%s' % id(object)
  
        trigBody.append(" new.%s=gen_id(%s,1);\n" % (name,gen))
  
--- 86,99 ----
  
      if object.defaultwith == "serial":
  
!       gen = tablename + '_' + name + '_gen'
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = tablename + "_gen_"
          gen += str(object._parent._children.index(object))
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = tablename + "_" + str(id(object)) + '_gen'
        if len(gen) > self.MAX_NAME_LENGTH:
!         gen = 'gen_%s' % id(object)
  
        trigBody.append(" new.%s=gen_id(%s,1);\n" % (name,gen))
  
***************
*** 111,117 ****
    def createTable(self, name, fields, pretable=[], posttable=[]):
      trigBody = self.trigBody
  
!     posttable.append ("SET TERM ^ ;\n"+\
          "CREATE TRIGGER trg_%s FOR %s ACTIVE BEFORE INSERT" % (name,name)+\
          " POSITION 0 AS BEGIN\n" + ''.join(trigBody)+\
          "END ^\n"+\
--- 114,121 ----
    def createTable(self, name, fields, pretable=[], posttable=[]):
      trigBody = self.trigBody
  
!     if len(trigBody):
!       posttable.append ("SET TERM ^ ;\n"+\
          "CREATE TRIGGER trg_%s FOR %s ACTIVE BEFORE INSERT" % (name,name)+\
          " POSITION 0 AS BEGIN\n" + ''.join(trigBody)+\
          "END ^\n"+\
Index: gnue-common/src/schema/scripter/processors/oracle.py
diff -c gnue-common/src/schema/scripter/processors/oracle.py:1.3 
gnue-common/src/schema/scripter/processors/oracle.py:1.4
*** gnue-common/src/schema/scripter/processors/oracle.py:1.3    Wed Jun 25 
19:09:50 2003
--- gnue-common/src/schema/scripter/processors/oracle.py        Sat Jun 28 
01:52:22 2003
***************
*** 37,43 ****
      return "date"
  
    def text(self, object):
!     return "long"
  
    def key(self, object):
      return "number(%s)" % _PK_PRECISION
--- 37,46 ----
      return "date"
  
    def text(self, object):
!     if hasattr(object,'length') and object.length <= 2000:
!       return "varchar2(%s)" % object.length
!     else:
!       return "long"
  
    def key(self, object):
      return "number(%s)" % _PK_PRECISION