install_test_database.sh

#!/usr/bin/env bash

sudo su -c "psql -lqt | cut -d \| -f 1 | grep -qw rolling_test" postgres

if [ "$?" -eq "0" ]; then
    read -p "Postgresql database \"rolling_test\" will be deleted, continue ? (y/n) " -n 1 -r
    if [[ ! $REPLY =~ ^[Yy]$ ]]
    then
        [[ "$0" = "$BASH_SOURCE" ]] && exit 1 || return 1
    fi

    echo ""
    sudo su -c "psql -c \"DROP DATABASE rolling_test\"" postgres
fi

sudo su -c "psql -c \"CREATE DATABASE rolling_test\"" postgres

sudo su -c "psql postgres -tAc \"SELECT 1 FROM pg_roles WHERE rolname='rolling'\" | grep -q 1" postgres
if [ "$?" -eq "0" ]; then
    sudo su -c "psql -c \"ALTER USER rolling WITH PASSWORD 'rolling'\"" postgres
else
    sudo su -c "psql -c \"CREATE USER rolling WITH PASSWORD 'rolling'\"" postgres
fi

sudo su -c "psql -c \"GRANT ALL PRIVILEGES ON DATABASE rolling_test TO rolling\"" postgres