使用 Bash Shell 处理 JSON 文件
原文 http://wsgzao.github.io/post/bash-json/
前言
JSON(JavaScript Object Notation) 是一种轻量级的数据交换格式,易于人阅读和编写,同时也易于机器解析和生成。本文提供一个真实的测试用例需求,设计逻辑类似Makefile,我以Bash处理JSON为例,Coding水平有限,请各位多多包涵哈,欢迎大家一起学习和挑战各种不同的语言来实现。
巧用jq处理JSON数据
更新历史
2015年06月19日 - 初稿
阅读原文 - http://wsgzao.github.io/post/bash-json/
扩展阅读
- JSON - http://json.org/
- jq - http://stedolan.github.io/jq/
Test Case
In data pipeline system and configuration management systems, it’s very common that you need execute a bunch of jobs which has dependencies with each other.
Write a programpipeline_runnerto execute a list of shell scripts. The definition of those scripts and their dependencies are described in a JSON file. The program only takes in one argument which is the file path of JSON file that defines the jobs.
For example,
// jobs.json
{ "log0_compressed" : { "commands": "curl http://websrv0/logs/access.log.gz > access0.log.gz", "input": [], "output": "access0.log.gz" }, "log0" : { "commands": "gunzip access0.log.gz", "input": ["access0.log.gz"], "output": "access0.log" }, "log1_compressed": { "commands": "curl http://websrv1/logs/access.log.gz > access1.log.gz", "input": [], "output": "access1.log.gz" }, "log1" : { "commands": "gunzip access1.log.gz", "input": ["access1.log.gz"], "output": "access1.log" }, "log_combined": { "commands": "cat access0.log access1.log > access.log", "input": ["access0.log", "access1.log"], "output": "access.log" } }
To run the program
pipeline_runner jobs.json
As you can see, each job has its input files and output files.
- A job will only be executed if all its input files exist.
- A job can have multiple input files (or none) but only produce one output file.
- Users could run the program multiple times, but if a job’s output file already exists, the program would skip the job.
If you’re still not very clear, think ofMakefilein Linux systems. The logic is quite similar.
You could complete the test with the programming language you preferred.
Bash Shell
#!/bin/bash # dos2unix *.sh # Program: # This program to test json. # History: # 2015/06/18 by OX #---------------------------- custom variables ---------------------start runuser=root # commands log_combined_commands=`cat jobs.json | ./jq -r '.log_combined.commands'` log1_commands=`cat jobs.json | ./jq -r '.log1.commands'` log1_compressed_commands=`cat jobs.json | ./jq -r '.log1_compressed.commands'` log0_commands=`cat jobs.json | ./jq -r '.log0.commands'` log0_compressed_commands=`cat jobs.json | ./jq -r '.log0_compressed.commands'` # input file name log0_input=`cat jobs.json | ./jq -r '.log0.input[0]'` log1_input=`cat jobs.json | ./jq -r '.log1.input[0]'` log_combined_input1=`cat jobs.json | ./jq -r '.log_combined.input[0]'` log_combined_input2=`cat jobs.json | ./jq -r '.log_combined.input[1]'` # output file name log_combined_output=`cat jobs.json | ./jq -r '.log_combined.output'` log1_output=`cat jobs.json | ./jq -r '.log1.output'` log1_compressed_output=`cat jobs.json | ./jq -r '.log1_compressed.output'` log0_output=`cat jobs.json | ./jq -r '.log0.output'` log0_compressed_output=`cat jobs.json | ./jq -r '.log0_compressed.output'` #---------------------------- custom variables ---------------------end #---------------------------- user check ---------------------start if [ "`whoami`" != "$runuser" ]; then echo "Please re-run ${this_file} as $runuser." exit 1 fi #---------------------------- user check ---------------------end #---------------------------- function ---------------------start pause() { read -n1 -p "Press any key to continue..." } log_combined_check_first() { if [ -f "$log_combined_output" ]; then echo "${log_combined_output} has been generated, the programe will exit" exit 0 fi } log0_compressed_check() { if [ ! -f "$log0_compressed_output" ]; then eval ${log0_compressed_commands} fi } log0_check() { if [ ! -f "$log0_output" ]; then eval ${log0_commands} fi } log1_compressed_check() { if [ ! -f "$log1_compressed_output" ]; then eval ${log1_compressed_commands} fi } log1_check() { if [ ! -f "$log1_output" ]; then eval ${log1_commands} fi } log_combined_check() { if [ ! -f "$log_combined_output" ]; then eval ${log_combined_commands} echo "${log_combined_output} has been generated, the programe will exit" fi } #---------------------------- function ---------------------end #---------------------------- main ---------------------start echo " Please read first: [0]Check jobs.json and jq by yourself first [1]A job will only be executed if all its input files exist. [2]A job can have multiple input files (or none) but only produce one output file. [3]Users could run the program multiple times, but if a job's output file already exists, the program would skip the job. " pause #check if file exist and do the job log_combined_check_first log0_compressed_check log0_check log1_compressed_check log1_check log_combined_check #---------------------------- main ---------------------end
小结
我的代码未实现任意数量jobs的input,希望大牛指点
file://D:\pipeline (2 folders, 4 files, 490.55 KB, 531.04 KB in total.) │ jobs.json 794 bytes │ jq 486.13 KB │ pipeline_runner 2.95 KB │ README.md 714 bytes ├─logs (0 folders, 2 files, 248 bytes, 248 bytes in total.) │ access0.log.gz 123 bytes │ access1.log.gz 125 bytes └─result (0 folders, 5 files, 40.25 KB, 40.25 KB in total.) access.log 20.00 KB access0.log 10.00 KB access0.log.gz 123 bytes access1.log 10.00 KB access1.log.gz 125 bytes