How to insert nested documents in to mongodb using python (pymongo)

Question

I want to insert nested lists/documents in to mongodb using python/pymongo. I want to insert the following in to mongodb using python. can somebody help?

customer =

 {
  'first_name' : 'Arnold',
  'last_name' :  'Pettibone',

  'addresses': [
    'home' : {
      'street' : '1234 fake street',
      'city' :   'Anytown',
      'state' :  'OH',
      'zip' :    '12345'
    },
    'work' : {
      'street' : '742 Evergreen Terrace',
      'city' :   'Springfield',
      'state' :  'OH',
      'zip':     '12345'
    }
  ]
}

I had tried myself. the code is as below.

from pymongo import MongoClient

try: conn = MongoClient() print("Connected successfully!!!") except:
print("Could not connect to MongoDB")

database

db = conn.database

Created or Switched to collection names: my_collection

collection = db.my_collection 

customer = {
  'first_name' : 'Arnold',
  'last_name' :  'Petti',

  'addresses': [
    'home' : {
      'street' : '1234 fake street',
      'city' :   'Anytown',
      'state' :  'OH',
      'zip' :    '12345'
    },
    'work' : {
      'street' : '742 Evergreen Terrace',
      'city' :   'Springfield',
      'state' :  'OH',
      'zip':     '12345'
    }
  ]
}

Insert Data

rec_id1 = collection.insert(customer)

print("Data inserted with record ids",rec_id1)

Printing the data inserted

cursor = collection.find()

for record in cursor: 
    print(record)

but it shows following error:

File "emo.py", line 20
    'home' : {
           ^
syntax error : invalid syntax'

swetha reddy · Accepted Answer · 2018-10-03 11:14:59Z

3

I got it. I was missing braces.I have made changes below.

{
 'first_name' : 'Arnold',
 'last_name' :  'Pettibone',

 'addresses': [{
 'home' : {
    'street' : '1234 fake street',
    'city' :   'Anytown',
    'state' :  'OH',
    'zip' :    '12345'
  },
 'work' : {
    'street' : '742 Evergreen Terrace',
    'city' :   'Springfield',
    'state' :  'OH',
    'zip':     '12345'
  }
 }]
}

edited Oct 3, 2018 at 11:14

answered Sep 25, 2018 at 6:56

swetha reddy

2018 silver badges19 bronze badges

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

Comments

Xiao Tan · Accepted Answer · 2018-09-24 11:19:30Z

1

MongoDB is a non-relational database, you can store the document with any schema in JSON format.

conn = pymongo.MongoClient('localhost')  # replace localhost with the real address
db = conn['db_name']
db['collection_name'].insert_one({'x': 1})  # replace {'x': 1} with `customer`

http://api.mongodb.com/python/current/api/pymongo/collection.html#pymongo.collection.Collection.insert_one

answered Sep 24, 2018 at 11:19

Xiao Tan

4605 silver badges13 bronze badges

1 Comment

swetha reddy Over a year ago

i am getting the same error as i have mentioned above.

Collectives™ on Stack Overflow

How to insert nested documents in to mongodb using python (pymongo)

database

Created or Switched to collection names: my_collection

Insert Data

Printing the data inserted

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

database

Created or Switched to collection names: my_collection

Insert Data

Printing the data inserted

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related