Its an interesting topic. I am yet to figure out how mongodb handles many
to many relationship. For example, the facebook app that Massimo posted. It
utilizes many-to-many relationship using a junction table call "link" to
tie the "target" and "source" field to auth_user. Every where I read, they
say mongo is better to design such scenario. Will be interesting to know.
Thanks for this post Jose.
On Friday, May 29, 2015 at 9:51:14 PM UTC-4, José Borba wrote:
>
> Closing with success....
>
> If more people need to import data from CSV files and need to reference
> other collections in MongoDB, just prepare the file in the way described
> below (recipe).
>
> In a separate file (py) do this
> - search your term in MongoDB collection of your choice;
> - convert the _id in int from hex [ like int('deadbeef',16) ];
> - convert the int in str;
> - save your csv with this string (shoul be the Looooooong integer above);
> - import the file!
>
> This is the code I've used to do this.
> https://gist.github.com/jrborbars/63a82486bdddfc13e365
>
> Best regards,
>
>
> 2015-05-29 22:12 GMT-03:00 José Ricardo Borba <[email protected]
> <javascript:>>:
>
>> Hummmmm.......
>>
>> Seems that web2py converts the hex _id of ObjectId to the Loooooooooong
>> integer that represent that number.
>>
>> So, this is not an issue. I need to think again.......
>>
>> Best regards,
>>
>> 2015-05-29 18:22 GMT-03:00 José Ricardo Borba <[email protected]
>> <javascript:>>:
>>
>>> Hello all,
>>>
>>> I'm experiencing some issues with web2py and MongoDB 3.0.3 _id field.
>>>
>>> With web2py 2.10.4 the _id field (ObjectId) is showed in this way:
>>>
>>> 26418130264307745716389872944
>>> 26418130264307745716389872963
>>> .
>>> .
>>>
>>>
>>> With Ipython 3.1.0 (with [python2.7.9 or 3.4.3 and pymongo] OR mongodb
>>> shell 3.0.3) the _id field (ObjectId) is showed in this way:
>>>
>>> 555c90af47439f0958f10530
>>> 555c90af47439f0958f10543
>>> .
>>> .
>>>
>>> I think that the last is the correct way to show the _id, because both
>>> pymongo and mongoshell showed the same. But why the web2py is not showing
>>> the correct _id? Maybe I'm doing something wrong?
>>>
>>> The last record was imported from a CSV file, and the first was inserted
>>> from web2py form (from SQLGRID).
>>>
>>> Best regards,
>>>
>>> --
>>> José Ricardo Borba
>>>
>>>
>>
>>
>> --
>> José Ricardo Borba
>>
>>
>
>
> --
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
