Storing json data into a variable using python when inserting into mongoDB

Question

from pymongo import MongoClient

client = MongoClient()
db = client.test
coll = db.dataset

from datetime import datetime
result = db.restaurants.insert_one(
    {
        "address": {
            "street": "2 Avenue", 
            "zipcode": "10075",
            "building": "1480",
            "coord": [-73.9557413,40.7720266]
        },
        "borough": "Manhattan", 
        "cuisine": "Italian", 
        "grades": [
            {
                "date": datetime.strptime("2014-10-01", "%Y-%m-%d"),
                "grade": "A", 
                "score": 11
            },
            {
                "date": datetime.strptime("2014-01-16", "%Y-%m-%d"),
                "grade": "B", 
                "scroe": 17
            }

        ],
        "name": "Vella", 
        "restaurant_id": "41704620"
    }
 )

result.inserted_id

I have a python code mentioned above. Here, I inserted a document to MongoDB by using insert_one(). My question is how can I store that data in a variable and use the variable in the insert_one() method? For.eg, db.restaurants.insert_one(somthng) where somthng is the variable that will be storing the document.

A. Jesse Jiryu Davis · Accepted Answer · 2017-03-22 04:00:41Z

2

Is this what you mean?

something = {
        "address": {
            "street": "2 Avenue", 
            "zipcode": "10075",
            "building": "1480",
            "coord": [-73.9557413,40.7720266]
        },
        "borough": "Manhattan", 
        "cuisine": "Italian", 
        "grades": [
            {
                "date": datetime.strptime("2014-10-01", "%Y-%m-%d"),
                "grade": "A", 
                "score": 11
            },
            {
                "date": datetime.strptime("2014-01-16", "%Y-%m-%d"),
                "grade": "B", 
                "scroe": 17
            }

        ],
        "name": "Vella", 
        "restaurant_id": "41704620"
    }

result = db.restaurants.insert_one(something)

edited Mar 22, 2017 at 4:00

A. Jesse Jiryu Davis

24.1k5 gold badges60 silver badges72 bronze badges

answered Mar 22, 2017 at 2:40

jyap

1,6041 gold badge12 silver badges5 bronze badges

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

1 Comment

Barani Myat Tun Over a year ago

yes! @jyap Thank you very much! I'm new to python.. :)

Collectives™ on Stack Overflow

Storing json data into a variable using python when inserting into mongoDB

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