From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Tue, 1 Dec 2020 10:19:28 +0000 (+0100)
Subject: script and sql to calculate offset for last x days
X-Git-Url: http://git.rot13.org/?p=zc;a=commitdiff_plain;h=b61f0508a98f32f32cb7551a40658fe45f12d24c

script and sql to calculate offset for last x days
---

diff --git a/gnuplot/calc-offset.sh b/gnuplot/calc-offset.sh
new file mode 100755
index 0000000..84133c6
--- /dev/null
+++ b/gnuplot/calc-offset.sh
@@ -0,0 +1,7 @@
+#!/bin/sh
+
+days=90
+test ! -z "$1" && days=$1
+
+cat calc-offset.sql | sed "s/90 days/$days days/" | psql -A -t -F' ' zc 
+
diff --git a/gnuplot/calc-offset.sql b/gnuplot/calc-offset.sql
new file mode 100644
index 0000000..3df7f50
--- /dev/null
+++ b/gnuplot/calc-offset.sql
@@ -0,0 +1,4 @@
+select pn,-avg(x_axis_angle),-avg(y_axis_angle) from zc
+where time > now() - interval '90 days'
+group by pn
+order by pn ;