Mongo basics drills

Mongo basics drills

//Get all
db.restaurants.find()

//Limit and sort
db.restaurants.
  find().
  sort({name: 1}).
  limit(10);
  
//Get by _id
var myId = db.restaurants.findOne({}, {_id: true})._id;
db.restaurants.findOne({_id: 41693931});

//Get by value
db.restaurants.find({borough: "Queens"}, {_id: 1, name: 1, address: 1})

//Count
db.restaurants.count()

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

//Delete by id
var objectId = db.restaurants.findOne({}, {_id: 1})._id
db.restaurants.remove({_id: 41693931});

//Update a single document
var myId = db.restaurants.findOne({}, {_id: true})._id;
db.restaurants.updateOne( {_id: 41708028}, {$set: {name: "Bizz Bar Bang"}});

//Update many documents
db.restaurants.updateMany(
  {'address.zipcode': '10035'},
  {$set: {'address.zipcode': '10036'}});