文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >使用jq操作JSON文件

问使用jq操作JSON文件
EN

Stack Overflow用户
提问于 2018-01-30 16:43:43
回答 1查看 3.7K关注 0票数 3

我使用jq来操作JSON文件。我需要运行一个命令来搜索数组，找到一个具有键等于“someData”的对象，然后删除对象中的一个键，例如，从键等于“someData”的对象中删除一个“maxHeight”键。这里是一个示例JSON文件，我想搜索‘tracks’数组并找到标签=“cucumber_ChineseLong_v2.gff3”的对象，然后从该对象中删除‘maxHeight：“”200 an“。这甚至可以使用jq在单个命令中运行吗？

更新：我想要的输出是原始JSON，其中包含“maxHeight”键:值已删除。

更新：我尝试了几个命令。

代码语言：javascript
复制
jq '. as $dot|[range(0;length)|select(.maxHeight == "200px")|$dot[.]]' trackList.json > new.json

jq '.tracks[]  | select(.label == "cucumber_ChineseLong_v2.gff3")' trackList.json > test.json
  • Last命令可以隔离正确的Array，现在我需要知道如何使用jq从对象中删除密钥。

JSON文件

代码语言：javascript
复制
{
  "tracks": [
    {
      "storeClass": "JBrowse/Store/Sequence/StaticChunked",
      "chunkSize": 20000,
      "urlTemplate": "seq/{refseq_dirpath}/{refseq}-",
      "label": "DNA",
      "type": "SequenceTrack",
      "category": "Reference sequence",
      "seqType": "dna",
      "key": "Reference sequence"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0001.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0001.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0001.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0002.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0002.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0002.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0003.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0003.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0003.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0004.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0004.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0004.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0005.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0005.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0005.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "CG0010.gff",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/CG0010.gff/{refseq}/trackData.json",
      "compress": 0,
      "label": "CG0010.gff",
      "type": "FeatureTrack"
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "color": "function(feature, variableName, glyphObject, track){if(feature.get(\"type\") === \"CDS\"){return \"#9CFBF5\";} else if(feature.get(\"type\") === \"exon\"){return \"#43A47F\";} else if(feature.get(\"type\") === \"intron\"){return \"#E8E8E8\";} else if(feature.get(\"type\") === \"five_prime_UTR\"){return \"#F192FE\";} else if(feature.get(\"type\") === \"three_prime_UTR\"){return \"#FEC892\";} else {return \"#FF0000\";}}",
        "arrowheadClass": null,
        "featureCss": "padding:3px;"
      },
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Highlight a gene"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( feature[2] ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ],
      "hooks": {
        "modify": " function(track,feature,div){   var checkArr=[\"Reference\",\"Missing\",\"Heterozygous\",\"NonReference\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"NonReference\"){div.style.backgroundColor=\"red\"}else if(feature[i]==\"Reference\"){div.style.backgroundColor=\"green\"}else if(feature[i]==\"Heterozygous\"){div.style.backgroundColor=\"orange\"}else if(feature[i]==\"Missing\"){div.style.backgroundColor=\"grey\"} }}}}} "
      },
      "key": "cucumber_ChineseLong_v2.gff3",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/cucumber_ChineseLong_v2.gff3/{refseq}/trackData.json",
      "compress": 0,
      "label": "cucumber_ChineseLong_v2.gff3",
      "type": "JBrowse/View/Track/CanvasFeatures"
    },
    {
      "storeClass": "JBrowse/Store/SeqFeature/VCFTabix",
      "urlTemplate": "Cucumber115_chronly.vcf.gz",
      "maxHeight": "200px",
      "type": "CanvasVariants",
      "label": "Cucumber115_chronly.vcf",
      "menuTemplate": [
        {
          "label": "View details"
        },
        {
          "label": "Zoom"
        },
        {
          "iconClass": "dijitIconFilter",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().selectSequence( div.f.data.end ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Select Sequence"
        },
        {
          "iconClass": "dijitIconBookmark",
          "content": "function(track,feature,div) { window.parent.angular.element(window.frameElement).scope().specificNote( div.f.data.end ) }",
          "action": "contentDialog",
          "title": "(feature{name})",
          "label": "Create Note"
        }
      ]
    },
    {
      "style": {
        "className": "feature",
        "showLabels": false,
        "arrowheadClass": null,
        "featureCss": "padding:7px;"
      },
      "hooks": {
        "modify": " function(track,feature,div){ var checkArr=[\"Gene\",\"Variant\",\"Primer\"];for(var i=0;i<feature.length;i++){for(var j=0;j<checkArr.length;j++){  if( i>3) { if( feature[i] ===  checkArr[j] ) {  if(feature[i]==\"Gene\"){div.style.backgroundColor=\"pink\"}else if(feature[i]==\"Variant\"){div.style.backgroundColor=\"purple\"}else if(feature[i]==\"Primer\"){div.style.backgroundColor=\"blue\"} }}}}} "
      },
      "key": "Notes",
      "storeClass": "JBrowse/Store/SeqFeature/NCList",
      "trackType": null,
      "maxHeight": "200px",
      "urlTemplate": "tracks/Notes/{refseq}/trackData.json",
      "compress": 0,
      "type": "FeatureTrack",
      "label": "Notes"
    }
  ],
  "formatVersion": 1
}
json
jq
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-01-30 19:19:02

不幸的是，您没有遵循http://stackoverflow.com/help/mcve的指导方针，因此很难从您的描述中知道您期望的输出，但是从对象中删除密钥的最简单方法是使用del/1，如下所示：

代码语言：javascript
复制
.tracks
| map(select(.label=="cucumber_ChineseLong_v2.gff3") 
      | del(.maxHeight))

以您的JSON作为输入，上述查询的结果相当长，因此我不会将它包括在此响应中-- "mcve“中的"m”表示“极小”。

补充问答

是否可以在删除“maxHeight”后返回原始文件？

对于“编辑”(与提取相反)，诀窍是使用|=。有许多可能的变化，例如：

代码语言：javascript
复制
.tracks |=
  map(if .label=="cucumber_ChineseLong_v2.gff3"
      then del(.maxHeight)
      else .
      end)

有些人更喜欢一条线：

代码语言：javascript
复制
.tracks[] |= if .label=="cucumber_ChineseLong_v2.gff3" then del(.maxHeight) else . end
票数 6
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/48526476

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档