Open an issue to don't forget it,I'll fix it in the next few days Paolo On May 2, 2015 1:18 PM, "José Ricardo Borba" <jrborba...@gmail.com> wrote:
> Paolo, > > Thank you for you quickly response. But I'm working with the latest > web2py/Pydal 2.10.4 (downloaded 2.10.3 and updated). I forgot to mention > this. I'm sorry. > > My second bet is that the parser of time (the time_itens above) need to be > modified to work with time in mongo, > > Still not knowing what is the correct "bug" (if there are one) to report. > > Cheers, > > > 2015-05-02 4:23 GMT-03:00 Paolo Valleri <paolo.vall...@gmail.com>: > >> Hi, try use the latest version of pydal, Mongo adapter has been recently >> updated to work with pymongo 3.0 >> However, I think this is a bug. Can you open a bug report on >> https://github.com/web2py/pydal >> >> Paolo >> >> >> On Saturday, May 2, 2015 at 3:58:13 AM UTC+2, José Borba wrote: >>> >>> Hi 4 All, >>> >>> I'm new to mongoDB and still having some problems with a TIME field. >>> When I set a TIME field in the table, fill the input field of a sqlform >>> (only time is allowed) and send the data to table, all the record is >>> inserted without any warning. But when I try to show in the sqlform, I >>> receive a message: >>> >>> <pre> >>> <code> >>> Traceback (most recent call last): >>> File "/home/xxx.../applications/ras/controllers/appadmin.py", line >>> 269, in select >>> *fields, limitby=(start, stop)) >>> File "/home/xxx.../gluon/packages/dal/pydal/objects.py", line 2026, in >>> select >>> return adapter.select(self.query,fields,attributes) >>> File "/home/xxx.../gluon/packages/dal/pydal/adapters/mongo.py", line >>> 353, in select >>> result = processor(rows, fields, newnames, False) >>> File "/home/xxx.../gluon/packages/dal/pydal/adapters/base.py", line >>> 1596, in parse >>> value = self.parse_value(value,ft,blob_decode) >>> File "/home/xxx.../gluon/packages/dal/pydal/adapters/base.py", line >>> 1450, in parse_value >>> return self.parsemap[key](value,field_type) >>> File "/home/xxx.../gluon/packages/dal/pydal/adapters/base.py", line >>> 1472, in parse_time >>> time_items = map(int,str(value)[:8].strip().split(':')[:3]) >>> ValueError: invalid literal for int() with base 10: '2000-01-' >>> </code> >>> </pre> >>> >>> Trying to understand what happened, I'm googled for some info, and found >>> the Mongo adapter code (yes, I didn't tried in my own computer). >>> >>> Reading the code (in pydal/adapters/mongo.py), I see a (possible) clue: >>> The lines 148 to 163 is, in some way, weird for my reading. Maybe I >>> misunderstood some point, but this >>> >>> <pre> >>> <code> >>> t = datetime.time(0,0,0) >>> </code> >>> </pre> >>> >>> is a formatter for a field type DATE, and this >>> >>> <pre> >>> <code> >>> t = datetime.date(2000,1,1) >>> </code> >>> </pre> >>> >>> is a formatter for a field type TIME ? >>> >>> Best regards, and keep going the invaluable work with this framework. >>> >>> -- >>> José Ricardo Borba >>> >>> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > José Ricardo Borba > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/c8JpvzBHGhE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.