I need read 2 collections data from MongoDB in Python, is there any way to join data in python?
2
-
1Welcome to Stack Overflow! Please try something out first and show us an minimal code example... stackoverflow.com/help/how-to-askphrogg– phrogg2018-09-25 05:50:46 +00:00Commented Sep 25, 2018 at 5:50
-
Similar to this perhaps : stackoverflow.com/q/2350495/9144250elpidaguy– elpidaguy2018-09-28 08:36:37 +00:00Commented Sep 28, 2018 at 8:36
Add a comment
|
2 Answers
Let's say that we have two collections(tables):
- buy_orders
- sell_orders
Those tables have the same field 'id_transaction' , and we want to join those tables on this field:
import pymongo
my_client = pymongo.MongoClient('mongodb://localhost:27017/')
my_db = my_client['Orders']
my_collection = my_db['buy_orders']
result = my_collection.aggregate([{
'$lookup' : {'from': 'sell_orders','localField': 'id_transaction','foreignField': 'id_transaction','as': 'results' }
}])
To print results:
for item in result:
print(item)
For more references: MongoDB Docs and PyMongo Docs
Comments
Have a look here
from bson.objectid import ObjectId
#the custom_id for reference
custom_id = ObjectId()
#creating user with the role admin
db.users.insert_one({"name": "Boston", "role_id": custom_id})
#Creating role with the custom id
db.roles.insert_one({"_id": custom_id, "name": "Admin")}
#lookup usage
db.users.aggregate([
{
"$lookup":
{
"from": "roles",
"localField": "role_id",
"foreignField": "_id",
"as": "roles"
}
}
])
