#!/usr/bin/env bash

set -e

function script_dir {

val="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
echo "$val"

}

function grant-privileges {

if [ -z ${DATABASE_NAME+x} ]; then
  database=message_store
  echo "(DATABASE_NAME is not set. Using: $database.)"
else
  database=$DATABASE_NAME
fi

base=$(script_dir)

echo "» schema privileges"
psql $database -q -f $base/privileges/schema.sql

echo "» messages table privileges"
psql $database -q -f $base/privileges/table.sql

echo "» sequence privileges"
psql $database -q -f $base/privileges/sequence.sql

echo "» functions privileges"
psql $database -q -f $base/privileges/functions.sql

echo "» views privileges"
psql $database -q -f $base/privileges/views.sql

}

echo “Granting Privileges” echo “- - -” grant-privileges echo