#!/bin/bash

# Bash script to create a new postgis database and prep it with GADM

# data for geovalidation purposes.

#

# Basic workflow:

#  1. Load gadm2 data into database

#  2. Load geonames data into database

#  3. Update geonames to gadm2 data tables

#

# Paul Sarando

# iPlant Collaborative

# Oct 2013

DB_NAME="geoscrub"

DB_USER="bien"

DB_HOST="localhost"

SCRIPT_DIR="$(dirname $0)"

function run_sql_script {

    local SCRIPT=$1

    psql -e -U "$DB_USER" -h "$DB_HOST" -d "$DB_NAME" --set ON_ERROR_STOP=1 < "$SCRIPT"

    if [[ $? != 0 ]]; then

        echo "Error while executing SQL script ${SCRIPT}"

        exit 1

    fi

}

echo "Updating geoscrub validation data."

"${SCRIPT_DIR}"/update_gadm_data.sh

if [[ $? != 0 ]]; then

    echo "Could not update ${DB_NAME} database with GADM data."

    exit 1

fi

"${SCRIPT_DIR}"/update_geonames_data.sh

if [[ $? != 0 ]]; then

    echo "Could not update ${DB_NAME} database with geonames.org data."

    exit 1

fi

run_sql_script "${SCRIPT_DIR}/geonames-to-gadm.country.sql"

run_sql_script "${SCRIPT_DIR}/geonames-to-gadm.stateprovince.sql"

run_sql_script "${SCRIPT_DIR}/geonames-to-gadm.county.sql"

echo "Validation data successfully updated."