#!/usr/bin/env bash

# file paths
ISSUE_DRUG_FILE="/opt/dosis2/ai_issue_drugs.sql"

choose_first_existing_file () {
    for f in "${@}"; do
        if [ -f "${f}" ]; then
            echo "${f}"
            break
        fi
    done
}

database=dosis2
owner=dsuper
psql_cmd="`choose_first_existing_file '/usr/pgsql-9.2/bin/psql' '/usr/lib/postgresql/10/bin/psql'`"


set -e

. /usr/share/dosis2/bin/shell-support-functions

export AWS_CONFIG_FILE="/opt/dosis2/.aws/config"
export AWS_SHARED_CREDENTIALS_FILE="/opt/dosis2/.aws/credentials"
export http_proxy=""
export https_proxy=""

rm -f ${ISSUE_DRUG_FILE} || true

aws s3 cp s3://manchac/broadcast/ai_issue_list/ai_issue_drugs.sql ${ISSUE_DRUG_FILE}

if [[ -f "${ISSUE_DRUG_FILE}" ]]; then
    ${psql_cmd} -U ${owner} -d ${database} -f ${ISSUE_DRUG_FILE}
    ${psql_cmd} -U ${owner} -d ${database} -c "SELECT * FROM drugs.refresh_instance_obj_det_warn();"
    echo "ai issue drug file loaded."
else
    echo "No ai drug issie sql file found!"    
fi



