Re: [web2py] Re: MongoDB

2018-11-19 Thread Anthony 
https://github.com/web2py/web2py/issues

On Monday, November 19, 2018 at 10:08:52 AM UTC-5, Lovedie JC wrote:
>
> how and where do I open this issue?
> Regards
>
> On Mon, 19 Nov 2018 at 17:46, Anthony  wrote:
>
>> web2py sets cacheable=True for queries it does in the IS_IN_DB validator 
>> as well as in SQLFORM.grid. Please open an issue about this.
>>
>> Anthony
>>
>> On Monday, November 19, 2018 at 8:22:21 AM UTC-5, Lovedie JC wrote:
>>>
>>> I've gone through the code and I haven't done any caching in selects but 
>>> still getting the message.
>>>
>>> On Mon, 12 Nov 2018, 18:04 Leonel Câmara wrote:
>>>
 Don't use cache and cacheable in your selects.

 -- 
 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.

>>> -- 
>> 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.
>>
>

-- 
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.

Re: [web2py] Re: MongoDB

2018-11-19 Thread Lovedie JC 
how and where do I open this issue?
Regards

On Mon, 19 Nov 2018 at 17:46, Anthony  wrote:

> web2py sets cacheable=True for queries it does in the IS_IN_DB validator
> as well as in SQLFORM.grid. Please open an issue about this.
>
> Anthony
>
> On Monday, November 19, 2018 at 8:22:21 AM UTC-5, Lovedie JC wrote:
>>
>> I've gone through the code and I haven't done any caching in selects but
>> still getting the message.
>>
>> On Mon, 12 Nov 2018, 18:04 Leonel Câmara wrote:
>>
>>> Don't use cache and cacheable in your selects.
>>>
>>> --
>>> 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.
>>>
>> --
> 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.
>

-- 
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.

Re: [web2py] Re: MongoDB

2018-11-19 Thread Anthony 
web2py sets cacheable=True for queries it does in the IS_IN_DB validator as 
well as in SQLFORM.grid. Please open an issue about this.

Anthony

On Monday, November 19, 2018 at 8:22:21 AM UTC-5, Lovedie JC wrote:
>
> I've gone through the code and I haven't done any caching in selects but 
> still getting the message.
>
> On Mon, 12 Nov 2018, 18:04 Leonel Câmara wrote:
>
>> Don't use cache and cacheable in your selects.
>>
>> -- 
>> 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.
>>
>

-- 
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.

Re: [web2py] Re: MongoDB

2018-11-19 Thread Lovedie JC 
I've gone through the code and I haven't done any caching in selects but
still getting the message.

On Mon, 12 Nov 2018, 18:04 Leonel Câmara  Don't use cache and cacheable in your selects.
>
> --
> 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.
>

-- 
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.

Re: [web2py] Re: MongoDB

2015-05-07 Thread José Ricardo Borba 
Yes, I did!
Thanks for the advice.

But submodule when cloning web2py still doesn't work.

Best regards,

2015-05-07 16:25 GMT-03:00 Paolo Valleri :

