Mongo Basic Drills

Mongo Basic Drills

// Get All
db.restaurants.find();

// Limit & Sort  
db.restaurants.find().
... sort({name: 1}).
... limit(10);

// Get by ID  
db.restaurants.find({_id: ObjectId("59074c7c057aaffaafb0e20b")});
// or
var documentId = ObjectId("59074c7c057aaffaafb0e20b");
db.restaurants.findOne({_id: documentId});

// Get by value  
db.restaurants.
... find({borough: "Queens"});

// Count  
db.restaurants.count();

// Count by nested value  
db.restaurants.find({"address.zipcode": "11206"}).count();

// Delete by ID
var objectId = db.restaurants.findOne({}, {_id: "59074c7c057aaffaafb11fbf"})._id;
db.restaurants.find({_id: objectId}).count();
db.restaurants.remove({_id: objectId});
db.restaurants.find({_id: objectId}).count();
// or 
db.restaurants.find({_id: ObjectId("59074c7c057aaffaafb0e20b")}).count();
db.restaurants.remove({_id: ObjectId("59074c7c057aaffaafb0e20b")});
db.restaurants.find({_id: ObjectId("59074c7c057aaffaafb0e20b")}).count();

// Update a single document 
var objectId = db.restaurants.findOne({}, {_id: ObjectId("59074c7c057aaffaafb0da6c")})._id;
db.restaurants.updateOne({_id: objectId}, {$set: {name: "Bizz Bar Bang"}});
db.restaurants.findOne({_id: objectId});

// Update many documents
db.restaurants.update(
... {"address.zipcode": "10035"},
... { $set: {"address.zipcode": "10036"}},
... { upsert: true, multi: true}
... );
// or .updateMany() without the upsert and multi