Changeset 1270

Timestamp:

01/08/07 14:16:43 (6 years ago)

Author:

ijm1

Message:

buildUpdateFromDict was casting strings from ccsweb into integers for
use in PostgreSql? update statements. The problem with this is that when
a floating point number gets truncated down to an integer instead of a
ValueError? being thrown and therefore any real number updated into the
database will actually be truncated.

Fixed by letting sql deal with the conversion, all we do is pass it the
string.

File:

• ccsd/trunk/crcnetd/_utils/ccsd_common.py (modified) (1 diff)

ccsd/trunk/crcnetd/_utils/ccsd_common.py

@@ -454 +454 @@
             f=1
             c=""
-        try:
-            v = int(newDetails[prop])
-        except ValueError:
-            v = newDetails[prop]
+        v = newDetails[prop]
+        
         if doNull and v==-1:
             sql = "%s%s %s=NULL" % (sql, c, prop)