From 2418de9ecb48e94037cc9f2b645aaa30645e15ec Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Wed, 18 Nov 2020 12:59:15 +0100
Subject: [PATCH] export data and svg graphs

---
 pg-export.sh | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100755 pg-export.sh

diff --git a/pg-export.sh b/pg-export.sh
new file mode 100755
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
+
-- 
2.20.1