[jToolkit-cvs] jToolkit/data database.py,1.13,1.14

[<dav...@us...>]

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()