-
Sabine Schröder authored#6: starting point for transfering data from old DB to new DB (DB approach (because only done once) -- no workflow)
Sabine Schröder authored#6: starting point for transfering data from old DB to new DB (DB approach (because only done once) -- no workflow)
test_date_added.sh 466 B
#!/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);"