> update your local copy of pydal, there are several updates regarding mongo
> in master branch
>
>
>  Paolo
>
> 2015-05-07 21:14 GMT+02:00 José Ricardo Borba :
>
>> Allright!
>>
>> Updating pymongo to version 3.0 solves this up!
>>
>> Now I take care of the mongo time / pydal issue!
>>
>> Thanks a lot.
>>
>>
>> 2015-05-07 9:05 GMT-03:00 Paolo Valleri :
>>
>>> You should use pymongo 3.0
>>>
>>>
>>> On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote:

 I'm very busy in these days, but I tried to start a new "installation"
 from the ground (to test the TIME issue with Mongodb in pydal #170), but
 even without this correction (i.e, with plain web2py clone from github) I
 receive the below error message.

 I'm simply copy the application folder to the new installation
 (side-by-side with welcome and examples). With CLI client (mongo)
 everything works fine.

 The welcome app works fine.

 I see that pydal tries to connect 5 times. The string to connect to
 mongo is fine (since is a local install. In production will have an user
 and a password too...).
 Version  web2py™ Version 2.10.4-stable+timestamp.2015.04.26.09.05.21
 Traceback

 Traceback (most recent call last):
   File "/home/mydir/w2p210b/gluon/restricted.py", line 227, in restricted
 exec ccode in environment
   File "/home/mydir/w2p210b/applications/rastreamento/models/db.py" 
 , line 
 12, in 
 db = DAL('mongodb://localhost/telemet', pool_size=0, lazy_tables=True)
   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 174, 
 in __call__
 obj = super(MetaDAL, cls).__call__(*args, **kwargs)
   File "/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 459, in 
 __init__
 raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
 (attempts, tb))
 RuntimeError: Failure to connect, tried 5 times:
 Traceback (most recent call last):
   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 437, 
 in __init__
 self._adapter = ADAPTERS[self._dbname](**kwargs)
   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/base.py", 
 line 57, in __call__
 obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/mongo.py", 
 line 58, in __init__
 from pymongo.write_concern import WriteConcern
   File "/home/mydir/w2p210b/gluon/custom_import.py", line 108, in 
 custom_importer
 return NATIVE_IMPORTER(name, globals, locals, fromlist, level)
 ImportError: No module named write_concern




 Best regards,
 --
 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/3q5CfUSPQ1o/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.
>



-- 
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 th

Re: [web2py] Re: MongoDB adapter

2015-05-07 Thread José Ricardo Borba 
YAY 

Everything is working FINE!
Thank you very much, Paolo, Massimo and others.

Cheers.

2015-05-04 10:39 GMT-03:00 Ron Chatterjee :

> 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 :
>>>
 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" 
 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 :
>
>> 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:
>>>
>>> 
>>> 
>>>   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-'
>>> 
>>> 
>>>
>>> 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
>>>
>>> 
>>> 
>>> t = datetime.time(0,0,0)
>>> 
>>> 
>>>
>>> is a formatter for a field type DATE, and this
>>>
>>> 
>>> 
>>> t = datetime.date(2000,1,1)
>>> 
>>> 
>>>
>>> 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, vis

Re: [web2py] Re: MongoDB

2015-05-07 Thread Paolo Valleri 
update your local copy of pydal, there are several updates regarding mongo
in master branch


 Paolo

2015-05-07 21:14 GMT+02:00 José Ricardo Borba :

> Allright!
>
> Updating pymongo to version 3.0 solves this up!
>
> Now I take care of the mongo time / pydal issue!
>
> Thanks a lot.
>
>
> 2015-05-07 9:05 GMT-03:00 Paolo Valleri :
>
>> You should use pymongo 3.0
>>
>>
>> On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote:
>>>
>>> I'm very busy in these days, but I tried to start a new "installation"
>>> from the ground (to test the TIME issue with Mongodb in pydal #170), but
>>> even without this correction (i.e, with plain web2py clone from github) I
>>> receive the below error message.
>>>
>>> I'm simply copy the application folder to the new installation
>>> (side-by-side with welcome and examples). With CLI client (mongo)
>>> everything works fine.
>>>
>>> The welcome app works fine.
>>>
>>> I see that pydal tries to connect 5 times. The string to connect to
>>> mongo is fine (since is a local install. In production will have an user
>>> and a password too...).
>>> Version  web2py™ Version 2.10.4-stable+timestamp.2015.04.26.09.05.21
>>> Traceback
>>>
>>> Traceback (most recent call last):
>>>   File "/home/mydir/w2p210b/gluon/restricted.py", line 227, in restricted
>>> exec ccode in environment
>>>   File "/home/mydir/w2p210b/applications/rastreamento/models/db.py" 
>>> , line 
>>> 12, in 
>>> db = DAL('mongodb://localhost/telemet', pool_size=0, lazy_tables=True)
>>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 174, in 
>>> __call__
>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>>   File "/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 459, in 
>>> __init__
>>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>>> (attempts, tb))
>>> RuntimeError: Failure to connect, tried 5 times:
>>> Traceback (most recent call last):
>>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 437, in 
>>> __init__
>>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/base.py", 
>>> line 57, in __call__
>>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/mongo.py", 
>>> line 58, in __init__
>>> from pymongo.write_concern import WriteConcern
>>>   File "/home/mydir/w2p210b/gluon/custom_import.py", line 108, in 
>>> custom_importer
>>> return NATIVE_IMPORTER(name, globals, locals, fromlist, level)
>>> ImportError: No module named write_concern
>>>
>>>
>>>
>>>
>>> Best regards,
>>> --
>>> 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/3q5CfUSPQ1o/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.

