From d90c659bcebbfb925e5709e55af4d0330ac7922c Mon Sep 17 00:00:00 2001
From: alex <alex@pdp7.net>
Date: Sat, 25 Nov 2023 20:21:41 +0100
Subject: [PATCH] Migrated from private repo

---
 weight/create_from_pdp7_pt | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100755 weight/create_from_pdp7_pt

diff --git a/weight/create_from_pdp7_pt b/weight/create_from_pdp7_pt
new file mode 100755
index 0000000..13e61ce
--- /dev/null
+++ b/weight/create_from_pdp7_pt
@@ -0,0 +1,15 @@
+#!/bin/sh
+
+set -ue
+
+DB="postgresql://alex%40IPA.PDP7.NET@db.h2.int.pdp7.net"
+
+psql $DB -c "drop schema if exists weight cascade"
+psql $DB -c "create schema weight"
+psql $DB <schema.sql
+psql $DB -c "create table weight.migrated(ts timestamp with time zone, value float)"
+
+psql "postgresql://pdp7_pt:pdp7_pt@devel.h2.int.pdp7.net/pdp7" -c '\copy (select "when", value from measures_floatmeasure join measures_measure on measures_measure.id = measures_floatmeasure.measure_ptr_id) to stdout' | psql $DB -c "\copy weight.migrated from stdin"
+
+psql $DB -c "insert into weight.weight(measured_at, value) select * from weight.migrated";
+psql $DB -c "drop table weight.migrated";
-- 
2.47.3