export data and svg graphs

diff --git a/pg-export.sh b/pg-export.sh
new file mode 100755 (executable)
index 0000000..13edf6e
--- /dev/null
+++ b/pg-export.sh
@@ -0,0 +1,16 @@
+#!/bin/sh
+
+rm -Rf /tmp/export
+mkdir /tmp/export
+
+pattern='.'
+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
+done
+