Re: [web2py] Re: MongoDB

2015-05-07 Thread José Ricardo Borba 
Allright!

Updating pymongo to version 3.0 solves this up!

Now I take care of the mongo time / pydal issue!

Thanks a lot.


2015-05-07 9:05 GMT-03:00 Paolo Valleri :

> You should use pymongo 3.0
>
>
> On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote:
>>
>> I'm very busy in these days, but I tried to start a new "installation"
>> from the ground (to test the TIME issue with Mongodb in pydal #170), but
>> even without this correction (i.e, with plain web2py clone from github) I
>> receive the below error message.
>>
>> I'm simply copy the application folder to the new installation
>> (side-by-side with welcome and examples). With CLI client (mongo)
>> everything works fine.
>>
>> The welcome app works fine.
>>
>> I see that pydal tries to connect 5 times. The string to connect to mongo
>> is fine (since is a local install. In production will have an user and a
>> password too...).
>> Version  web2py™ Version 2.10.4-stable+timestamp.2015.04.26.09.05.21
>> Traceback
>>
>> Traceback (most recent call last):
>>   File "/home/mydir/w2p210b/gluon/restricted.py", line 227, in restricted
>> exec ccode in environment
>>   File "/home/mydir/w2p210b/applications/rastreamento/models/db.py" 
>> , line 
>> 12, in 
>> db = DAL('mongodb://localhost/telemet', pool_size=0, lazy_tables=True)
>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 174, in 
>> __call__
>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>   File "/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 459, in 
>> __init__
>> raise RuntimeError("Failure to connect, tried %d times:\n%s" % 
>> (attempts, tb))
>> RuntimeError: Failure to connect, tried 5 times:
>> Traceback (most recent call last):
>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/base.py", line 437, in 
>> __init__
>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/base.py", line 
>> 57, in __call__
>> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>   File "/home/mydir/w2p210b/gluon/packages/dal/pydal/adapters/mongo.py", 
>> line 58, in __init__
>> from pymongo.write_concern import WriteConcern
>>   File "/home/mydir/w2p210b/gluon/custom_import.py", line 108, in 
>> custom_importer
>> return NATIVE_IMPORTER(name, globals, locals, fromlist, level)
>> ImportError: No module named write_concern
>>
>>
>>
>>
>> Best regards,
>> --
>> 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.

Re: [web2py] Re: MongoDB adapter

2015-05-04 Thread Ron Chatterjee 
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 :
>>
>>> 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"  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 :

> 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:
>>
>> 
>> 
>>   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-'
>> 
>>  
>>
>> 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
>>
>> 
>> 
>> t = datetime.time(0,0,0)
>> 
>>  
>>
>> is a formatter for a field type DATE, and this 
>>
>> 
>> 
>> t = datetime.date(2000,1,1)
>> 
>>  
>>
>> 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)
>>>

Re: [web2py] Re: MongoDB adapter

2015-05-04 Thread Paolo Valleri 
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 
> >:
>
>> 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" > > 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 >> >:
>>>
 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:
>
> 
> 
>   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-'
> 
>  
>
> 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
>
> 
> 
> t = datetime.time(0,0,0)
> 
>  
>
> is a formatter for a field type DATE, and this 
>
> 
> 
> t = datetime.date(2000,1,1)
> 
>  
>
> 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://group

Re: [web2py] Re: MongoDB adapter

2015-05-02 Thread José Ricardo Borba 
OK.
Thank you very much again.

Cheers.

2015-05-02 8:22 GMT-03:00 Paolo Valleri :

> 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"  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 :
>>
>>> 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:

 
 
   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-'
 
 

 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

 
 
 t = datetime.time(0,0,0)
 
 

 is a formatter for a field type DATE, and this

 
 
 t = datetime.date(2000,1,1)
 
 

 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.
>



-- 
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 ar

Re: [web2py] Re: MongoDB adapter

