Como usar o plug-in MongoDB Visual Studio Code

1
// MongoDB Playground
2
// To disable this template go to Settings \| MongoDB \| Use Default Template For Playground.
3
// Make sure you are connected to enable completions and to be able to run a playground.
4
// Use Ctrl+Space inside a snippet or a string literal to trigger completions.
5
6
// Select the database to use.
7
use('mongodbVSCodePlaygroundDB');
8
9
// The drop() command destroys all data from a collection.
10
// Make sure you run it against proper database and collection.
11
db.sales.drop();
12
13
// Insert a few documents into the sales collection.
14
db.sales.insertMany([
15
   { '_id' : 1, 'item' : 'abc', 'price' : 10, 'quantity' : 2, 'date' : new Date('2014-03-01T08:00:00Z') },
16
   { '_id' : 2, 'item' : 'jkl', 'price' : 20, 'quantity' : 1, 'date' : new Date('2014-03-01T09:00:00Z') },
17
   { '_id' : 3, 'item' : 'xyz', 'price' : 5, 'quantity' : 10, 'date' : new Date('2014-03-15T09:00:00Z') },
18
   { '_id' : 4, 'item' : 'xyz', 'price' : 5, 'quantity' : 20, 'date' : new Date('2014-04-04T11:21:39.736Z') },
19
   { '_id' : 5, 'item' : 'abc', 'price' : 10, 'quantity' : 10, 'date' : new Date('2014-04-04T21:23:13.331Z') },
20
   { '_id' : 6, 'item' : 'def', 'price' : 7.5, 'quantity': 5, 'date' : new Date('2015-06-04T05:08:13Z') },
21
   { '_id' : 7, 'item' : 'def', 'price' : 7.5, 'quantity': 10, 'date' : new Date('2015-09-10T08:43:00Z') },
22
   { '_id' : 8, 'item' : 'abc', 'price' : 10, 'quantity' : 5, 'date' : new Date('2016-02-06T20:20:13Z') },
23
]);
24
25
// Run a find command to view items sold on April 4th, 2014.
26
db.sales.find({
27
   date: {
28
      $gte: new Date('2014-04-04'),
29
      $lt: new Date('2014-04-05')
30
   }
31
});

1
{
2
   acknowleged: 1,
3
   insertedIds: {
4
      '0': 2,
5
      '1': 3,
6
      '2': 4,
7
      '3': 5,
8
      '4': 6,
9
      '5': 7,
10
      '6': 8,
11
      '7': 9
12
   }
13
}

1
// Run an aggregation to view total sales for each product in 2014.
2
const aggregation = [
3
   { $match: {
4
      date: {
5
         $gte: new Date('2014-01-01'),
6
         $lt: new Date('2015-01-01')
7
      }
8
   } },
9
   { $group: {
10
      _id : '$item', totalSaleAmount: {
11
         $sum: { $multiply: [ '$price', '$quantity' ] }
12
      }
13
   } },
14
];
15
16
db.sales.aggregate(aggregation);

1
[
2
   {
3
      _id: 'abc',
4
      totalSaleAmount: 120
5
   },
6
   {
7
      _id: 'jkl',
8
      totalSaleAmount: 20
9
   },
10
   {
11
      _id: 'xyz',
12
      totalSaleAmount: 150
13
   }
14
]