json - 使用 jq reduce 汇总多个值

Question

如何使用jq的reduce函数来处理多次操作？

给定一个模型:

{
  "usage" : {
    "os:linux" : {
      "2018_11_18" : {
        "amount" : 601046342,
        "credits" : 99783
      },
      "2018_10_18" : {
        "amount" : 839785106,
        "credits" : 173121
      }
    }
  }
}

和JQ文件:

reduce .usage."os:linux"[] as $item (
{"credits":0,"minutes":0}; 
."credits" += $item.credits
) 

我得到:

{
  "credits": 272904,
  "minutes": 0
}

很酷，但我想兼顾这两个领域，例如:

reduce .usage."os:linux"[] as $item (
{"credits":0,"minutes":0}; 
."credits" += $item.credits,
."minutes" += $item.amount /1000/60
) 

分号导致错误，逗号通过，但只处理最后一个任务，i,e,

{
  "credits": 0,
  "minutes": 24013.85746666667
}

Answer 1

总有明确的方式:

reduce .usage."os:linux"[] as $item (
  {"credits": 0, "minutes": 0 }; 
  {
    "credits": (.credits + $item.credits),
    "minutes": (.minutes + $item.amount / 60000) 
  }
)