diff options
| -rwxr-xr-x | weight/create_from_pdp7_pt | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/weight/create_from_pdp7_pt b/weight/create_from_pdp7_pt new file mode 100755 index 00000000..13e61ce9 --- /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"; |