MongoDB e Node.js 3.3.2 Tutorial - Operações CRUD

1
{
2
     "_id":"10057447",
3
     "listing_url":"https://www.airbnb.com/rooms/10057447",
4
     "name":"Modern Spacious 1 Bedroom Loft",
5
     "summary":"Prime location, amazing lighting and no annoying neighbours.  Good place to rent if you want a relaxing time in Montreal.",
6
     "property_type":"Apartment",
7
     "bedrooms":{"$numberInt":"1"},
8
     "bathrooms":{"$numberDecimal":"1.0"},
9
     "amenities":["Internet","Wifi","Kitchen","Heating","Family/kid friendly","Washer","Dryer","Smoke detector","First aid kit","Safety card","Fire extinguisher","Essentials","Shampoo","24-hour check-in","Hangers","Iron","Laptop friendly workspace"],
10
}

1
async function createListing(client, newListing){
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews").insertOne(newListing);
3
    console.log(`New listing created with the following id: ${result.insertedId}`);
4
}

1
async function createMultipleListings(client, newListings){
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews").insertMany(newListings);
3
4
    console.log(`${result.insertedCount} new listing(s) created with the following id(s):`);
5
    console.log(result.insertedIds);      
6
}

1
await createMultipleListings(client, [
2
    {
3
        name: "Infinite Views",
4
        summary: "Modern home with infinite views from the infinity pool",
5
        property_type: "House",
6
        bedrooms: 5,
7
        bathrooms: 4.5,
8
        beds: 5
9
    },
10
    {
11
        name: "Private room in London",
12
        property_type: "Apartment",
13
        bedrooms: 1,
14
        bathroom: 1
15
    },
16
    {
17
        name: "Beautiful Beach House",
18
        summary: "Enjoy relaxed beach living in this house with a private beach",
19
        bedrooms: 4,
20
        bathrooms: 2.5,
21
        beds: 7,
22
        last_review: new Date()
23
    }
24
]);

1
async function findOneListingByName(client, nameOfListing) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews").findOne({ name: nameOfListing });
3
4
    if (result) {
5
        console.log(`Found a listing in the collection with the name '${nameOfListing}':`);
6
        console.log(result);
7
    } else {
8
        console.log(`No listings found with the name '${nameOfListing}'`);
9
    }
10
}

1
const cursor = client.db("sample_airbnb").collection("listingsAndReviews").find(
2
                        {
3
                            bedrooms: { $gte: minimumNumberOfBedrooms },
4
                            bathrooms: { $gte: minimumNumberOfBathrooms }
5
                        }
6
                    );

1
const cursor = client.db("sample_airbnb").collection("listingsAndReviews").find(
2
                        {
3
                            bedrooms: { $gte: minimumNumberOfBedrooms },
4
                            bathrooms: { $gte: minimumNumberOfBathrooms }
5
                        }
6
                    ).sort({ last_review: -1 });

1
const cursor = client.db("sample_airbnb").collection("listingsAndReviews").find(
2
                        {
3
                            bedrooms: { $gte: minimumNumberOfBedrooms },
4
                            bathrooms: { $gte: minimumNumberOfBathrooms }
5
                        }
6
                    ).sort({ last_review: -1 })
7
                    .limit(maximumNumberOfResults);

1
const cursor = client.db("sample_airbnb").collection("listingsAndReviews").find(
2
                        {
3
                            bedrooms: { $gte: minimumNumberOfBedrooms },
4
                            bathrooms: { $gte: minimumNumberOfBathrooms }
5
                        }
6
                    ).sort({ last_review: -1 })
7
                    .limit(maximumNumberOfResults);
8
const results = await cursor.toArray();

1
async function findListingsWithMinimumBedroomsBathroomsAndMostRecentReviews(client, {
2
    minimumNumberOfBedrooms = 0,
3
    minimumNumberOfBathrooms = 0,
4
    maximumNumberOfResults = Number.MAX_SAFE_INTEGER
5
} = {}) {
6
    const cursor = client.db("sample_airbnb").collection("listingsAndReviews")
7
        .find({
8
            bedrooms: { $gte: minimumNumberOfBedrooms },
9
            bathrooms: { $gte: minimumNumberOfBathrooms }
10
        }
11
        )
12
        .sort({ last_review: -1 })
13
        .limit(maximumNumberOfResults);
14
15
    const results = await cursor.toArray();
16
17
    if (results.length > 0) {
18
        console.log(`Found listing(s) with at least ${minimumNumberOfBedrooms} bedrooms and ${minimumNumberOfBathrooms} bathrooms:`);
19
        results.forEach((result, i) => {
20
            date = new Date(result.last_review).toDateString();
21
22
            console.log();
23
            console.log(`${i + 1}. name: ${result.name}`);
24
            console.log(`   _id: ${result._id}`);
25
            console.log(`   bedrooms: ${result.bedrooms}`);
26
            console.log(`   bathrooms: ${result.bathrooms}`);
27
            console.log(`   most recent review date: ${new Date(result.last_review).toDateString()}`);
28
        });
29
    } else {
30
        console.log(`No listings found with at least ${minimumNumberOfBedrooms} bedrooms and ${minimumNumberOfBathrooms} bathrooms`);
31
    }
32
}

1
await findListingsWithMinimumBedroomsBathroomsAndMostRecentReviews(client, {
2
    minimumNumberOfBedrooms: 4,
3
    minimumNumberOfBathrooms: 2,
4
    maximumNumberOfResults: 5
5
});

1
async function updateListingByName(client, nameOfListing, updatedListing) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews")
3
                        .updateOne({ name: nameOfListing }, { $set: updatedListing });
4
5
    console.log(`${result.matchedCount} document(s) matched the query criteria.`);
6
    console.log(`${result.modifiedCount} document(s) was/were updated.`);
7
}

1
await updateListingByName(client, "Infinite Views", { bedrooms: 6, beds: 8 });

1
async function upsertListingByName(client, nameOfListing, updatedListing) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews")
3
                        .updateOne({ name: nameOfListing }, 
4
                                   { $set: updatedListing }, 
5
                                   { upsert: true });
6
    console.log(`${result.matchedCount} document(s) matched the query criteria.`);
7
8
    if (result.upsertedCount > 0) {
9
        console.log(`One document was inserted with the id ${result.upsertedId._id}`);
10
    } else {
11
        console.log(`${result.modifiedCount} document(s) was/were updated.`);
12
    }
13
}

1
await upsertListingByName(client, "Cozy Cottage", { name: "Cozy Cottage", bedrooms: 2, bathrooms: 1 });

1
async function updateAllListingsToHavePropertyType(client) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews")
3
                        .updateMany({ property_type: { $exists: false } }, 
4
                                    { $set: { property_type: "Unknown" } });
5
    console.log(`${result.matchedCount} document(s) matched the query criteria.`);
6
    console.log(`${result.modifiedCount} document(s) was/were updated.`);
7
}

1
async function deleteListingByName(client, nameOfListing) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews")
3
            .deleteOne({ name: nameOfListing });
4
    console.log(`${result.deletedCount} document(s) was/were deleted.`);
5
}

1
async function deleteListingsScrapedBeforeDate(client, date) {
2
    const result = await client.db("sample_airbnb").collection("listingsAndReviews")
3
        .deleteMany({ "last_scraped": { $lt: date } });
4
    console.log(`${result.deletedCount} document(s) was/were deleted.`);
5
}