2015-05-02 Thread Paolo Valleri 
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"  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 :
>
>> 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:
>>>
>>> 
>>> 
>>>   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-'
>>> 
>>> 
>>>
>>> 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
>>>
>>> 
>>> 
>>> t = datetime.time(0,0,0)
>>> 
>>> 
>>>
>>> is a formatter for a field type DATE, and this
>>>
>>> 
>>> 
>>> t = datetime.date(2000,1,1)
>>> 
>>> 
>>>
>>> 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.

Re: [web2py] Re: MongoDB adapter

2015-05-02 Thread José Ricardo Borba 
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 :

> 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:
>>
>> 
>> 
>>   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-'
>> 
>> 
>>
>> 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
>>
>> 
>> 
>> t = datetime.time(0,0,0)
>> 
>> 
>>
>> is a formatter for a field type DATE, and this
>>
>> 
>> 
>> t = datetime.date(2000,1,1)
>> 
>> 
>>
>> 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 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.

Re: [web2py] Re: MongoDb

2013-12-30 Thread Alan Etkin 


> Thanks for the answer. Luckily there are no joins, but I need to see what 
> web2py features of DAL won't work.
>

To my knowledge, you cannot use the scheduler or Auth.accessible_query, 
everything else not requiring join queries should work.

-- 
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/groups/opt_out.

Re: [web2py] Re: MongoDb

2013-12-30 Thread Tushar Tuteja 
Hey,
Thanks for the answer. Luckily there are no joins, but I need to see what
web2py features of DAL won't work.
Thanks,
Regards,
Tushar Tuteja



On 30 December 2013 16:44, Alan Etkin  wrote:

> I have an app running on MySQL , I want to use mongoDB instead.
>> I want to help on migration from mysql to mongoDB.
>> Thanks,
>>
>
> Beware that mongodb adapter is in an experimental stage of development, so
> you should know what you are doing before migrating. I suppose there are
> lots of howtos for migrating data between those backends. The web2py way of
> doing has two options, AFAIK:
>
> - use cpdb (never tried it with those connections)
> - use DAL.import_from_csv_file and DAL.export_from_csv_file methods (for a
> small amount of db records)
>
> Mind that the most important issue is that mongodb is not a relational
> database management system and there's no such thing as JOIN queries. This
> is a limitation for web2py also, since some of the web2py features require
> joins to work.
>
>  --
> 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/oPCXZnnFvyI/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/groups/opt_out.
>



-- 
Tushar Tuteja
Undergraduate Student(Fourth Year)
Civil Engineering
IIT Delhi
+919953061943
ttut...@gmail.com 
ce1090...@civil.iitd.ernet.in
"The question isn't who is going to let me; its who is going to stop me!" -
Howard Roark

-- 
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/groups/opt_out.

Re: [web2py] Re: MongoDB Adapter error in select

2012-05-10 Thread Francisco Costa 
I've enumerated fields and colnames and they are like this:

fields:
id
text
integer
string


colnames:
city
age
_id
name


 I believe they don't match and thats why there's this error:


File "/opt/web2py/gluon/dal.py", line 8134, in select
return adapter.select(self.query,fields,attributes)
File "/opt/web2py/gluon/dal.py", line 4711, in select
 return processor(rows,fields,colnames,False)
File "/opt/web2py/gluon/dal.py", line 1681, in parse
self.parse_value(value, fields[j].type,blob_decode)
File "/opt/web2py/gluon/dal.py", line 1575, in parse_value
return self.parsemap[key](value,field


_type)
  File "/opt/web2py/gluon/dal.py", line 1641, in parse_id

return int(value)
ValueError: invalid literal for int() with base 10: 'Toronto'




Francisco Costa
http://franciscocosta.com



On Thu, May 10, 2012 at 7:03 AM, kokoyo  wrote:

