YAY !!!! Everything is working FINE! Thank you very much, Paolo, Massimo and others.
Cheers. 2015-05-04 10:39 GMT-03:00 Ron Chatterjee <achatterjee...@gmail.com>: > What is mongodb adapter? Where do I find that info? > > > On Monday, May 4, 2015 at 8:39:48 AM UTC-4, Paolo Valleri wrote: >> >> It should be fixed in trunk >> >> Paolo >> >> On Saturday, May 2, 2015 at 1:24:32 PM UTC+2, José Borba wrote: >>> >>> OK. >>> Thank you very much again. >>> >>> Cheers. >>> >>> 2015-05-02 8:22 GMT-03:00 Paolo Valleri <paolo....@gmail.com>: >>> >>>> 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" <jrbor...@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....@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+un...@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+un...@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+un...@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 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 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.
