MongoDB Python – Insert and Replace Operations
Prerequisites : MongoDB Python Basics
This article focus on how to replace document or entry inside a collection. We can only replace the data already inserted in the database.
Method used : replace_one() and replace_many()
Aim: Replace entire data of old document with new document
Insertion In MongoDB
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
We would first insert data in MongoDB.
# Python code to illustrate# Insert in MongoDBfrom pymongo import MongoClient try: conn = MongoClient() print("Connected successfully!!!")except: print("Could not connect to MongoDB") # databasedb = conn.database # Created or Switched to collection names: my_gfg_collectioncollection = db.my_gfg_collection emp_rec1 = { "name":"Mr.Geek", "eid":24, "location":"delhi" }emp_rec2 = { "name":"Mr.Shaurya", "eid":14, "location":"delhi" }emp_rec3 = { "name":"Mr.Coder", "eid":14, "location":"gurugram" } # Insert Datarec_id1 = collection.insert_one(emp_rec1)rec_id2 = collection.insert_one(emp_rec2)rec_id3 = collection.insert_one(emp_rec3)print("Data inserted with record ids",rec_id1," ",rec_id2,rec_id3) # Printing the data insertedcursor = collection.find()for record in cursor: print(record) |
Output:
Connected successfully!!!
Data inserted with record ids
{'_id': ObjectId('5a02227b37b8552becf5ed2a'), 'name':
'Mr.Geek', 'eid': 24, 'location': 'delhi'}
{'_id': ObjectId('5a02227c37b8552becf5ed2b'), 'name':
'Mr.Shaurya', 'eid': 14, 'location': 'delhi'}
{'_id': ObjectId('5a02227c37b8552becf5ed2c'), 'name':
'Mr.Coder', 'eid': 14, 'location': 'gurugram'}
Replace_one()
After inserting the data let’s replace the Data of employee whose name : Mr.Shaurya
# Python code to illustrate # Replace_one() in MongoDBfrom pymongo import MongoClient try: conn = MongoClient() print("Connected successfully!!!")except: print("Could not connect to MongoDB") # databasedb = conn.database # Created or Switched to collection names: my_gfg_collectioncollection = db.my_gfg_collection # replace one of the employee data whose name is Mr.Shauryaresult = collection.replace_one( {"name":"Mr.Shaurya"}, { "name":"Mr.GfG", "eid":45, "location":"noida" } ) print("Data replaced with id",result) # Print the new recordcursor = collection.find()for record in cursor: print(record) |
Connected successfully!!!
Data replaced with id
{'_id': ObjectId('5a02227b37b8552becf5ed2a'), 'name':
'Mr.Geek', 'eid': 24, 'location': 'delhi'}
{'_id': ObjectId('5a02227c37b8552becf5ed2b'), 'name':
'Mr.GfG', 'eid': 45, 'location': 'noida'}
{'_id': ObjectId('5a02227c37b8552becf5ed2c'), 'name':
'Mr.Coder', 'eid': 14, 'location': 'gurugram'}
We have successfully replaced the document of employee name:’Mr.Shaurya’ and replaced the entire document with new one, name:’Mr.GfG’ (present).
Replace_many()
Considering the data is same as inserted.
Replace all the data entries with eid:14.
# Python code to illustrate # Replace_many() in MongoDBfrom pymongo import MongoClient try: conn = MongoClient() print("Connected successfully!!!")except: print("Could not connect to MongoDB") # databasedb = conn.database # Created or Switched to collection names: my_gfg_collectioncollection = db.my_gfg_collection # replace one of the employee data whose name is Mr.Shauryaresult = collection.replace_many( {"eid":14}, { "name":"Mr.GfG", "eid":45, "location":"noida" } ) print("Data replaced with id",result) # Print the new recordcursor = collection.find()for record in cursor: print(record) |
Output would have been:
Connected successfully!!!
Data replaced with id
{'_id': ObjectId('5a02227b37b8552becf5ed2a'), 'name':
'Mr.Geek', 'eid': 24, 'location': 'delhi'}
{'_id': ObjectId('5a02227c37b8552becf5ed2b'), 'name':
'Mr.GfG', 'eid': 45, 'location': 'noida'}
{'_id': ObjectId('5a02227c37b8552becf5ed2c'), 'name':
'Mr.GfG', 'eid': 45, 'location': 'noida'}
Here we can see both entries with eid:14 got replace with new data. (ObjectId will be different even if data is same).



