mongodbdrills.md

get all

db.restaurants.find();

limit and sort

db.restaurants.find().sort( { name: 1 } ).limit( 10 )

get by id

db.restaurants.find( {_id: ObjectId("59074c7c057aaffaafb10acb") } );

get by a value

db.restaurants.find( {borough: "Queens" });

count

db.restaurants.find().count();

count by nested value

db.restaurants.find( {"address.zipcode": "11206" } ).count();

delete by id

db.restaurants.deleteOne( {_id: ObjectId("59074c7c057aaffaafb10acb") } );

update single doc by id

db.restaurants.updateOne( {_id: ObjectId("59074c7c057aaffaafb106a2") }, { $set: {"name": "Bizz Bar Bang" } } );

//this is just to test that it worked: db.restaurants.find( {_id: ObjectId("59074c7c057aaffaafb106a2")});

update many

db.restaurants.updateMany({"address.zipcode": "10035"}, {$set: {"address.zipcode": "10036"} }); //testing: db.restaurants.find( {"address.zipcode": "10035" } ).count(); ==>0