JOSN文件解析

2024-05-24 05:08
文章标签 解析 josn

本文主要是介绍JOSN文件解析,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

JSON(JavaScript Object Notation, JS 对象简谱) 是一种轻量级的数据交换格式。一般通过网页将数据下发,通过C语言或shell脚本,来实现数据的解析交换等功能!,可以通过JSON在线视图查看器来查看JOSN数据格式,如下是一段JOSN数据:

192.168.0.21 - - [24/Nov/2016:00:28:01 +0800] "GET /auth/ping/index.html?gw_id=default&sys_uptime=17886&sys_memfree=257860&sys_load=0.34&wifidog_uptime=557952 HTTP/1.0" 200 4 
192.168.0.21 - - [24/Nov/2016:00:28:10 +0800] "GET /auth/auth/index.html?stage=counters&ip=192.168.0.186&mac=44:6d:57:b3:15:72&token=1100169&incoming=39684267&outgoing=7140946&gw_id=default HTTP/1.0" 200 7
192.168.0.21 - - [24/Nov/2016:00:28:10 +0800] "GET /auth/auth/index.html?stage=counters&ip=192.168.0.240&mac=d0:7e:35:d3:32:cc&token=6662206&incoming=168168594&outgoing=3575532&gw_id=default HTTP/1.0" 200 7
通过C语言进行解析:
#include <stdio.h>
#include <stdlib.h>FILE *in, *out;void read_file()
{char ch;char buf[1024];	int i = 0, size = 0;char msg0[] = " {\"deviceGUID\" : \"C48RNGBQ1GKB4A41\",\"timestamp\" : \"2016-12-30 02:00:00\",\"appData\":[{ \"id\": 0 ";fwrite(msg0,strlen(msg0),1,out);//把字符串内容写入到文件while ((ch = fgetc(in)) != EOF){char msg[] = " \",\"type\": \"AD\",\"appKey\": \"portal\",\"data:\"{ ";fwrite(msg,strlen(msg),1,out);//把字符串内容写入到文件fseek(out,0,SEEK_END);//定位文件指针到文件开始位置while ((ch = fgetc(in)) != '\n'){		buf[i++]=ch;  fwrite(&ch, 1, 1, out);  size++;}char msg1[] = " }\",";fwrite(msg1,strlen(msg1),1,out);//把字符串内容写入到文件fseek(out,0,SEEK_END);//定位文件指针到文件开始位置char msg2[] = " }\]}";fwrite(msg2,strlen(msg2),1,out);//把字符串内容写入到文件}
}int main()
{	if ((in = fopen("access_log","r")) == NULL) //in.txt 和out.txt 都在当前工作目录下存放{printf("canot find the access_log file!\n");exit(0);}if ((out = fopen("out_txt","w+"))==NULL) // 写入数据的文件{printf("canot find the out_txt file!\n");exit(0);}read_file();fclose(in); // 关闭文件fclose(out);puts("");return 0;
}

通过Shell脚本实现:

