Changeset 31

Timestamp:

03/12/07 20:21:31

Author:

fumanchu

Message:

Changed timedelta to use NUMERIC by default; floats were causing rounding errors. Also added new "add_pickled_type" methods to the adapter base classes to make adding user-defined types easier.

Files:

• trunk/geniusql/adapters.py (modified) (6 diffs)

trunk/geniusql/adapters.py

@@ -185 +185 @@
-    
-    def coerce_datetime_timedelta_to_any(self, value):
-float_val = value.days + (value.seconds / 86400.0)
-float
+dec_val = (value.days * 86400) + value.seconds
+dec
-    
-    coerce_decimal_to_any = str
@@ -232 +232 @@
-    def _to_TEXT(self, value):
-        return "'%s'" % str(value)
+    
+    def add_pickled_type(self, pytype):
+        name = "coerce_%s_to_any" % getCoerceName(pytype)
+        setattr(self, name, self.do_pickle)
+
-
-for fromtype in ('decimal', 'decimal_Decimal', 'fixedpoint_FixedPoint',
@@ -291 +296 @@
-    
-    def coerce_any_to_datetime_timedelta(self, value):
-value, 1
-days, int(seconds * 86400
+long(value), 86400
+int(days), int(seconds
-    
-    def coerce_any_to_decimal(self, value):
@@ -337 +342 @@
-        else:
-            return unicode(value, self.encoding)
+    
+    def add_pickled_type(self, pytype):
+        name = "coerce_any_to_%s" % getCoerceName(pytype)
+        setattr(self, name, self.do_pickle)
-
-
@@ -494 +503 @@
-    def coerce_datetime_time(self, col): return "TIME"
-    
-I was seriously disinterested in writing a parser for interval
+Use decimal instead of float to avoid rounding errors
-    def coerce_datetime_timedelta(self, col):
-coerce_float(col
+int_type(self.numeric_max_bytes
-    
-    def decimal_type(self, colname, precision, scale):
@@ -553 +562 @@
-            return self.coerce_long(col)
-        return self.int_type(bytes)
-
+
+
+
+
+