1. show databases
  2. # implicitly create db
  3. use xxx_db
  6. db.createCollection('users')
  8. # INSERT
  9. db.xxxc.insertOne({x: 1})  
  10. db.xxxc.insertMany([{}, {}])
  12. # QUERY
  13. # search in xxx_collection
  14. # with status=='Success' and only return name filed
  15. # implecitly create collectio and each document's _id filed
  16. db.collection.find({'status': 'Success'}, {'name': 1, 'age': 0})
  17. db.collection.find({'status': {'$in': ['A', 'B']}, 'name': 'B'}) # operator
  18. db.collection.find({'com.size': {'$lt': 15}})
  19. # for array field
  20. db.collection.find({'tags': "red"})  # red in tags
  21. db.collection.find({'tags': ['red', 'black']}) # ['red', 'black'] == tags
  22. db.collection.find({'tags': {'$all': ['red', 'black']}}) # ['red', 'black'] in tags
  23. db.collection.find({'tags': {'$lt': 5}}) # with element in tags < 5
  24. db.collection.find({'tags': {'$lt': 5, '$gt': 20}}) # OR with element in tags < 5 or > 20
  25. db.inventory.find( { 'tags': { '$elemMatch': { '$gt': 22, '$lt': 30 } } } ) # AND multi version of the above
  26. db.inventory.find( { "tags.1": { '$gt': 25 } } ) # the second element in tags > 25
  27. db.inventory.find( { "tags": { '$size': 3 } } ) # len(tags) == 3
  30. # project field
  31. db.inventory.find( { status: "A" }, { item: 1, status: 1, _id: 0 } )
  32. db.inventory.find({stateus, 'A'}, { item: 1, status: 1, size: { uom: 1 } })
  33. # for instock array, return the last one
  34. db.inventory.find( { status: "A" }, { item: 1, status: 1, instock: { $slice: -1 } } )
  36. cursor = db.collection.find()
  37. for item in cursor:
  38.     print(item)
  42. # UPDATE
  43. db.xxxc.updateOne()
  44. db.xxxc.updateMany()
  45. db.xxxc.replaceOne()
  46. # use update operations
  47. # $addFields $set $project $unset $replaceRoot $replaceWith
  48. db.students.updateOne( { _id: 3 }, [ { $set: { "test3": 98, modified: "$$NOW"} } ] )
  49. db.students2.updateMany( {},
  50.   [
  51.     { $replaceRoot: { newRoot:
  52.        { $mergeObjects: [ { quiz1: 0, quiz2: 0, test1: 0, test2: 0 }, "$$ROOT" ] }
  53.     } },
  54.     { $set: { modified: "$$NOW"}  }
  55.   ]
  56. )
  59. db.collection.update() when used with the upsert: true option.
  60. db.collection.updateOne() when used with the upsert: true option.
  61. db.collection.updateMany() when used with the upsert: true option.
  62. db.collection.findAndModify() when used with the upsert: true option.
  63. db.collection.findOneAndUpdate() when used with the upsert: true option.
  64. db.collection.findOneAndReplace() when used with the upsert: true option.
  65. db.collection.save().
  66. db.collection.bulkWrite()
  70. db.collection.deleteOne()
  71. db.collection.deleteMany()
  72. db.collection.remove()
  73. db.collection.findOneAndDelete()
  74. db.collection.findAndModify().
  75. db.collection.findAndModify() provides a sort option. The option allows for the deletion of the first document sorted by the specified order.
  76. db.collection.bulkWrite().

views

Capped Collections