Created
February 9, 2018 03:33
-
-
Save elliotkim916/85fa35ec430142b616b92812cd2cc1f8 to your computer and use it in GitHub Desktop.
Mongo Basic Drills
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment