Tutorial do MongoDB e Node.js - 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
await createListing(client,
2
        {
3
            name: "Lovely Loft",
4
            summary: "A charming loft in Paris",
5
            bedrooms: 1,
6
            bathrooms: 1
7
        }
8
    );

1
New listing created with the following id: 5d9ddadee415264e135ccec8

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
3 new listing(s) created with the following id(s):
2
{ 
3
  '0': 5d9ddadee415264e135ccec9,
4
  '1': 5d9ddadee415264e135cceca,
5
  '2': 5d9ddadee415264e135ccecb 
6
}

1
findOne({ name: nameOfListing })

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
await findOneListingByName(client, "Infinite Views");

1
Found a listing in the collection with the name 'Infinite Views':
2
{ 
3
  _id: 5da9b5983e104518671ae128,
4
  name: 'Infinite Views',
5
  summary: 'Modern home with infinite views from the infinity pool',
6
  property_type: 'House',
7
  bedrooms: 5,
8
  bathrooms: 4.5,
9
  beds: 5 
10
}

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

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

1
Found listing(s) with at least 4 bedrooms and 2 bathrooms:
2
3
1. name: Beautiful Beach House
4
    _id: 5db6ed14f2e0a60683d8fe44
5
    bedrooms: 4
6
    bathrooms: 2.5
7
    most recent review date: Mon Oct 28 2019
8
9
2. name: Spectacular Modern Uptown Duplex
10
    _id: 582364
11
    bedrooms: 4
12
    bathrooms: 2.5
13
    most recent review date: Wed Mar 06 2019
14
15
3. name: Grace 1 - Habitat Apartments
16
    _id: 29407312
17
    bedrooms: 4
18
    bathrooms: 2.0
19
    most recent review date: Tue Mar 05 2019
20
21
4. name: 6 bd country living near beach
22
    _id: 2741869
23
    bedrooms: 6
24
    bathrooms: 3.0
25
    most recent review date: Mon Mar 04 2019
26
27
5. name: Awesome 2-storey home Bronte Beach next to Bondi!
28
    _id: 20206764
29
    bedrooms: 4
30
    bathrooms: 2.0
31
    most recent review date: Sun Mar 03 2019

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
{ 
2
    _id: 5db6ed14f2e0a60683d8fe42,
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
}

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

1
1 document(s) matched the query criteria.
2
1 document(s) was/were updated.

1
{ 
2
    _id: 5db6ed14f2e0a60683d8fe42,
3
    name: 'Infinite Views',
4
    summary: 'Modern home with infinite views from the infinity pool',
5
    property_type: 'House',
6
    bedrooms: 6,
7
    bathrooms: 4.5,
8
    beds: 8 
9
}

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
0 document(s) matched the query criteria.
2
One document was inserted with the id 5db9d9286c503eb624d036a1

1
{ 
2
    _id: 5db9d9286c503eb624d036a1,
3
    name: 'Cozy Cottage',
4
    bathrooms: 1,
5
    bedrooms: 2 
6
}

1
await upsertListingByName(client, "Cozy Cottage", { beds: 2 });

1
1 document(s) matched the query criteria.
2
1 document(s) was/were updated.

1
{ 
2
    _id: 5db9d9286c503eb624d036a1,
3
    name: 'Cozy Cottage',
4
    bathrooms: 1,
5
    bedrooms: 2,
6
    beds: 2 
7
}

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
await updateAllListingsToHavePropertyType(client);

1
3 document(s) matched the query criteria.
2
3 document(s) was/were updated.

1
{ 
2
    _id: 5db9d9286c503eb624d036a1,
3
    name: 'Cozy Cottage',
4
    bathrooms: 1,
5
    bedrooms: 2,
6
    beds: 2,
7
    property_type: 'Unknown' 
8
}

1
{ 
2
    _id: '582364',
3
    listing_url: 'https://www.airbnb.com/rooms/582364',
4
    name: 'Spectacular Modern Uptown Duplex',
5
    property_type: 'Apartment',
6
    room_type: 'Entire home/apt',
7
    bedrooms: 4,
8
    beds: 7
9
    ...
10
}

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
await deleteListingByName(client, "Cozy Cottage");

1
1 document(s) was/were deleted.

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
}

1
await deleteListingsScrapedBeforeDate(client, new Date("2019-02-15"));

1
606 document(s) was/were deleted.