X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;ds=sidebyside;f=pg-export.sh;h=95c0e3a7b658d2d89247f3f5d1a93ea8c7efdb3e;hb=HEAD;hp=13edf6e0ba369acbf1501a4792156f7cad30d611;hpb=2418de9ecb48e94037cc9f2b645aaa30645e15ec;p=zc diff --git a/pg-export.sh b/pg-export.sh index 13edf6e..95c0e3a 100755 --- a/pg-export.sh +++ b/pg-export.sh @@ -9,8 +9,12 @@ test ! -z "$1" && pattern=$1 cat subvision-numbers.txt | grep "$pattern" | while read sensor pn imei name offset ; do echo "# $sensor [$pn]"; echo "\COPY (select * from zc where pn = $pn) TO '/tmp/export/$sensor.csv' DELIMITER ',' CSV HEADER" | psql zc - wget -O /tmp/export/$sensor.svg https://senzori.subvision.hr/cgi-bin/by_temp.cgi?$pn - mkdir /tmp/export/$sensor - cp -v /dev/shm/by_temp.$pn*.txt /tmp/export/$sensor + + # rijeka by temp + #wget -O /tmp/export/$sensor.svg https://senzori.subvision.hr/cgi-bin/by_temp.cgi?$pn + #mkdir /tmp/export/$sensor + #cp -v /dev/shm/by_temp.$pn*.txt /tmp/export/$sensor + + wget -O /tmp/export/$sensor.svg https://senzori.subvision.hr/cgi-bin/$pn.cgi done