bottle-sqlite icon indicating copy to clipboard operation
bottle-sqlite copied to clipboard

No support for detect_types

Open jameskirsop opened this issue 4 years ago • 0 comments

For some time, the sqlite module for Python3 has supported retrieving datetime fields from sqlite as datetime.datetime python objects.

If I do a call via a function direct to the database using the native sqlite module I am returned datetime.datetime objects.

If I do a call to the same function as part of a bottle view via bottle-sqlite, I'm returned strings in the format %Y-%m-%d %H:%M:%S.

It would be ideal if this module returned python datetime() rather than str(). This issue means that I currently have to have two near-identical functions - one that handles the string type and the other that handles the correct type.

jameskirsop avatar Jun 19 '20 04:06 jameskirsop