> Hi Massimo, i did it and get output (test on user_auth table):
>
> mongoqry_dict ={'email': 'myem...@gmail.com'}
> mongofields_dict = SON([('id':1), ('first_name':1),  ('last_name':
> 1),  ('email':1), ('password':1), ('registration_key':
> 1), ('reset_password_key':1), ('registration_id':1) ])
> mongo_list_dicts = 
>
>
>
> On Thursday, May 10, 2012 1:52:02 PM UTC+9, Massimo Di Pierro wrote:
>>
>> Should be an easy fix but I need your help. Before line 4711 of dal.py
>>
>> return processor(rows,fields,**colnames,False)
>>
>> can you add
>>
>> print rows
>> print fields
>> print colnames
>>
>> what is the output when it fails?
>>
>>
>> On Wednesday, 9 May 2012 05:42:56 UTC-5, Francisco Costa wrote:
>>>
>>> I've enumerated fields and colnames and they are like this:
>>>
>>> fields:
>>> id
>>> text
>>> integer
>>> string
>>>
>>>
>>> colnames:
>>> city
>>> age
>>> _id
>>> name
>>>
>>>
>>>  I believe they don't match and thats why there's this error:
>>>
>>> File "/opt/web2py/gluon/dal.py", line 8134, in select
>>> return adapter.select(self.query,fiel**ds,attributes)
>>> File "/opt/web2py/gluon/dal.py", line 4711, in select
>>>  return processor(rows,fields,colnames**,False)
>>> File "/opt/web2py/gluon/dal.py", line 1681, in parse
>>> self.parse_value(value, fields[j].type,blob_decode)
>>> File "/opt/web2py/gluon/dal.py", line 1575, in parse_value
>>> return self.parsemap[key](value,field
>>>
>>>
>>> _type)
>>>   File "/opt/web2py/gluon/dal.py", line 1641, in parse_id
>>>
>>> return int(value)
>>> ValueError: invalid literal for int() with base 10: 'Toronto'
>>>
>>>
>>>
>>>
>>>
>>> On Monday, May 7, 2012 11:40:36 PM UTC+1, Massimo Di Pierro wrote:

 Please try again.

 On Monday, 7 May 2012 15:48:04 UTC-5, Francisco Costa wrote:
>
> missing a colon at the end of the line 4677
>
> if key == 'id'
>
>
> and now I get this error
>
>   File "/opt/web2py/gluon/dal.py", line 8134, in select
>
> return adapter.select(self.query,fiel**ds,attributes)
>
>   File "/opt/web2py/gluon/dal.py", line 4711, in select
>
> return processor(rows,columns,False)
>
>   File "/opt/web2py/gluon/dal.py", line 1675, in parse
>
> for j,colname in enumerate(colnames):
> TypeError: 'bool' object is not iterable
>
>
> maybe because of the False on line 4711
>
>
>
>
> On Monday, May 7, 2012 9:27:35 PM UTC+1, Massimo Di Pierro wrote:
>>
>> Thanks for your help and check on this. I just committed a fix in
>> trunk that should address it. Please let me know.
>>
>> On Monday, 7 May 2012 15:19:40 UTC-5, Francisco Costa wrote:
>>>
>>> I think that the mongofields_dict.keys() don't match to the data in
>>> the rows
>>>
>>> mongofields_dict:
>>> id
>>> name
>>> age
>>> city
>>> rows:
>>> Toronto
>>> 66L
>>> 24652490551171733682233802752L
>>> John
>>>
>>>
>>> On Monday, May 7, 2012 8:42:33 PM UTC+1, Massimo Di Pierro wrote:

 Your linennumbers do not much the code in trunk. Please try the
 code in trunk. Anyway, something goes wrong in the parse(self, rows,
 fields, colnames, blob_decode=True) function. I suspect mongo does not
 return the columns in the order web2py think it does. Can you print the
 input of the parse function?

 On Monday, 7 May 2012 13:20:39 UTC-5, Francisco Costa wrote:
>
> So I have this:
>
> import sys
> import time
> from gluon.dal import DAL, Field
> mongo = DAL('mongodb://localhost:**27017/tymr')
> mongo.define_table('user',
>  Field('name', 'text'),
>  Field('age',  'integer'),
>  Field('city', 'string')
>  )
>
> def insert_users():
> mongo.user.insert(name='John', age=66, city='Toronto')
> mongo.user.insert(name='Mark', age=43, city='Boston')
> mongo.user.insert(name='Tom',  age=43, city='Detroit')
>

Re: [web2py] Re: MongoDB and Web2py

