$unset operator for removing fields in MongoDB - Mini Project: Build & Apply

$unset Operator for Removing Fields in MongoDB

📖 Scenario: You are managing a MongoDB collection that stores information about books in a library. Some books have an extra field called temporaryNote that is no longer needed. You want to clean up the database by removing this field from all book documents.

🎯 Goal: Learn how to use the MongoDB $unset operator to remove the temporaryNote field from all documents in the books collection.

📋 What You'll Learn

Create a books collection with three documents containing the fields title, author, and temporaryNote.

Create a filter variable called filter that matches all documents in the collection.

Write an update command using the $unset operator to remove the temporaryNote field from all matched documents.

Execute the update command on the books collection.

💡 Why This Matters

🌍 Real World

Cleaning up unnecessary or temporary fields in a MongoDB collection helps keep the database organized and efficient.

💼 Career

Database administrators and backend developers often need to update and maintain collections by removing obsolete fields using operators like $unset.

1

Create the books collection with sample documents

Create a variable called books that contains three documents exactly as follows: { title: "The Hobbit", author: "J.R.R. Tolkien", temporaryNote: "First edition" }, { title: "1984", author: "George Orwell", temporaryNote: "Signed copy" }, and { title: "To Kill a Mockingbird", author: "Harper Lee", temporaryNote: "Library copy" }.

MongoDB

# Create the books collection with three documents
# Your code here

Need a hint?

Use a list of dictionaries to represent the documents in the books collection.

2

Create a filter to select all documents

Create a variable called filter and set it to an empty dictionary {} to match all documents in the collection.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

# Create a filter variable called filter to match all documents
# Your code here

Need a hint?

An empty dictionary {} matches all documents in MongoDB queries.

3

Write the update command using $unset

Create a variable called update_command and set it to a dictionary that uses the $unset operator to remove the temporaryNote field. The dictionary should be exactly: { "$unset": { "temporaryNote": "" } }.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

filter = {}

# Create an update_command variable using $unset to remove temporaryNote
# Your code here

Need a hint?

The $unset operator removes fields by setting them to an empty string in the update document.

4

Execute the update command on the books collection

Write a line of code that calls db.books.update_many(filter, update_command) to remove the temporaryNote field from all documents in the books collection.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

filter = {}

update_command = { "$unset": { "temporaryNote": "" } }

# Execute the update command on the books collection
# Your code here

Need a hint?

Use the update_many method on the books collection with the filter and update_command variables.