#!/bin/sh
uris=`mysql -s pshbspool -e 'select uri from jmxmsgs where rtime between "2013-03-08" and "2013-03-11" and ikind = "特殊気象報" order by rtime'`

printf 'hour\ttime\titem\tvis\twspd\twdir\tpres\tstnid\taddr\tnote\n' > out.tsv

for uri in $uris
do
  wget -q -Ojmx.xml http://toyoda-eizi.net/pshbjmx/msg/$uri
  xsltproc tokusyukisyou.xsl jmx.xml >> out.tsv
done

sort out.tsv > out.ts2
mv -f out.ts2 out.tsv