Update of /cvsroot/webware/Webware/MiddleKit/Design
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13156
Modified Files:
MSSQLSQLGenerator.py
Log Message:
- handle string sample values containing an apostrophe correctly when generating InsertSamples.sql
Index: MSSQLSQLGenerator.py
===================================================================
RCS file: /cvsroot/webware/Webware/MiddleKit/Design/MSSQLSQLGenerator.py,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** MSSQLSQLGenerator.py 26 May 2004 19:37:44 -0000 1.21
--- MSSQLSQLGenerator.py 29 Aug 2004 00:44:58 -0000 1.22
***************
*** 267,270 ****
--- 267,289 ----
return 'varchar(%s)%s' % (int(self['Max']), ref)
+ def sqlForNonNoneSampleInput(self, input):
+ value = input
+ if value=="''":
+ value = ''
+ elif value.find('\\')!=-1:
+ if 1:
+ # add spaces before and after, to prevent
+ # syntax error if value begins or ends with "
+ value = eval('""" '+str(value)+' """')
+ value = repr(value[1:-1]) # trim off the spaces
+ value = value.replace('\\011', '\\t')
+ value = value.replace('\\012', '\\n')
+ value = value.replace("\\'", "''")
+ return value
+ value = repr(value)
+ value = value.replace("\\'", "''")
+ #print '>> value:', value
+ return value
+
class ObjRefAttr:
|