From b61f0508a98f32f32cb7551a40658fe45f12d24c Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Tue, 1 Dec 2020 11:19:28 +0100
Subject: [PATCH] script and sql to calculate offset for last x days

---
 gnuplot/calc-offset.sh  | 7 +++++++
 gnuplot/calc-offset.sql | 4 ++++
 2 files changed, 11 insertions(+)
 create mode 100755 gnuplot/calc-offset.sh
 create mode 100644 gnuplot/calc-offset.sql

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 ;
-- 
2.20.1