[web2py] MongoDb Adapter issues

2012-05-17 Thread Krzysztof Mulica
Hello,
I'm having issues with the mongo adapter doing selects (using latest code 
from git.)

The initial issue i ran into was not being able to import SON in dal.py (i 
changed from pymongo to from bson and that fixed that)

After that I ran into issues with pymongo.objectid, after a little research 
I found this
http://api.mongodb.org/python/2.0/api/pymongo/objectid.html

references to pymongo.objectid should be replaced in favor of bson.objectid
when i did that in my local, everything started to work

-Kris



[web2py] Re: MongoDB Adapter error in select

2012-05-15 Thread Krzysztof Mulica
I'm guessing he's looking for something like I am, 

http://cookbook.mongodb.org/patterns/count_tags/ 

{
"title" : "A blog post",
"author" : "Kristina",
"content" : "...",
"tags" : ["MongoDB", "Map/Reduce", "Recipe"]
}



using DAL, how would I go about inserting that list, what wouldd the type 
be in the model definition?

On Sunday, May 13, 2012 8:35:43 PM UTC-5, Massimo Di Pierro wrote:
>
> I think you can already
>
> db.table.insert(**dict())
>
> Are you asking for something different?
>
> On Saturday, 12 May 2012 05:25:02 UTC-5, Francisco Costa wrote:
>>
>> It works Massimo!
>> In MongoDb is also common to insert dicts, can we also have that?
>>
>> At the moment it only saves in the string format (check player Field)
>> { "_id" : ObjectId("4fae3839b34f4brf5a31"), "city" : "Madrid", "club" 
>> : "Real Madrid", *"player" : "{'n_goals': 43, 'name': 'Ronaldo'}"* }
>>
>>
>>
>> On Friday, May 11, 2012 9:16:58 PM UTC+1, Massimo Di Pierro wrote:
>>>
>>> One more try please.
>>>
>>> On Friday, 11 May 2012 06:04:52 UTC-5, Francisco Costa wrote:

 Thanks Massimo. Please let me know if you need more help in debugging it

 On Friday, May 11, 2012 12:40:35 AM UTC+1, Massimo Di Pierro wrote:
>
> Now I understand better where all these problems come from. I shall 
> fix it tonight.
>
> On Thursday, 10 May 2012 18:02:24 UTC-5, Francisco Costa wrote:
>>
>> i didn't understand your question..
>> This is the complete code
>>
>> import sys
>> import time
>> from gluon.dal import DAL, Field
>> mongo = DAL('mongodb://localhost:27017/sapo')
>> 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')
>> mongo.user.insert(name='Jim',  age=18, city='Detroit')
>> mongo.user.insert(name='Jack', age=18)
>> mongo.user.insert(name='Eric', city='Boston')
>> return 'users in database'
>>
>> def find_users():
>> users = mongo(mongo.user.age==18).select()
>> return dict(users=users)
>>
>>