jq没有得到预期的输出

debugcn 发表于 Dev

闪烁的星星

我的JSON看起来像这样。

"[{
   changes": [
    {
      "change": "{users=[7], submitted=true}",
      "date": "2016-11-13T14:34:27.353Z",
      "user": "abcd"
    }
   ]
}]

预期产量：

{
      id: null,
      date: "2016-11-13T14:34:27.353Z",
      type: "submission",
      user: abcd,
      _processDate: todaysDate
    }

我尝试过的JQ

[.[][] as $source |
$source.changes[] as $log |
$log.change |
{
  submitted: .| (scan("submitted=(?<submitted>[^,}]+)") // [""] ) | .[0],
  rejected: .| (scan("rejected=(?<rejected>[^,}]+)") // [""] ) | .[0]

} as $change |
[
  (
    select($change.submitted == "true") |
    {
      id: $source.id,
      date: $log.date,
      type: "submission",
      user: $log.user,
      _processDate: now | todate
    }),
    (select($change.rejected == "true") |
    {
      id: $source.id,
      date: $log.date,
      type: "rejection",
      user: $log.user,
      _processDate: now | todate
    }
  )
] |
.[]]

json中可能存在“拒绝”，并且输出应显示拒绝。我的JQ没有产生预期的输出。有关如何解决此查询的所有指针。感谢您的帮助。欣赏它。

杰夫·梅卡多（Jeff Mercado）

我会采用完全不同的方法，而是这样做。

(now | todate) as $_processDate | [
    .[].changes[]
    | (.change
        | scan("\\b(submitted|rejected)=true\\b")[]
        | {submitted:"submission",rejected:"rejection"}[.]) as $type
    | {id, date, $type, user, $_processDate}
]

首先请记下当前日期。然后确定更改的类型。假设“已提交”和“已拒绝”（或其他“类型”）是互斥的，则更容易在键名上进行匹配。然后建立结果。这会将结果保存在数组中。

https://jqplay.org/s/S65ySzbF30

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。