SQL查詢輸出格式化處理，求助！

鳥哥のlinux

在shell 中有一個(gè)查詢：
select id,name from eam_resource where name like '%E10337%' and fsystem='false';




shell輸出到 /tmp/1.txt文本內(nèi)容為：

# 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

現(xiàn)在要輸出這樣的格式：

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

求支招~在此先謝了！

關(guān)陰月飛

目測(cè)一下：
直接把輸出用管道傳給AWK:

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

復(fù)制代碼

Shell_HAT

shell輸出到 /tmp/1.txt文本內(nèi)容為

什么數(shù)據(jù)庫(kù)？
把你的完整代碼貼出來看看

鳥哥のlinux

回復(fù) 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';"`

復(fù)制代碼

謝謝~

關(guān)陰月飛

回復(fù) 4# 鳥哥のlinux


導(dǎo)到文件后，全變成了一行了？？   

鳥哥のlinux

回復(fù) 5# 關(guān)陰月飛

是的
   

鳥哥のlinux

回復(fù) 5# 關(guān)陰月飛

是的
   

關(guān)陰月飛

回復(fù) 7# 鳥哥のlinux

試試這樣合不合要求：

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

復(fù)制代碼

鳥哥のlinux

回復(fù) 8# 關(guān)陰月飛

非常感謝
我現(xiàn)在得出的結(jié)果是：

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",

復(fù)制代碼

加入要在始末加上{}，最終顯示為：

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", }

復(fù)制代碼

該怎么處理呢？

關(guān)陰月飛

回復(fù) 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  

復(fù)制代碼