#!/bin/shif [ -n "$1" ]; then                                                                                                                     file_name=$1
elsefile_name="/data/device.json"
fiif [ -n "$2" ]; then                                                                                                                     file_path=$2
elsefile_path="/data/type.txt"
fi#echo "" > $file_name
echo "" > $file_name
echo "{" >> $file_name#----------------------------------------------------------------------------#
echo "\"deviceGUID\":\"C48RNGBQ1GKB4A41\"," >> $file_name#----------------------------------------------------------------------------#
timestamp=`date "+%G-%m-%d %H:%M:%S"`
echo "\"timestamp\":\"$timestamp\"," >> $file_name#----------------------------------------------------------------------------#
sysload=`uptime |awk '{print $10}'`
sysload=`echo ${sysload%%,*}`
echo "\"sysload\":\"$sysload\"," >> $file_name#----------------------------------------------------------------------------#
echo "\"mem\":" >> $file_name
echo "[" >> $file_nametotal=`free|grep "Mem" |awk '{print $2}'`
free=`free|grep "Mem" |awk '{print $4}'`
echo "  { \"total\": \"$total\", \"free\": \"$free\"}" >> $file_nameecho "]," >> $file_name
#----------------------------------------------------------------------------#
i=0file="/proc/stat"
echo "\"cpu\":" >> $file_name
echo "[" >> $file_nameif [ ! -d "$file" ]; then
user1=`cat $file|sed -n "1p"|awk '{print $2}'`
nice1=`cat $file|sed -n "1p"|awk '{print $3}'`
system1=`cat $file|sed -n "1p"|awk '{print $4}'`
idle1=`cat $file|sed -n "1p"|awk '{print $5}'`
iowait1=`cat $file|sed -n "1p"|awk '{print $6}'`
irq1=`cat $file|sed -n "1p"|awk '{print $7}'`
softirq1=`cat $file|sed -n "1p"|awk '{print $8}'`
stealstolen1=`cat $file|sed -n "1p"|awk '{print $9}'`
guest1=`cat $file|sed -n "1p"|awk '{print $10}'`total1=`expr $user1 + $nice1 + $system1 + $idle1 + $iowait1 + $irq1 + $softirq1 + $stealstolen1 + $guest1`user2=`cat $file|sed -n "1p"|awk '{print $2}'`
nice2=`cat $file|sed -n "1p"|awk '{print $3}'`
system2=`cat $file|sed -n "1p"|awk '{print $4}'`
idle2=`cat $file|sed -n "1p"|awk '{print $5}'`
iowait2=`cat $file|sed -n "1p"|awk '{print $6}'`
irq2=`cat $file|sed -n "1p"|awk '{print $7}'`
softirq2=`cat $file|sed -n "1p"|awk '{print $8}'`
stealstolen2=`cat $file|sed -n "1p"|awk '{print $9}'`
guest2=`cat $file|sed -n "1p"|awk '{print $10}'`total2=`expr $user2 + $nice2 + $system2 + $idle2 + $iowait2 + $irq2 + $softirq2 + $stealstolen2 + $guest2`total=`expr $total2 - $total1`
idle=`expr $idle2 - $idle1`use=`expr $total - $idle`
total=`expr $use \* 100`load=$(echo $use $total | awk '{ printf "%0.1f\n" ,$1/$2}')#load=`top -n 1 |grep Cpu | cut -d "," -f 1 | cut -d ":" -f 2|awk '{print $2}'`
#load=`top -n 1 |grep Cpu | cut -d "," -f 1 | cut -d ":" -f 2 | cut -d "," -f 1| cut -d " " -f 3`
#load=`top -n 1 |grep CPU |awk '{print $2}'|sed -n "1p"`
#load=`top -n 1 | awk '/CPU/{print $2}'|sed -n "1p"`
#load=`echo ${load%\,*}`echo "  { \"id\": \"$i\", \"load\":\"$load%\"}" >> $file_name
fi
echo "]," >> $file_name
#----------------------------------------------------------------------------#
file="/data/type.txt"if [ ! -d "$file" ]; then
type=`cat /data/type.txt|sed -n "1p"`total_M=`df -m| grep mntWRT|awk '{print $1}'`
used_M=`df -m| grep mntWRT|awk '{print $2}'`
free_M=`df -m| grep mntWRT|awk '{print $3}'`a=1024
total=$(echo $total_M $a | awk '{ printf "%0.1f\n" ,$1/$2}') 
used=$(echo $used_M $a | awk '{ printf "%0.1f\n" ,$1/$2}')
free=$(echo $free_M $a | awk '{ printf "%0.1f\n" ,$1/$2}')echo "\"storage\":" >> $file_name
echo "[" >> $file_name
echo "  { \"id\": \"$type\", \"total\":\"$total G\", \"used\":\"$used G\", \"free\":\"$free G\"}" >> $file_name
echo "]," >> $file_name
fi
echo "" >> $file_name
#----------------------------------------------------------------------------#
i=`cat /proc/net/dev | grep ":" | awk '{print $1}'|wc -l`
j=2
echo "\"nic\":" >> $file_name
echo "[" >> $file_name
#while [[ $j -ge $i ]];do
#for((j=1;j<=$i;j++));do
while [[ $j -le $i ]];doecho $j;
eth_name=`cat /proc/net/dev | grep ":" | awk '{print $1}'|cut -d ":" -f 1|sed -n ""$j"p"`if [ $eth_name != "lo" ];then
ip=`ifconfig $eth_name| grep 'inet addr:'|sed 's/.*inet addr://g'| cut -d " " -f 1`
#echo "ip:$ip" >> $file_name
#echo "ip:$ip"band=`ethtool $eth_name| grep Speed | awk '{print $2}'|cut -d "b" -f 1`
#echo "band: $band" >> $file_namesend_o=`ifconfig $eth_name | grep bytes | awk '{print $6}' | awk -F : '{print $2}'`
recv_o=`ifconfig $eth_name | grep bytes | awk '{print $2}' | awk -F : '{print $2}'`
sleep 1
send_n=`ifconfig $eth_name | grep bytes | awk '{print $6}' | awk -F : '{print $2}'`
recv_n=`ifconfig $eth_name | grep bytes | awk '{print $2}' | awk -F : '{print $2}'`send_r=`expr $send_n - $send_o`
recv_r=`expr $recv_n - $recv_o`
total_r=`expr $send_r + $recv_r`echo  "Send rate: $send_o Bytes/sec  Recv rate: $recv_o Bytes/sec Total rate: $total_r Bytes/sec"a=1024#total=`echo "sclae=2;$total_r/1024" | bc`
total=$(echo $total_r $a | awk '{ printf "%0.1f\n" ,$1/$2}')if [ `expr $i - $j` != 0 ]
thenecho "  { \"id\": \"$eth_name\", \"ip\": \"$ip\", \"band\": \"$band\", \"traffic\": \"$total M\"}," >> $file_name
elseecho "  { \"id\": \"$eth_name\", \"ip\": \"$ip\", \"band\": \"$band\", \"traffic\": \"$total M\"}" >> $file_name
fi
#j=$(($j+1))
fi
let "j++"
last_eth_name=$eth_name
done  
echo "]," >> $file_name
echo "" >> $file_name#----------------------------------------------------------------------------#
#----------------------------------------------------------------------------#
file="/services/data/tunerinfo.txt"if [ ! -d "$file" ]; then
line=`cat $file|grep ","|wc -l`i=0
j=`expr $line - 1` echo "\"tuner\":" >> $file_name
echo "[" >> $file_name
while [[ $i -le $j ]];dok=`expr $i + 1`freq=`cat $file|cut -d "," -f 1|sed -n ""$k"p"`qam=`cat $file|cut -d "," -f 2|sed -n ""$k"p"`stat=`cat $file|cut -d "," -f 3|sed -n ""$k"p"`ser=`cat $file|cut -d "," -f 4|sed -n ""$k"p"`snr=`cat $file|cut -d "," -f 5|sed -n ""$k"p"`sigint=`cat $file|cut -d "," -f 6|sed -n ""$k"p"`if [ `expr $i - $j` != 0 ]thenecho "  { \"id\":\"$i\", \"freq\":\"$freq\", \"qam\":\"$qam\", \"stat\":\"$stat\", \"ser\":\"$ser\", \"snr\":\"$snr\", \"sigint\":\"$sigint\"}," >> $file_nameelseecho "  { \"id\":\"$i\", \"freq\":\"$freq\", \"qam\":\"$qam\", \"stat\":\"$stat\", \"ser\":\"$ser\", \"snr\":\"$snr\", \"sigint\":\"$sigint\"}" >> $file_namefilet "i++"
doneecho "]," >> $file_name
fi#----------------------------------------------------------------------------#file="/data/userinfo"if [ ! -d "$file" ]; theni=`cat $file | grep ":" | wc -l`
j=1
echo "\"terminal\":" >> $file_name
echo "[" >> $file_name
while [[ $j -le $i ]];doecho $j;id=`expr $j - 1`
macid=`cat $file | grep ":" | cut -d "," -f 1|sed -n ""$j"p"`ip=`cat $file | grep ":" |cut -d "," -f 2|sed -n ""$j"p"`ctime=`cat $file | grep ":" | cut -d "," -f 5|sed -n ""$j"p"`cpnum=19132312345
platform=`cat $file | grep ":" | cut -d "," -f 3|sed -n ""$j"p"`
model=`cat $file | grep ":" | cut -d "," -f 3|sed -n ""$j"p"`
ch="K"
ch1="M"
if [ -d "/data/traffic.txt" ]; thenupt=`cat /data/traffic.txt|grep $ip|cut -d "," -f 2`dnt=`cat /data/traffic.txt|grep $ip|cut -d "," -f 3`echo "$upt" |grep -q "$ch"if [ $? -eq 0 ]thenupt=`echo "$upt" | cut -d "K" -f 1`upt=`expr $upt \* 1024`fiecho "$upt" |grep -q "$ch1"if [ $? -eq 0 ]        then            upt=`echo "$upt" | cut -d "M" -f 1`                                           upt=`expr $upt \* 1024 \* 1024`            fi echo "$dnt" |grep -q "$ch"if [ $? -eq 0 ]thendnt=`echo "$dnt" | cut -d "K" -f 1`dnt=`expr $dnt \* 1024`fiecho "$dnt" |grep -q "$ch1"                                  if [ $? -eq 0 ]                    then                               dnt=`echo "$dnt" | cut -d "M" -f 1`                                           dnt=`expr $dnt \* 1024 \* 1024`            fi  
elseupt="0.3M"dnt="1.2M"
fiecho "  {" >> $file_name
echo "    \"id\": \"$id\"," >> $file_name
echo "    \"ctime\": \"$ctime\"," >> $file_name
echo "    \"macid\": \"$macid\"," >> $file_name
echo "    \"ip\": \"$ip\"," >> $file_name
echo "    \"cpnum\": \"$cpnum\"," >> $file_name
echo "    \"platform\": \"$platform\"," >> $file_name
echo "    \"model\": \"$model\"," >> $file_name
echo "    \"upt\": \"$upt\"," >> $file_name
echo "    \"dnt\": \"$dnt\"" >> $file_nameif [ `expr $i - $j` != 0 ]
thenecho "  }," >> $file_name
elseecho "  }" >> $file_name
fi
let "j++"
done  
echo "]" >> $file_name
fi
#----------------------------------------------------------------------------#echo "}" >> $file_name

