isql

#!/bin/bash
#
# Patches/applies one or more change requests (or any SQL file) to a database.

SHELL=/bin/bash

source .env

g_db=sead_staging_development
g_host=$(dnsdomainname -A)
g_port=5433
g_user=

if [ -f ~/vault/.default.sead.server ]; then
    g_host=`cat ~/vault/.default.sead.server`
fi

if [ -f ~/vault/.default.sead.username ]; then
    g_user=`cat  ~/vault/.default.sead.username`
fi

POSITIONAL=()
while [[ $# -gt 0 ]]
do
    key="$1"
    case $key in
        --database|-d)
            g_db="$2"; shift 2;
        ;;
        --port|-p)
            g_port="$2"; shift 2;
        ;;
        --user|-U)
            g_user="$2"; shift 2;
        ;;
        --host|-h)
            g_host="$2"; shift 2;
        ;;
        --*)
            usage 'fatal: target database not specified!'
            shift 2;
        ;;
    esac
done

set -- "${POSITIONAL[@]}"

if [ "$g_db" == "" ]; then
    usage 'fatal: target database not specified!'
fi

psql -h $g_host -p $g_port -U $g_user -d $g_db