How mongodb aggregates statistics: calculate the combined value of B based on the type of field A (addition and subtraction)

problem description

has the following data structure:

{id:1, name: "apple", alias:"", price: 5, type: "add"}
{id:1, name: "apple", alias:"", price: 3, type: "minus"}
{id:1, name: "pear", alias:"", price: 6, type: "add"}
{id:1, name: "pear", alias:"", price: 3, type: "add"}
{id:1, name: "pear", alias:"", price: 1, type: "minus"}

the first piece of data is that you made 5 yuan (type is add), and the second item is 3 yuan (type is minus), etc.).
the result I want is

classify according to name
calculate the combined value of the final price based on the classification of 1

the combined value is determined according to the type of type. When type is add, price is added; when type is munus, price is subtracted

for example, the final expected result above is:

[
    {name: "apple", price: 2},    //5-3
    {name: "pear", price: 8}      //6+3-1
]

how to use aggregate statistics to calculate the final merge value of price? please ask the god to give us some advice. Thank you

Nosql mongodb node.js

Jul.07,2021

is a bit doubtful, why not just save it in the form {price: 5} , {price:-3} ? In this way, the calculation is much simpler, and people seem to understand it better.
to do the calculation in your current form, you need to write a more complex pipeline:

db.foo.aggregate([{
    $project: {
        name: 1,
        price: {
            $cond: {
                if: {$eq: ["$type", "minus"]},
                then: {$subtract: [0, "$price"]},
                else: "$price"
            }
        }
    }
}, {
    $group: {
        _id: "$name",
        price: {$sum: "$price"}
    }
}])

if you store it as I say:

db.foo.aggregate([{
    $group: {
        _id: "$name",
        price: {$sum: "$price"}
    }
}])

much easier?

Previous: Mongodb index creation problem

Next: Two buttons control the display and hiding of the same piece of content

How does mongoose jointly check and complete the data and then classify and aggregate according to the fields of the joint search?
problem description < H2 > how does mongoose jointly check and complete the data and then classify and aggregate according to the fields of the joint search? < H2 > I now have two tables: a product table Product , a product category table Category...

Nosql mongodb node.js javascript

Mar.26,2021
Nodejs uses mongoose to operate mongodb
connecting to the database ok, is sure to be connected, but when manipulating a collection, the collection is not automatically created in the database when the collection does not exist. I remember that the document said that it would be automatically c...

Nosql mongodb node.js

Apr.22,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b35093-4d5fd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b35093-4d5fd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?