Scribd Logo
Upload

Welcome to Scribd!

  • 55 views

    Mongodb Class Exercise: Difference Update and Update One

    Uploaded by

    Air
    The document provides examples of different MongoDB update queries including: 1. updateOne() to update a single document matching a filter. 2. update() to update multiple documents matching a filter. 3. updateMany() which is similar to update() but updates all matching documents. 4. replaceOne() which replaces a single matching document rather than modifying it. It also shows examples updating nested fields, arrays, and using the $currentDate and $unset operators.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Mongodb Class Exercise: Difference Update and Update One

    Uploaded by

    Air
    55 views4 pages
    The document provides examples of different MongoDB update queries including: 1. updateOne() to update a single document matching a filter. 2. update() to update multiple documents matching a filter. 3. updateMany() which is similar to update() but updates all matching documents. 4. replaceOne() which replaces a single matching document rather than modifying it. It also shows examples updating nested fields, arrays, and using the $currentDate and $unset operators.

    Original Title

    nosql

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides examples of different MongoDB update queries including: 1. updateOne() to update a single document matching a filter. 2. update() to update multiple documents matching a filter. 3. updateMany() which is similar to update() but updates all matching documents. 4. replaceOne() which replaces a single matching document rather than modifying it. It also shows examples updating nested fields, arrays, and using the $currentDate and $unset operators.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    55 views4 pages

    Mongodb Class Exercise: Difference Update and Update One

    Uploaded by

    Air
    The document provides examples of different MongoDB update queries including: 1. updateOne() to update a single document matching a filter. 2. update() to update multiple documents matching a filter. 3. updateMany() which is similar to update() but updates all matching documents. 4. replaceOne() which replaces a single matching document rather than modifying it. It also shows examples updating nested fields, arrays, and using the $currentDate and $unset operators.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    MongoDB Class exercise

    19/12/2019

    Update Queries

    db.inventory.insertMany( [
    { item: "canvas", qty: 100, size: { h: 28, w: 35.5, uom: "cm" }, status: "A" },
    { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
    { item: "mat", qty: 85, size: { h: 27.9, w: 35.5, uom: "cm" }, status: "A" },
    { item: "mousepad", qty: 25, size: { h: 19, w: 22.85, uom: "cm" }, status: "P" },
    { item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },
    { item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },
    { item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },
    { item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" },
    { item: "sketchbook", qty: 80, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
    { item: "sketch pad", qty: 95, size: { h: 22.85, w: 30.5, uom: "cm" }, status: "A" }
    ] );

    Difference Update and update one - multi: true

    1. db.inventory.updateOne(
    { item: "paper" },
    {
    $set: { "size.uom": "cm", status: "P" },
    $currentDate: { lastModified: true }
    }
    )

    2. db.inventory.update(
    { "qty": { $lt: 50 } },
    {
    $set: { "size.uom": "in", status: "P" },
    $currentDate: { lastModified: true }
    }
    )

    Update & updateMany -Similar?

    3. db.inventory.updateMany(
    { "qty": { $lt: 50 } },
    {
    $set: { "size.uom": "in", status: "P" },
    $currentDate: { lastModified: true }
    }
    )

    Difference update and replaceOne?


    Is id will be modified?

    4. db.inventory.replaceOne(
    { item: "paper" },
    { item: "paper", instock: [ { warehouse: "A", qty: 60 }, { warehouse: "B", qty: 40 } ] }
    )
    Difference $set and $unset
    5. db.inventory.updateOne( { item: "paper" }, { $unset:{instock:[{}]}})

    aggregation

    db.members.insertMany([
    { "_id" : 1, "member" : "abc123", "status" : "A", "points" : 2, "misc1" : "note to self: confirm status", "misc2" :
    "Need to activate" },
    { "_id" : 2, "member" : "xyz123", "status" : "A", "points" : 60, comments: [ "reminder: ping me at 100pts",
    "Some random comment" ] }
    ])

    6. db.members.updateOne(
    { _id: 1 },
    [
    { $set: { status: "Modified", comments: [ "$misc1", "$misc2" ] } },
    { $unset: [ "misc1", "misc2" ] }
    ]
    )

    Dataset creation

    db.students3.insert([
    { "_id" : 1, "tests" : [ 95, 92, 90 ], "average" : 92.33333333333333, "grade" : "A" },
    { "_id" : 2, "tests" : [ 94, 88, 90 ], "average" : 90.66666666666667, "grade" : "A" },
    { "_id" : 3, "tests" : [ 70, 75, 82 ] }
    ]);
    7. db.students3.updateOne(
    { _id: 3 },
    [
    { $set: { average : { $avg: "$tests" } } },
    { $set: { grade: { $switch: {
    branches: [
    { case: { $gte: [ "$average", 90 ] }, then: "A" },
    { case: { $gte: [ "$average", 80 ] }, then: "B" },
    { case: { $gte: [ "$average", 70 ] }, then: "C" },
    { case: { $gte: [ "$average", 60 ] }, then: "D" }
    ],
    default: "F"
    }}}}
    ]
    )

    { "_id" : 1, "name" : "Central Perk Cafe", "Borough" : "Manhattan", "violations" : 3 },


    { "_id" : 2, "name" : "Rock A Feller Bar and Grill", "Borough" : "Queens", "violations" : 2 },
    { "_id" : 3, "name" : "Empire State Pub", "Borough" : "Brooklyn", "violations" : "0" }
    8. try {
    db.restaurant.updateOne(
    { "name" : "Pizza Rat's Pizzaria" },
    { $set: {"_id" : 4, "violations" : 7, "borough" : "Manhattan" } },
    { upsert: true }
    );
    } catch (e) {
    print(e);
    }

    9. db.rest.insertMany({ "_id" : 1, "name" : "Central Perk Cafe", "Borough" : "Manhattan", "violations" : 3


    },
    { "_id" : 2, "name" : "Rock A Feller Bar and Grill", "Borough" : "Queens", "violations" : 2 },
    { "_id" : 3, "name" : "Empire State Pub", "Borough" : "Brooklyn", "violations" : 4 },
    { "_id" : 4, "name" : "Pizza Rat's Pizzaria", "Borough" : "Manhattan", "violations" : 7 })
    10. try {
    db.restaurant.updateOne(
    { "violations" : { $gt: 10} },
    { $set: { "Closed" : true } },
    { upsert: true }
    );
    } catch (e) {
    print(e);
    }

    1. try {
    db.restaurant.updateOne(
    { "name" : "Pizza Rat's Pizzaria" },
    { $set: {"_id" : 4, "violations" : 7, "borough" : "Manhattan" } },
    { upsert: true }
    );
    } catch (e) {
    print(e);
    }

    2. try {
    db.restaurant.updateOne(
    { "name" : "Pizza Rat's Pizzaria" },
    { $inc: { "violations" : 3}, $set: { "Closed" : true } },
    { w: "majority", wtimeout: 100 }
    );
    } catch (e) {
    print(e);
    }

    3. db.students.insert([
    { "_id" : 1, "grades" : [ 95, 92, 90 ] },
    { "_id" : 2, "grades" : [ 98, 100, 102 ] },
    { "_id" : 3, "grades" : [ 95, 110, 100 ] }
    ])
    4. db.students.updateOne(
    { grades: { $gte: 100 } },
    { $set: { "grades.$[element]" : 100 } },
    { arrayFilters: [ { "element": { $gte: 100 } } ] }
    )

    { "_id" : 1, "name" : "Central Perk Cafe", "Borough" : "Manhattan" },


    { "_id" : 2, "name" : "Rock A Feller Bar and Grill", "Borough" : "Queens", "violations" : 2 },
    { "_id" : 3, "name" : "Empire State Pub", "Borough" : "Brooklyn", "violations" : 0 }
    5. try {
    db.restaurant.replaceOne(
    { "name" : "Central Perk Cafe" },
    { "name" : "Central Pork Cafe", "Borough" : "Manhattan" }
    );
    } catch (e){
    print(e);
    }

    { "_id" : 1, "name" : "Central Perk Cafe", "Borough" : "Manhattan", "violations" : 3 },


    { "_id" : 2, "name" : "Rock A Feller Bar and Grill", "Borough" : "Queens", "violations" : 2 },
    { "_id" : 3, "name" : "Empire State Pub", "Borough" : "Brooklyn", "violations" : 0 }

    6. try {
    db.restaurant.replaceOne(
    { "name" : "Pizza Rat's Pizzaria" },
    { "_id": 4, "name" : "Pizza Rat's Pizzaria", "Borough" : "Manhattan", "violations" : 8 },
    { upsert: true }
    );
    } catch (e){
    print(e);
    }

    try { db.restaurant.replaceOne( { "name" : "Pizzaria" }, { "_id

    ": 4, "name" : "Pizza Rat's Pizzaria", "Borough" : "Manhattan", "violations" : 8

    }, { upsert: false } ); } catch (e){ print(e); }

    You might also like