#!/bin/bash
set -Ceuo pipefail
PATH=/bin:/usr/bin:/usr/local/bin:/sbin:/usr/sbin

cd /var/www/html/rrd

test ! -f .iwg.html || rm -f .iwg.html
btime=$(date +%s.%N)
wget -q -O .iwg.html https://www.wis-jma.go.jp/iwgmonitor/iwgmonitor.jsp
rc=$?
etime=$(date +%s.%N)
test 0 = $rc || exit $rc


ruby /nwp/bin/iwg_import.rb btime="$btime" etime="$etime" .iwg.html
rc=$?
test 0 = $rc || exit $rc

if [ metrics.db -nt .iwg.html ]; then
  test ! -f /nwp/bin/iwg_watch_mail.sh || bash /nwp/bin/iwg_watch_mail.sh
fi

rm -f .iwg.html

sqlite3 metrics.db <<END_SQL
.headers on
.mode column
.output metrics.txt
SELECT
  datetime(ts,'unixepoch') AS rtime,
  datetime(ingested_at,'unixepoch') AS itime,
  center_id,
  metric,
  value
FROM metrics
WHERE ts >= strftime('%s','now')-86400
ORDER BY center_id, metric, ts;
END_SQL