Guest User

Untitled

a guest
Nov 23rd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. // Get all
  2.  
  3. db.restaurants.find();
  4.  
  5. // Limit and sort
  6. db.restaurants.
  7. find().
  8. sort({name: 1}).
  9. limit(10);
  10.  
  11.  
  12. // get by _id
  13. db.restaurants.findOne({})._id;
  14.  
  15. // var documentId = ObjectId('59074c7c057aaffaafb0da5a');
  16. db.restaurants.findOne({_id: documentId});
  17.  
  18. // Get by value
  19. db.restaurants.find({borough: "Queens"});
  20.  
  21. // Count
  22. db.restaurants.count();
  23.  
  24. // Count by nested value
  25. db.restaurants.find({‘address.zipcode’ : ‘11206’}).count
  26.  
  27. // Delete by id
  28. var documentId = db.restaurants.findOne({}, {_id: true})._id;
  29. db.restaurants.removeOne({_id: documentId});
  30.  
  31.  
  32. // Update a single document
  33. var documentId = db.restaurants.findOne({}, {_id: true})._id;
  34. db.restaurants.updateOne(
  35. {_id: document},
  36. {$set: {name: 'Bizz Bar Bang'}});
  37.  
  38.  
  39. // Update many documents
  40. db.restaurants.updateMany(
  41. {'address.zipcode': '10035'},
  42. {$set: {'address.zipcode': '10036'}});
Add Comment
Please, Sign In to add comment