|
DoD:
Create an Atlas free-tier cluster containing a stores.orders collection in it. Orders should have the following form.
{
|
_id: ObjectId(),
|
orderPlaced: datetime(),
|
total: NumberDecimal("153.00"),
|
subtotal: NumberDecimal("141.00"),
|
shipping: NumberDecimal("5.00"),
|
tax: NumberDecimal("7.00"),
|
status: ["shipped", datetime()],
|
shippingAddress: {
|
number: 345,
|
street: Alvin St.,
|
city: Madison
|
state: WI,
|
country: USA
|
postalCode: 53558
|
},
|
lineitems: [
|
{ sku: "MDBTS001",
|
name: "Flannel T-shirt",
|
quantity: 10,
|
unit_price: NumberDecimal("9.00") },
|
{ sku: "MDBTS002",
|
quantity: 5,
|
unit_price: NumberDecimal("10.00")}]
|
}
|
Write a Java sample application that aggregates this collection using aggregation pipeline. The sample app should have the following methods:
- Simple aggregation for count using Accumulator.sum
- Simple aggregation for average using Accumulator.avg
- Make use of project in Aggregation Expressions
Pull request passes code review and merged
|