Sha256: f0b0d9bf0b8c26775e2ea81f05c2db67e27dc689b3a7bbf2de9a0c5e3fe2bb88
Contents?: true
Size: 827 Bytes
Versions: 14
Compression:
Stored size: 827 Bytes
Contents
#!/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
Version data entries
14 entries across 14 versions & 1 rubygems