Mongo Basics drills / SHobbs Solutions

gistfile1.txt

Get all: 
db.restaurants.find()

Limit and sort: 
db.restaurants.find({ "name": { "$exists": true } }).limit(10).sort({ "name": 1})

Get by _id: 
var oneRest = db.restaurants.findOne({}, {_id: 1})._id
db.restaurants.findOne({_id: oneRest});

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 delRest = db.restaurants.findOne({}, {_id: 1})._id
db.restaurants.deleteOne({_id: delRest});

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

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