#!/bin/bash
# just to test right (automatic) values for date_added, date_modified
#
# author: s.schroeder@fz-juelich.de
# date:   2020-06-05

psql -h localhost -U django toar2 -W -c "\COPY timeseries FROM 'test_date_added.txt'"
sleep 2m
psql -h localhost -U django toar2 -W -c "UPDATE timeseries SET timeseries_label=TRIM(timeseries_label),timeseries_measurement_method=TRIM(timeseries_measurement_method),timeseries_original_units=TRIM(timeseries_original_units);"