[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-common/src/schema/scripter/processors __in...
From: |
Jason Cater |
Subject: |
gnue-common/src/schema/scripter/processors __in... |
Date: |
Sat, 28 Jun 2003 01:52:22 -0400 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue-common/src/schema/scripter/processors __in...,
Jason Cater <=