2011-10-12 Thread ~redShadow~ 
On Wed, 2011-10-12 at 04:07 -0700, David Marko wrote:
> Massimo adviced me to use something like this previsously: 
> 
> def make_connection(): 
>  from pymongo import Connection 
>  connection = Connection('localhost', 27017) 
>  return connection 
> 
> connection = cache.ram('mongodb',make_connection,None) 
> 
> It seemed to work but I had no opportunity to test it under some
> load.  This is some kind of connection pooling/share

What about using the standard DAL with MongoDBAdapter to manage the
connection pool and then use the pymongo.Connection() in
db._adapter.connection to directly operate on the database?
I haven't tested yet (for now I'm just doing experiments, so I don't
need connection pool), but looks like this should work..

-- 
Samuele ~redShadow~ Santi

 redshadow[at]hackzine.org - redshadowhack[at]gmail.com

  Blog: http://hackzine.org

  GPG Key signature:
   050D 3E9F 6E0B 44CE C008 D1FC 166C 3C7E EB26 4933

/me recommends:
Squadra Informatica - http://www.squadrainformatica.com

 - Proud ThinkPad T-Series owner
 - Registered Linux-User: #440008
  * GENTOO User since 1199142000 (2008-01-01)
  * former DEBIAN SID user

  "Software is like sex: it's better when it's free!"
  -- Linus Torvalds



signature.asc
Description: This is a digitally signed message part

Re: [web2py] Re: MongoDB and Web2py

2011-10-02 Thread Bruno Rocha 
I used that for some samples and talks, also for a small project. as I I am
not doing advanced operations I cant say if it works or not. But for my
sample needs worked very well.

On Sun, Oct 2, 2011 at 7:39 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:

> At this time my priority is to finish document the rest of
> undocumented web2py features. I will work on this as soon as I finish
> that.
>
> Anyway, in dal.py there is a mongodb adapter. It can only do insert.
> Has anybody tried that?
>
> massimo
>
> On Oct 2, 4:52 pm, Francisco Costa  wrote:
> > I don't want to spam the group about this, but I would like to have
> > some official incites about when will the DAL have a MongoDB Adapter.
> >
> > Since this is the most requested feature by the web2py communityhttp://
> web2py.uservoice.com/forums/42577-generalare there any plans
> > or schedule for this support?
>



-- 



--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]

Re: [web2py] Re: MongoDB supported by DAL

2011-08-04 Thread pbreit 
Someone probably needs to step up and try to work it out. I don't think it's 
going to get done with periodic status inquiries here.

Re: [web2py] Re: MongoDB supported by DAL

2011-08-04 Thread António Ramos 
Mongo over couch?
Why?

2011/8/4 Francisco Costa 

> On Aug 4, 3:46 pm, David Marko  wrote:
> > Also inteersted here. Can afford some time for testing ...
>
> This would be great to have.
> MongoDb is being widely adopted by a larger number of organizations.
> If DAL could support MongoDB, it would have a major impact in some
> development companies.

Re: [web2py] Re: MongoDB and Web2Py

2011-04-04 Thread David J. 


Thanks Massimo;

