X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=sql%2Futils.lisp;fp=sql%2Futils.lisp;h=df3b70581b144c3aca81c1f81649e4aa8da4e50c;hp=be1396e021af6636032140a445781297b6ab3d21;hb=6ba1e44b4faf89ed2aa0ebdf410eebd65e04b3a5;hpb=eeb36233c9881cd2bb141f7a3241afbe82feda8d

diff --git a/sql/utils.lisp b/sql/utils.lisp
index be1396e..df3b705 100644
--- a/sql/utils.lisp
+++ b/sql/utils.lisp
@@ -424,6 +424,26 @@ is replaced with replacement. [FROM http://cl-cookbook.sourceforge.net/strings.h
     (unless stream
       (get-output-stream-string out))))
 
+(defun read-decimal-value (string)
+  (let* ((comma 0)
+         (dot 0)
+         (last))
+    (loop for c across string
+          do (case c
+               (#\. (incf dot) (setf last 'dot))
+               (#\, (incf comma) (setf last 'comma))))
+    (let* ((bag (if (and (eql last 'dot) (eql dot 1))
+                    ".0123456789+-"
+                    ",0123456789+-"))
+           (clean (with-output-to-string (out)
+                    (loop for c across string
+                          do (when (find c bag :test #'char=)
+                               (write-char c out))))))
+      (if (and (eql last 'dot) (eql dot 1))
+          (decimals:parse-decimal-number clean)
+          (decimals:parse-decimal-number
+           clean :decimal-separator #\,)))))
+
 
 (defun filter-plist (plist &rest keys-to-remove)
   "Returns a copy of the given plist with indicated key-value pairs