Update of /cvsroot/webware/Webware/MiddleKit/Design
In directory sc8-pr-cvs1:/tmp/cvs-serv30116/Design
Modified Files:
MSSQLSQLGenerator.py
Log Message:
- fix a bug where MS SQL couldn't support large strings
Index: MSSQLSQLGenerator.py
===================================================================
RCS file: /cvsroot/webware/Webware/MiddleKit/Design/MSSQLSQLGenerator.py,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** MSSQLSQLGenerator.py 7 Mar 2003 17:38:34 -0000 1.12
--- MSSQLSQLGenerator.py 15 Dec 2003 04:01:13 -0000 1.13
***************
*** 48,54 ****
self._klasses.reverse()
! return ''.join(strList)
! def dropTablesSQL(self):
strList = []
self._klasses.reverse()
--- 48,54 ----
self._klasses.reverse()
! return ''.join(strList)
! def dropTablesSQL(self):
strList = []
self._klasses.reverse()
***************
*** 61,65 ****
self._klasses.reverse()
return ''.join(strList)
!
def createDatabaseSQL(self, dbName):
--- 61,65 ----
self._klasses.reverse()
return ''.join(strList)
!
def createDatabaseSQL(self, dbName):
***************
*** 225,239 ****
--- 225,243 ----
class DateTimeAttr:
+
def sqlType(self):
return 'DateTime'
class DateAttr:
+
def sqlType(self):
return 'DateTime'
class TimeAttr:
+
def sqlType(self):
return 'DateTime'
+
class BoolAttr:
***************
*** 258,267 ****
return 'char(%s)' % self['Max']
else:
! ref = self.get('Ref','')
! if not ref:
! ref = '' # for some reason ref was none instead of ''
else:
! ref = ' ' + ref
! return 'varchar(%s)%s' % (self['Max'],ref)
class EnumAttr:
--- 262,276 ----
return 'char(%s)' % self['Max']
else:
! max = int(self['Max'])
! if int(self['Max'])>8000:
! return 'text'
else:
! ref = self.get('Ref', '')
! if not ref:
! ref = '' # for some reason ref was none instead of ''
! else:
! ref = ' ' + ref
! return 'varchar(%s)%s' % (self['Max'], ref)
!
class EnumAttr:
|