jq メモ

jq に環境変数を渡す

• "env.変数名" で渡すことができる

export TARGET_DATE=20200425
logs_json=`aws rds describe-db-log-files --db-instance-identifier ${DB_INSTANCE_IDENTIFIER}|jq '.DescribeDBLogFiles[]|select(.LogFileName|contains(env.TARGET_DATE))'|jq .`

• 連続する値を配列にする

$ aws rds describe-db-log-files --db-instance-identifier aurora-postgres-116-instance-1|jq '.DescribeDBLogFiles[]|select(.LogFileName|contains("2020-04-25"))'|jq -s
[
  {
    "LastWritten": 1587772801000,
    "LogFileName": "error/postgresql.log.2020-04-25-0000",
    "Size": 0
  },
  {
    "LastWritten": 1587776400000,
    "LogFileName": "error/postgresql.log.2020-04-25-0100",
    "Size": 0
  }
]