总体思路,1.用curl命令访问http接口,然后将数据保存到文件。 2.mysql可以使用load data,oracle可以使用sql loader将文件导入到DB。
1.curl访问http接口保存到response.dat文件
user=$1
pwd=$2
instance=$3
url=$4
xml=$( curl -s -H 'Content-Type: application/json'\
-u ${user}:${pwd}
-X POST '${url}'\
-d @request.dat
)
echo $xml > response.dat
echo "response downloaded"
2.导入到db,以oracle为例
cat > res.ctl <<!
options (skip=0)
LOAD DATA
INFILE " response.dat"
Append into table tbl
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
URl CONSTANT '$url'
,filename filler char(120),CONTENT lobfile(filename) terminated by eof
)
!
sqlldr userid='app/app' log=res.log control=res.ctl
3