MongoDB Notes

MongoDB Notes

Schema-Free
Hierarchy
1. Instance
  1. Database
    1. Collection
      1. Document
        Every Document has an id
        JSON Format
      2. Embedded
        Attributes are not stored in separate collection
        Implementation depends on the needs of the application
      3. Linked
Optimized to quickly retrieve relevant data
Design should take into account how the application needs the data
Documentation: https://docs.mongodb.com/manual/
Extensions
1. Mongoose
2. RoboMongo
3. MongoChef
CRUD Operations
1. find
  1. Equivalent to SELECT statement
  2. Examples
    1. Minimal
      1. db.Products.find()
    2. Query + Projection
      1. db.Products.find({ "desc": "42in TV", "width": 41 })
    3. Query Only
      1. db.Products.find({"desc": "42in TV"})
    4. Projection Only
      1. db.Products.find({"width": 1, "height": 1, "depth": 1} )
    5. Arrays
      1. db.Products.find({ "priceHist" : {$elemMatch: { $gt: 100, $lt: 300 } } })
    6. Conditional Statements
      1. db.Products.find({"reviews.star": { $gte: 4 } })
    7. Embedded Collections
      1. db.Products.find({"editorReview.authorlname" : "Smith"} )
  3. Syntax
    1. db.collection.find(query, projection)
      1. Projection: Which columns you're going to return
      2. id always comes back unless id is set to false {id: 0}
2. Inserts
  1. Examples
    1. Single
      1. db.Questions.insert({"_id": NumberInt(5), "prodID": NumberInt(4), "author": "MrsInquisitive", "text": "Sample question"})
    2. Multiple
      1. db.Questions.insert([{"_id": NumberInt(6), "prodID": NumberInt(4), "author": "MrsInquisitive", "text": "Sample question"}, {"_id": NumberInt(7), "prodID": NumberInt(4), "author": "MrIWantToKnow", "text": "Sample question"} ])

Próximo

Descrição

Resumo de Recurso

0 comentários

Semelhante

	Criado por Callie Toothman quase 9 anos atrás