python - 将 SQL 查询转换为 mongo 查询

Question

我想将以下 SQL 转换为 mongo 查询:

SELECT brand_name,
    count(`inventory`) AS totalstock,
    count(if(`inventory`=0, `inventory`, NULL)) as outofstock,
    count(if(`inventory`!=0, `inventory`, NULL)) as availablestock,
    DATE_ADD(stock_updated_at, INTERVAL 318 minute) as stock_updated_at 
FROM x group by Brand order by stock_updated_at desc;

我想在项目中找到 stock_updated_at，而不是在组中使用它。

这是我的 mongoquery

db.x.aggregate([     
    { 
        "$group": {       
            "_id": { "Brand": "$Brand"},        
            "TotalStock": { "$sum": 1 },       
            "OutOfStock": { "$sum": ....
       ....
   ....

Answer 1

您可以尝试使用现有的转换器。 http://www.querymongo.com/