git.rot13.org Git - zc/blob - pg-export.sh

   1 #!/bin/sh
   2
   3 rm -Rf /tmp/export
   4 mkdir /tmp/export
   5
   6 pattern='.'
   7 test ! -z "$1" && pattern=$1
   8
   9 cat subvision-numbers.txt | grep "$pattern" | while read sensor pn imei name offset ; do
  10         echo "# $sensor [$pn]";
  11         echo "\COPY (select * from zc where pn = $pn) TO '/tmp/export/$sensor.csv' DELIMITER ',' CSV HEADER" | psql zc
  12         wget -O /tmp/export/$sensor.svg https://senzori.subvision.hr/cgi-bin/by_temp.cgi?$pn
  13         mkdir /tmp/export/$sensor
  14         cp -v /dev/shm/by_temp.$pn*.txt /tmp/export/$sensor
  15 done
  16