I never thought to even try this;
I will make a sample project and test this;
(For me the other way works; so I wouldn't ask that you implement it in 
DAL; (but I am happy to test it;)


Thanks for your great software.

David.





On 4/4/11 9:24 AM, Massimo Di Pierro wrote:

DAL allows to do:

db=DAL('mongodb://127.0.0.1:5984/db')

it allows to define_table and allows db.table.insert(...) other
methods have not been implemented because the above was never tested.
If you help us with testing I can implement the other methods (select,
count, update).

On Apr 1, 9:55 am, "David J."  wrote:

While DAL might not support MongDB; you can still use it via mongoengine;

On 4/1/11 10:41 AM, Marcel Luethi wrote:








Despite a lot of time, I'd like to help as well.
MongoDB looks promising.
On 1 Apr., 04:58, Massimo Di Pierro
wrote:

Lots of people asked for support but nobody volunteered to help test
it.
If you are interested and can help with some regular tests we can make
it work in relatively short time.
Massimo
On Mar 31, 9:09 pm, luckysmackwrote:

I have read a few older messages about mongoDB being made to work with
the DAL. But they all seem to be pretty dated and have not specified
what was working and what wasnt. massimo menitoned that it may be
ready by january of this year. But under the supported list it wasnt
listed. So im just curious as to what the status of using mongoDB is
with web2py and if anyone has a basic example on how I would use it.
Thanks

Re: [web2py] Re: MongoDB and Web2Py

2011-04-04 Thread Ahmed Bani 



I will test it for my new application: x2py = a web2py-powered web-based email 
client.

Yet, another web-based email client!

Re: [web2py] Re: MongoDB and Web2Py

2011-04-01 Thread David J. 

While DAL might not support MongDB; you can still use it via mongoengine;




On 4/1/11 10:41 AM, Marcel Luethi wrote:

Despite a lot of time, I'd like to help as well.
MongoDB looks promising.




On 1 Apr., 04:58, Massimo Di Pierro
wrote:

Lots of people asked for support but nobody volunteered to help test
it.
If you are interested and can help with some regular tests we can make
it work in relatively short time.

Massimo

On Mar 31, 9:09 pm, luckysmack  wrote:








I have read a few older messages about mongoDB being made to work with
the DAL. But they all seem to be pretty dated and have not specified
what was working and what wasnt. massimo menitoned that it may be
ready by january of this year. But under the supported list it wasnt
listed. So im just curious as to what the status of using mongoDB is
with web2py and if anyone has a basic example on how I would use it.
Thanks

Re: [web2py] Re: MongoDB and Web2Py

2011-04-01 Thread Tom Atkins 
+1

On 1 April 2011 06:35, David Marko  wrote:

> I'm also interested in testing ...
>
> David Marko
>

Re: [web2py] Re: mongoDb

2010-11-25 Thread Bruno Rocha 
also, response._caller can be useful to raise the disconnection

2010/11/25 Bruno Rocha 

> from pymongo import Connection
> ...
> ...
> connection = Connection()
> ...
> ...
> ...
> ...
> connection.disconnect()
>
> In some controllers I tried to keep connection in session or cache, but it
> fails.
>
> 2010/11/25 David Marko 
>
> Where do you store the Pymongo connection object between requests? In
>> some cache object?
>>
>> David
>>
>> On 25 lis, 16:16, Bruno Rocha  wrote:
>> > I am using PyMongo for one projecthttp://
>> api.mongodb.org/python/1.9%2B/index.html
>> >
>> > I put the libs in modules and created some methods in my /models to
>> abstract
>> > commom tasks, PyMongo is very simple, so it is easy to access the data
>> > directly form controllers or views using its API.
>> >
>> > 2010/11/25 Aurigadl 
>> >
>> > > In my projects I'm using MongoDB
>> > > I need to work with this tool
>> > > you need this to work with web2py? Make controller for this
>> > > RDBMS or or this tool work wiht this
>> >
>> > --
>> >
>> > Bruno Rochahttp://about.me/rochacbruno/bio
>>
>
>
>
> --
>
> Bruno Rocha
> http://about.me/rochacbruno/bio
>



-- 

Bruno Rocha
http://about.me/rochacbruno/bio

Re: [web2py] Re: mongoDb

2010-11-25 Thread Bruno Rocha 
from pymongo import Connection
...
...
connection = Connection()
...
...
...
...
connection.disconnect()

In some controllers I tried to keep connection in session or cache, but it
fails.

2010/11/25 David Marko 

> Where do you store the Pymongo connection object between requests? In
> some cache object?
>
> David
>
> On 25 lis, 16:16, Bruno Rocha  wrote:
> > I am using PyMongo for one projecthttp://
> api.mongodb.org/python/1.9%2B/index.html
> >
> > I put the libs in modules and created some methods in my /models to
> abstract
> > commom tasks, PyMongo is very simple, so it is easy to access the data
> > directly form controllers or views using its API.
> >
> > 2010/11/25 Aurigadl 
> >
> > > In my projects I'm using MongoDB
> > > I need to work with this tool
> > > you need this to work with web2py? Make controller for this
> > > RDBMS or or this tool work wiht this
> >
> > --
> >
> > Bruno Rochahttp://about.me/rochacbruno/bio
>



-- 

Bruno Rocha
http://about.me/rochacbruno/bio