Update of /cvsroot/jtoolkit/jToolkit/data
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5313
Modified Files:
database.py
Log Message:
added patch to encode sql for postgres
Index: database.py
===================================================================
RCS file: /cvsroot/jtoolkit/jToolkit/data/database.py,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** database.py 9 Feb 2004 13:26:54 -0000 1.13
--- database.py 9 Feb 2004 13:49:13 -0000 1.14
***************
*** 221,224 ****
--- 221,225 ----
"""execute a query, trap sql errors
"""
+ if type(sql) == unicode and self.DBTYPE == 'postgres': sql = sql.encode('iso8859')
try:
cursor = self.db.cursor()
***************
*** 235,238 ****
--- 236,240 ----
"""run a query, trap sql errors
"""
+ if type(sql) == unicode and self.DBTYPE == 'postgres': sql = sql.encode('iso8859')
try:
cursor = self.db.cursor()
***************
*** 332,335 ****
--- 334,338 ----
sql = "insert into "+tablename+"("+",".join(cols)+")"+" values("+",".join(values)+")"
self.errorhandler.logtrace("traceinsert: sql=%s" % (sql))
+ if type(sql) == unicode and self.DBTYPE == 'postgres': sql = sql.encode('iso8859')
try:
cursor = self.db.cursor()
***************
*** 377,380 ****
--- 380,384 ----
sql += " and ".join([self.equalsphrase(keys[n], keyvalues[n]) for n in range(len(keys))])
self.errorhandler.logtrace("traceupdate: sql=%s, actiondict=%r" % (sql,actiondict))
+ if type(sql) == unicode and self.DBTYPE == 'postgres': sql = sql.encode('iso8859')
try:
cursor = self.db.cursor()
***************
*** 392,395 ****
--- 396,400 ----
"""
sql = "delete from "+tablename+" where "+self.equalsphrase(keyname, keyvalue)
+ if type(sql) == unicode and self.DBTYPE == 'postgres': sql = sql.encode('iso8859')
try:
cursor = self.db.cursor()
|
