#!/usr/bin/env bash

set -e

echo echo “Printing Messages” echo “= = =” echo

default_name=message_store

if [ -z ${DATABASE_USER+x} ]; then

echo "(DATABASE_USER is not set)"
user=$default_name

else

user=$DATABASE_USER

fi echo “Database user is: $user”

if [ -z ${DATABASE_NAME+x} ]; then

echo "(DATABASE_NAME is not set)"
database=$default_name

else

database=$DATABASE_NAME

fi echo “Database name is: $database”

default_table_name=messages

if [ -z ${STREAM_NAME+x} ]; then

echo "(STREAM_NAME is not set)"
stream_name=''

else

stream_name=$STREAM_NAME
echo "Stream name is: $STREAM_NAME"

fi

echo

if [ -z $stream_name ]; then

psql $database -U $user -x -P pager=off -c "SELECT * FROM messages"

else

psql $database -U $user -x -P pager=off -c "SELECT * FROM messages WHERE stream_name = '$stream_name'"

fi