$inc operator for incrementing in MongoDB - Mini Project: Build & Apply

$inc Operator for Incrementing in MongoDB

📖 Scenario: You are managing a small online bookstore's inventory stored in a MongoDB collection. Each book document has a title and a stock count. When new books arrive, you need to increase the stock count for the existing books.

🎯 Goal: Learn how to use the $inc operator in MongoDB to increment the stock count of books in the inventory.

📋 What You'll Learn

Create a collection called books with three book documents having exact titles and stock counts.

Define a variable incrementValue to specify how many books to add to the stock.

Write an update query using the $inc operator to increase the stock of a specific book.

Complete the update operation by specifying the correct filter and update objects.

💡 Why This Matters

🌍 Real World

Managing inventory counts in an online bookstore or any retail system where stock levels change frequently.

💼 Career

Understanding how to increment numeric fields in a database is essential for roles like database administrator, backend developer, and data engineer.

1

Create the books collection with initial data

Create a MongoDB collection called books and insert these exact documents: { title: 'Learn MongoDB', stock: 5 }, { title: 'JavaScript Basics', stock: 8 }, and { title: 'Python for Beginners', stock: 10 }.

MongoDB

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

Hint

Use insertMany to add multiple documents to the books collection.

2

Define the increment value

Create a variable called incrementValue and set it to 3 to represent how many books to add to the stock.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', stock: 5 },
  { title: 'JavaScript Basics', stock: 8 },
  { title: 'Python for Beginners', stock: 10 }
])

// Define the increment value
// Your code here

Hint

Use const to declare the variable incrementValue and assign it the number 3.

3

Write the update query using $inc

Write an update query that uses db.books.updateOne to increase the stock of the book with title 'Learn MongoDB' by the value of incrementValue using the $inc operator.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', stock: 5 },
  { title: 'JavaScript Basics', stock: 8 },
  { title: 'Python for Beginners', stock: 10 }
])

const incrementValue = 3;

// Update the stock of 'Learn MongoDB' using $inc
// Your code here

Hint

Use updateOne with a filter for { title: 'Learn MongoDB' } and an update object using $inc to increase stock.

4

Complete the update operation

Ensure the update query correctly specifies the filter as { title: 'Learn MongoDB' } and the update document uses { $inc: { stock: incrementValue } } to increment the stock count.

MongoDB

db.books.insertMany([
  { title: 'Learn MongoDB', stock: 5 },
  { title: 'JavaScript Basics', stock: 8 },
  { title: 'Python for Beginners', stock: 10 }
])

const incrementValue = 3;

db.books.updateOne(
  { title: 'Learn MongoDB' },
  { $inc: { stock: incrementValue } }
);

// Finalize the update operation
// Your code here

Hint

Make sure the update query is complete and correctly formatted.

Practice

1. What does the $inc operator do in MongoDB?

easy

A. It creates a new collection.

B. It increments or decrements the value of a numeric field.

C. It deletes a field from the document.

D. It replaces the entire document with a new one.

Solution

1. Step 1: Understand the purpose of $inc

   The $inc operator is used to add or subtract a number from an existing numeric field in a document.

2. Step 2: Compare with other options

   Replacing documents, deleting fields, or creating collections are not functions of $inc.

3. Final Answer:

   It increments or decrements the value of a numeric field. -> Option B

4. Quick Check:

   $inc changes numbers by adding/subtracting [OK]

Hint: Remember: $inc changes numbers, not documents [OK]

Common Mistakes:

• Thinking $inc replaces the whole document
• Confusing $inc with delete or create operations
• Assuming $inc works on non-numeric fields

2. Which of the following is the correct syntax to increment the field score by 5 in MongoDB?

easy

A. { $inc: { score: '5' } }

B. { $inc: { score: '+5' } }

C. { $inc: { 'score': 'five' } }

D. { $inc: { score: 5 } }

Solution

