Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. ///find all restaurants:
  2. db.restaurants.find()
  3.  
  4. ///limit and sort:
  5. > db.restaurants.
  6. ... find().
  7. ... sort({name:1}).
  8. ... limit(10)
  9.  
  10.  
  11. ///find one by Id:
  12. db.restaurants.findOne({'_id':ObjectId('58aba0098831b826f6b9eb3a')});
  13.  
  14.  
  15. ///find all from the borough of queens:
  16. db.restaurants.find({'borough': 'Queens'})
  17.  
  18. //count of documents:
  19. db.restaurants.count()
  20.  
  21. //count by nested value:
  22. db.restaurants.count({'address.zipcode': '11206'})
  23. db.restaurants.find({'address.zipcode': '11206'}).count()
  24.  
  25. ///delete by ID:
  26. db.restaurants.remove({'_id': ObjectId('58aba0088831b826f6b9a30e')})
  27.  
  28. ///Update a single document:
  29. db.restaurants.updateOne(
  30. ... {'_id': ObjectId('58aba0088831b826f6b99fb5')},
  31. ... {$set: {'name':'Bizz Bar Bang'}});
  32.  
  33. //update many zip codes:
  34. db.restuarants.updateMany(
  35. ... {'address.zipcode':10035},
  36. ... {$set{'address.zipcode':10036}}
  37. ... );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement