SED:如果符合条件的话，移除线块？

Question

如果只有在{的情况下才可以删除一行(包括启动},和结束"is_staff": true )

文本文件内容将始终采用这种格式：

[
{
  "model": "accounts.account",
  "pk": 2,
  "fields": {
    "password": "pbkdf2_sha256$320000$5vD4W5YDuvMmyyVRN5ub6U$weJzPTlN1Hrd7dlpjeO2Lw29a8ej+60Ib09vEifi4Qk=",
    "last_login": "2022-09-08T14:20:45.106Z",
    "is_superuser": false,
    "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
    "email": "account_admin@bk.ai",
    "first_name": "Marco",
    "last_name": "Rossi",
    "piva": "02375050511",
    "is_active": true,
    "is_staff": false,
    "date_joined": "2022-09-07T14:10:22.456Z",
    "groups": [
      1
    ],
    "user_permissions": []
  }
},
{
  "model": "accounts.account",
  "pk": 1,
  "fields": {
    "password": "pbkdf2_sha256$320000$mh3UDxtwhiROEecrz8XH3o$NmqWo9epps2EQnYYTe8bKm72HqfHImxUE/eVSZWQ/1U=",
    "last_login": "2022-09-09T13:54:09.498Z",
    "is_superuser": true,
    "licence": null,
    "email": "admin@bk.ai",
    "first_name": "",
    "last_name": "",
    "piva": "",
    "is_active": true,
    "is_staff": true,
    "date_joined": "2022-09-07T14:05:03.213Z",
    "groups": [],
    "user_permissions": []
  }
},
{
  "model": "accounts.account",
  "pk": 3,
  "fields": {
    "password": "pbkdf2_sha256$320000$n4PRBAgTo8AejcTf66LTEr$SxhmWFvIcf+gWDyzNXpWz0MrfjemaX1a2msBxUZNvBc=",
    "last_login": null,
    "is_superuser": false,
    "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
    "email": "account_viewer@bk.ai",
    "first_name": "Alessandro",
    "last_name": "Bianchi",
    "piva": "",
    "is_active": true,
    "is_staff": false,
    "date_joined": "2022-09-07T14:11:39.207Z",
    "groups": [
      3
    ],
    "user_permissions": []
  }
},
{
...
}
]

优先结果：

[
{
  "model": "accounts.account",
  "pk": 2,
  "fields": {
    "password": "pbkdf2_sha256$320000$5vD4W5YDuvMmyyVRN5ub6U$weJzPTlN1Hrd7dlpjeO2Lw29a8ej+60Ib09vEifi4Qk=",
    "last_login": "2022-09-08T14:20:45.106Z",
    "is_superuser": false,
    "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
    "email": "account_admin@bk.ai",
    "first_name": "Marco",
    "last_name": "Rossi",
    "piva": "02375050511",
    "is_active": true,
    "is_staff": false,
    "date_joined": "2022-09-07T14:10:22.456Z",
    "groups": [
      1
    ],
    "user_permissions": []
  }
},
{
  "model": "accounts.account",
  "pk": 3,
  "fields": {
    "password": "pbkdf2_sha256$320000$n4PRBAgTo8AejcTf66LTEr$SxhmWFvIcf+gWDyzNXpWz0MrfjemaX1a2msBxUZNvBc=",
    "last_login": null,
    "is_superuser": false,
    "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
    "email": "account_viewer@bk.ai",
    "first_name": "Alessandro",
    "last_name": "Bianchi",
    "piva": "",
    "is_active": true,
    "is_staff": false,
    "date_joined": "2022-09-07T14:11:39.207Z",
    "groups": [
      3
    ],
    "user_permissions": []
  }
},
{
...
}
]

Answer 1

由于您现在已经将输入的格式更改为实际的JSON，所以使用json感知工具(如jq )要简单得多，也更可靠。

jq '[ .[] | select(.fields.is_staff!=true) ]' <infile >outfile

这将是漂亮的打印，因此输出将缩进与输入样例不同。但是，它并没有改变JSON的含义。

Answer 2

Sed解决方案：sed -n '/^{/ , /^,}/ { /^{/ h; //!H; /^},/ { g ;/is_staff": true/d; //!p } }' file

从{到},，累积在保持空间中。

论},

• g将保持空间放入模式space
• /is_staff": true/d以删除模式space
• //!p以打印，否则为

Answer 3

sed '
    /^{$/ { # start of stanza - reset hold
        h
        d
    }

    # accumulate
    H

    /^},$/! d # next if not end of stanza

    # end of stanza - delete if match, else print
    x
    /"is_staff": true/ d
' file