Retrieving data from python mongo db

Question

I have inserted

{
   "apples": 430,
   "bananas": 312,
   "oranges": 525,
   "pears": 217
}

to mongodb in python. However, I tried a lot ways to get value by key

If I want to get values for "apple", how would I achieve that?

Are you using the official module for Python and MongoDB (PyMongo) or an alternative module to access your database? — Jose Roman
– Jose Roman, Commented May 27, 2017 at 17:15
hi, I am not using any framework. I am just using regular Python. I followed tutorial api.mongodb.com/python/current/tutorial.html but could not find anything that solves my problem. Thank you — Samun
– Samun, Commented May 27, 2017 at 17:26

Holle van · Accepted Answer · 2017-05-27 17:32:05Z

1

Values in MongoDB are stored in a json format.
If you want to query from a MongoDB database, I'd recommend using PyMongo.
I'll assume you can read by yourself how to connect to the database.
The query you're looking for is as follows

apples = db.collection.distinct("base.apples")
result = db.collection.distinct("result")

In case apples shows in other places, ofcourse.

answered May 27, 2017 at 17:32

Holle van

1391 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Holle van Over a year ago

@SamThapa I'm glad!

Collectives™ on Stack Overflow

Retrieving data from python mongo db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related