这篇关于JOSN文件解析的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/997460

相关文章

Golang HashMap实现原理解析

《GolangHashMap实现原理解析》HashMap是一种基于哈希表实现的键值对存储结构,它通过哈希函数将键映射到数组的索引位置,支持高效的插入、查找和删除操作,:本文主要介绍GolangH... 目录HashMap是一种基于哈希表实现的键值对存储结构,它通过哈希函数将键映射到数组的索引位置,支持

Python使用getopt处理命令行参数示例解析(最佳实践)

《Python使用getopt处理命令行参数示例解析(最佳实践)》getopt模块是Python标准库中一个简单但强大的命令行参数处理工具,它特别适合那些需要快速实现基本命令行参数解析的场景,或者需要... 目录为什么需要处理命令行参数?getopt模块基础实际应用示例与其他参数处理方式的比较常见问http

Python利用ElementTree实现快速解析XML文件

《Python利用ElementTree实现快速解析XML文件》ElementTree是Python标准库的一部分,而且是Python标准库中用于解析和操作XML数据的模块,下面小编就来和大家详细讲讲... 目录一、XML文件解析到底有多重要二、ElementTree快速入门1. 加载XML的两种方式2.

Java的栈与队列实现代码解析

《Java的栈与队列实现代码解析》栈是常见的线性数据结构,栈的特点是以先进后出的形式,后进先出,先进后出,分为栈底和栈顶,栈应用于内存的分配,表达式求值,存储临时的数据和方法的调用等,本文给大家介绍J... 目录栈的概念(Stack)栈的实现代码队列(Queue)模拟实现队列(双链表实现)循环队列(循环数组

java解析jwt中的payload的用法

《java解析jwt中的payload的用法》:本文主要介绍java解析jwt中的payload的用法,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录Java解析jwt中的payload1. 使用 jjwt 库步骤 1:添加依赖步骤 2:解析 JWT2. 使用 N

Python中__init__方法使用的深度解析

《Python中__init__方法使用的深度解析》在Python的面向对象编程(OOP)体系中,__init__方法如同建造房屋时的奠基仪式——它定义了对象诞生时的初始状态,下面我们就来深入了解下_... 目录一、__init__的基因图谱二、初始化过程的魔法时刻继承链中的初始化顺序self参数的奥秘默认

Java 正则表达式URL 匹配与源码全解析

《Java正则表达式URL匹配与源码全解析》在Web应用开发中,我们经常需要对URL进行格式验证,今天我们结合Java的Pattern和Matcher类,深入理解正则表达式在实际应用中... 目录1.正则表达式分解:2. 添加域名匹配 (2)3. 添加路径和查询参数匹配 (3) 4. 最终优化版本5.设计思

使用Java将DOCX文档解析为Markdown文档的代码实现

《使用Java将DOCX文档解析为Markdown文档的代码实现》在现代文档处理中,Markdown(MD)因其简洁的语法和良好的可读性,逐渐成为开发者、技术写作者和内容创作者的首选格式,然而,许多文... 目录引言1. 工具和库介绍2. 安装依赖库3. 使用Apache POI解析DOCX文档4. 将解析

Java字符串处理全解析(String、StringBuilder与StringBuffer)

《Java字符串处理全解析(String、StringBuilder与StringBuffer)》:本文主要介绍Java字符串处理全解析(String、StringBuilder与StringBu... 目录Java字符串处理全解析:String、StringBuilder与StringBuffer一、St

Spring Boot循环依赖原理、解决方案与最佳实践(全解析)

《SpringBoot循环依赖原理、解决方案与最佳实践(全解析)》循环依赖指两个或多个Bean相互直接或间接引用,形成闭环依赖关系,:本文主要介绍SpringBoot循环依赖原理、解决方案与最... 目录一、循环依赖的本质与危害1.1 什么是循环依赖?1.2 核心危害二、Spring的三级缓存机制2.1 三