1. Step 1: Check the value type for $inc

   The value to increment must be a number, not a string or word.

2. Step 2: Validate syntax correctness

   { $inc: { score: 5 } } uses a number 5 correctly. { $inc: { score: '5' } } uses a string '5', which is invalid. { $inc: { 'score': 'five' } } uses a word 'five', invalid. { $inc: { score: '+5' } } uses a string '+5', invalid.

3. Final Answer:

   { $inc: { score: 5 } } -> Option D

4. Quick Check:

   Use number values with $inc [OK]

Hint: Use numeric values without quotes for $inc [OK]

Common Mistakes:

• Using strings instead of numbers for increment values
• Adding plus sign (+) inside JSON value
• Using words instead of numeric literals

3. Given a document { _id: 1, count: 10 }, what will be the document after running db.collection.updateOne({ _id: 1 }, { $inc: { count: -3 } })?

medium

A. { _id: 1, count: -3 }

B. { _id: 1, count: 13 }

C. { _id: 1, count: 7 }

D. { _id: 1, count: 10 }

Solution

1. Step 1: Understand the initial document

   The document has count equal to 10.

2. Step 2: Apply the $inc operation with -3

   Subtract 3 from 10: 10 - 3 = 7.

3. Final Answer:

   { _id: 1, count: 7 } -> Option C

4. Quick Check:

   10 + (-3) = 7 [OK]

Hint: Subtract by using negative numbers with $inc [OK]

Common Mistakes:

• Adding instead of subtracting when using negative values
• Replacing the whole document instead of updating
• Assuming $inc only increments, not decrements

4. You run this update: db.collection.updateOne({ _id: 2 }, { $inc: { visits: 1 } }) but get an error. What is the most likely cause?

medium

A. The visits field is a string, not a number.

B. The _id field is missing in the query.

C. The $inc operator cannot increment by 1.

D. The collection does not exist.

Solution

1. Step 1: Understand $inc requirements

   $inc only works on numeric fields. If visits is a string, it causes an error.

2. Step 2: Check other options

   Missing _id would not cause this error if the document exists. $inc can increment by 1. Collection existence error would be different.

3. Final Answer:

   The visits field is a string, not a number. -> Option A

4. Quick Check:

   $inc needs numeric fields [OK]

Hint: Ensure field is numeric before using $inc [OK]

Common Mistakes:

• Trying to increment string fields
• Assuming $inc works on any data type
• Ignoring error messages about field types

5. You want to increment the likes field by 1 for all documents where likes does not exist yet. Which update command will correctly do this without errors?

hard

A. db.collection.updateMany({ likes: { $exists: false } }, { $inc: { likes: 1 } })

B. db.collection.updateMany({}, { $inc: { likes: 1 } })

C. db.collection.updateMany({ likes: null }, { $inc: { likes: 1 } })

D. db.collection.updateMany({}, { $set: { likes: 1 } })

Solution

1. Step 1: Identify documents without likes

   Use the query { likes: { $exists: false } } to find documents missing the likes field.

2. Step 2: Use $inc to add 1 to likes

   $inc will create the field with value 1 if it does not exist, so this safely increments missing fields.

3. Step 3: Check other options

   db.collection.updateMany({}, { $inc: { likes: 1 } }) increments all documents, including those with likes. db.collection.updateMany({ likes: null }, { $inc: { likes: 1 } }) matches documents where likes is null, not missing. db.collection.updateMany({}, { $set: { likes: 1 } }) sets likes to 1, not increments.

4. Final Answer:

   db.collection.updateMany({ likes: { $exists: false } }, { $inc: { likes: 1 } }) -> Option A

5. Quick Check:

   Increment missing fields with $exists: false filter [OK]

Hint: Filter missing fields with $exists: false before $inc [OK]

Common Mistakes:

• Incrementing all documents without filtering
• Using $set instead of $inc
• Filtering with null instead of $exists: false