SQL查询输出格式化处理，求助！

鸟哥のlinux

在shell 中有一个查询：
select id,name from eam_resource where name like '%E10337%' and fsystem='false';




shell输出到 /tmp/1.txt文本内容为：

# cat /tmp/1.txt
44828 | AO01-15 HQ Agent 4.4.0 44833 | AO01-15 Linux File System /dev/sda5 mounted on / (local/ext3) 44834 | AO01-15 Linux File System /dev/sda1 mounted on /boot (local/ext3) 44835 | AO01-15 Linux File System /dev/sda7 mounted on /home (local/ext3) 44836 | AO01-15 Linux File System /dev/sda3 mounted on /usr (local/ext3) 44837 | AO01-15 Linux File System /dev/sda2 mounted on /var/lib (local/ext3) 44838 | AO01-15 Linux File System /dev/sdb1 mounted on /backup (local/ext3) 44839 | AO01-15 Linux CPU 1 (1861Mhz Intel Xeon) 44840 | AO01-15 Linux CPU 2 (1861Mhz Intel Xeon) 44841 | AO01-15 Linux CPU 3 (1861Mhz Intel Xeon) 44842 | AO01-15 Linux CPU 4 (1861Mhz Intel Xeon) 44843 | AO01-15 Linux sshd Process 44844 | AO01-15 Linux Network Interface lo (loopback) 44845 | AO01-15 Linux Network Interface eth0 (ethernet) 44846 | AO01-15 Linux Network Interface eth1 (ethernet) 44826 | AO01-15

现在要输出这样的格式：

"22994":"E10337", "22995":"E10337 HQ Agent 4.4.0", "23000":"E10337 Linux CPU 1 (2261Mhz Intel Xeon)" ...

求支招~在此先谢了！

关阴月飞

目测一下：
直接把输出用管道传给AWK:

1. awk -vORS=, '{print "\042"$1"\042:\042"$2"\042"}'

复制代码

Shell_HAT

shell输出到 /tmp/1.txt文本内容为

什么数据库？
把你的完整代码贴出来看看

鸟哥のlinux

回复 3# Shell_HAT

PostgreSQL  SHELL其中代码为：

1. #!/bin/bash
   
2. SQL=`psql -h 192.168.137.254  -p 5432  -U admin_user admin_database -q -t -c  "select id,name from eam_resource where name like '%E10337%' and fsystem='false';"`

复制代码

谢谢~

关阴月飞

回复 4# 鸟哥のlinux


导到文件后，全变成了一行了？？   

鸟哥のlinux

回复 5# 关阴月飞

是的
   

鸟哥のlinux

回复 5# 关阴月飞

是的
   

关阴月飞

回复 7# 鸟哥のlinux

试试这样合不合要求：

1. awk --re-interval -vRS='[0-9]{5} +\\|'  'NF+=0{printf "\042"a "\042"$0"\042,"}{sub(/ +\|/,"\042:",RT);a=RT}'  urfile  

复制代码

鸟哥のlinux

回复 8# 关阴月飞

非常感谢
我现在得出的结果是：

1. "45297":"SND-0239","45300":"SND-0239 HQ Agent 4.6.6","45303":"SND-0239 Linux File System /dev/mapper/VolGroup00-LogVol00 mounted on / (local/ext3)","45304":"SND-0239 Linux File System /dev/sda1 mounted on /boot (local/ext3)","45305":"SND-0239 Linux Network Interface lo (loopback)","45306":"SND-0239 Linux Network Interface eth0 (ethernet)","45307":"SND-0239 Linux Network Interface eth1 (ethernet)","45308":"SND-0239 Linux CPU 1 (2128Mhz Intel Xeon)","45309":"SND-0239 Linux CPU 2 (2128Mhz Intel Xeon)","45310":"SND-0239 Linux CPU 3 (2128Mhz Intel Xeon)","45311":"SND-0239 Linux CPU 4 (2128Mhz Intel Xeon)","45312":"SND-0239 Linux sshd Process",

复制代码

加入要在始末加上{}，最终显示为：

1. {"45297":"SND-0239","45300":"SND-0239 HQ Agent 4.6.6","45303":"SND-0239 Linux File System /dev/mapper/VolGroup00-LogVol00 mounted on / (local/ext3)","45304":"SND-0239 Linux File System /dev/sda1 mounted on /boot (local/ext3)","45305":"SND-0239 Linux Network Interface lo (loopback)","45306":"SND-0239 Linux Network Interface eth0 (ethernet)","45307":"SND-0239 Linux Network Interface eth1 (ethernet)","45308":"SND-0239 Linux CPU 1 (2128Mhz Intel Xeon)","45309":"SND-0239 Linux CPU 2 (2128Mhz Intel Xeon)","45310":"SND-0239 Linux CPU 3 (2128Mhz Intel Xeon)","45311":"SND-0239 Linux CPU 4 (2128Mhz Intel Xeon)","45312":"SND-0239 Linux sshd Process", }

复制代码

该怎么处理呢？

关阴月飞

回复 9# 鸟哥のlinux

1. 
   
2. awk --re-interval -vRS='[0-9]{5} +\\|'  'BEGIN{printf "{"}NF+=0{printf "\042"a "\042"$0"\042,"}{sub(/ +\|/,"\042:",RT);a=RT}END{print "}"}'  urfile  

复制代码