source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/database/create_database_MEDIN.sh @ 7185

#!/bin/bash

if [ $# -lt 2 ]
then
         echo 1>&2 Usage: $0 username database [hostname] [port]
         echo 1>&2 - hostname defaults to 'localhost'
         echo 1>&2 - port defaults to 5432
         exit 127
fi

port="5432"
if [ $# -gt 3 ]
then
        port=$4
fi

host="localhost"
if [ $# -gt 2 ]
then
        host=$3
fi

dbOptions="-U $1 -d $2 -h $host -p $port"
echo $dbOptions

psql -f ingest_procedures_MEDIN.sql $dbOptions
psql -f original_document.sql $dbOptions
psql -f transformed_document.sql $dbOptions
psql -f spatial_data_MEDIN.sql $dbOptions
psql -f temporal_data_MEDIN.sql $dbOptions

#For MEDIN upgrades connecting spatial and temporal tables direct to original_document without intermediate spatial_temporal_data table
#psql -f spatial_temporal_data.sql $dbOptions # 

# - the following loads some test data into the system - useful for testing in absence of ingestible datasets
#psql -f test_data.sql $dbOptions