Why delete operations need care in MongoDB - See It in Action

Why Delete Operations Need Care in MongoDB

📖 Scenario: You are managing a small online bookstore database using MongoDB. You want to learn how to safely delete books from your collection without accidentally removing important data.

🎯 Goal: Build a simple MongoDB setup where you create a collection of books, set a condition to identify old books, delete only those old books carefully, and finally confirm the deletion operation is safe.

📋 What You'll Learn

Create a MongoDB collection named books with 3 specific book documents

Add a variable year_threshold to decide which books are considered old

Write a delete operation that removes only books published before year_threshold

Add a safety check to confirm the delete operation targets the correct documents

💡 Why This Matters

🌍 Real World

Deleting old or unwanted data carefully is important to keep databases clean without losing important information.

💼 Career

Database administrators and developers must safely manage delete operations to avoid accidental data loss.

1

DATA SETUP: Create the books collection with 3 book documents

Create a MongoDB collection called books and insert exactly these 3 documents: { title: 'Book A', year: 2010 }, { title: 'Book B', year: 2000 }, and { title: 'Book C', year: 2020 }.

MongoDB

// Insert the 3 book documents into the books collection
// Your code here

Need a hint?

Use db.books.insertMany() with an array of objects for the 3 books.

2

CONFIGURATION: Define the year_threshold variable

Create a variable called year_threshold and set it to 2010. This will help decide which books are old and should be deleted.

MongoDB

db.books.insertMany([
  { title: 'Book A', year: 2010 },
  { title: 'Book B', year: 2000 },
  { title: 'Book C', year: 2020 }
])

// Define the year_threshold variable
// Your code here

Need a hint?

Use const year_threshold = 2010 to set the threshold year.

3

CORE LOGIC: Delete books published before year_threshold

Write a delete operation using db.books.deleteMany() to remove only books where the year is less than year_threshold.

MongoDB

db.books.insertMany([
  { title: 'Book A', year: 2010 },
  { title: 'Book B', year: 2000 },
  { title: 'Book C', year: 2020 }
])

const year_threshold = 2010;

// Delete books published before year_threshold
// Your code here

Need a hint?

Use the MongoDB query operator $lt to find books with year less than year_threshold.

4

COMPLETION: Add a safety check to confirm the delete operation

Add a query using db.books.find() to list all remaining books after deletion, ensuring only the correct books were removed.

MongoDB

db.books.insertMany([
  { title: 'Book A', year: 2010 },
  { title: 'Book B', year: 2000 },
  { title: 'Book C', year: 2020 }
])

const year_threshold = 2010;

db.books.deleteMany({ year: { $lt: year_threshold } })

// Find all remaining books to confirm deletion
// Your code here

Need a hint?

Use db.books.find() to see the current documents in the collection.