I have triggered this issue with some query's. My unsigned integers, big integers being converted to python Long. Then on insert or updates the query would fail because database would not accept the 1L, '234L, etc..
This patch will never cause problems, since even really long numbers would be converted nicely.
I created this patch to fix the issue:
+++ /usr/local/lib/python2.7/dist-packages/web/db.py 2013-03-07 16:55:46.076738130 +0100
@@ -326,6 +326,8 @@
elif obj is False:
+ elif isinstance(obj, long):
+ return str(obj)
elif datetime and isinstance(obj, datetime.datetime):
Of course a better explanation of this issue and/or better solution would be helpfull.
Fixed handling of long numbers in sqlify. closes #213. (tx cjrolo)