#!/usr/bin/env bash
set -e
echo echo “Installing Database” echo “= = =” echo
default_name=message_store if [ -z ${DATABASE_NAME+x} ]; then
echo "(DATABASE_NAME is not set. Default will be used.)" database=$default_name
else
database=$DATABASE_NAME
fi echo “Database name is: $database”
echo
function script_dir {
val="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )" echo "$val"
}
function create-user {
base=$(script_dir) psql -f $base/user/role.sql echo
}
function create-database {
createdb $database echo
}
function create-extensions {
base=$(script_dir) psql $database -f $base/extension/pgcrypto.sql echo
}
function create-table {
base=$(script_dir) psql $database -f $base/table/messages.sql echo
}
base=$(script_dir)
echo echo “Creating User: message_store” echo “- - -” create-user
echo echo “Creating Database: $database” echo “- - -” create-database
echo echo “Creating Extensions” echo “- - -” create-extensions
echo echo “Creating Table” echo “- - -” create-table
# Install functions source $base/install-functions.sh
# Install indexes source $base/install-indexes.sh
# Install views source $base/install-views.sh
# Install privileges source $base/install-privileges.sh