如何使用shell脚本将json对象从文件上传到couchdb?

pes8fvy9  于 2022-12-09  发布在  CouchDB
关注(0)|答案(1)|浏览(180)

示例json数组

[
{
   id : 1,
   name : Amit,
   age : 18,
   inSchool : 1;
}, 
{
   id : 2,
   name : Sunil,
   age : 21,
   inSchool : 0;
}, 
{
   id : 3,
   name : Anil,
   age : 17,
   inSchool : 1;
}
]

我想要-〉
从文件循环这个JSON数组,并将这些json对象存储在couchdb中。
如果有什么好办法的话。请帮帮我。

gajydyqb

gajydyqb1#

对于真实的的JSON文件,例如:

[
    {
        "id": 1,
        "name": "Amit",
        "age": 18,
        "inSchool": 1
    },
    {
        "id": 2,
        "name": "Sunil",
        "age": 21,
        "inSchool": 0
    },
    {
        "id": 3,
        "name": "Anil",
        "age": 17,
        "inSchool": 1
    }
]

您可以使用基于以下内容的脚本循环遍历此JSON数组:

jq -r '.[] | "\(.id) \(.age) \(.inSchool) \(.name)"' fixed.json | \
while read -r    id     age     inSchool     name
do
    echo "- item[id = ${id}]: name: ${name}, age: ${age}, inSchool: ${inSchool}"

    # Add command to upload to couchdb

done

输出:

➜ bash script.sh
 - item[id = 1]: name: Amit, age: 18, inSchool: 1
 - item[id = 2]: name: Sunil, age: 21, inSchool: 0
 - item[id = 3]: name: Anil, age: 17, inSchool: 1

相关问题