#!/usr/bin/env bash

set -e

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”

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

echo "(TYPE is not set)"
type=''

else

type=$TYPE
echo "Type is: $TYPE"

fi

echo echo “Type Category Summary” echo “= = =” echo

if [ -z $type ]; then

psql $database -U $user -P pager=off -c "SELECT * FROM type_category_summary;"
psql $database -U $user -P pager=off -c "SELECT COUNT(*) AS total_count FROM messages;"

else

psql $database -U $user -P pager=off -c "SELECT * FROM type_category_summary WHERE type LIKE '%$type%';"
psql $database -U $user -P pager=off -c "SELECT COUNT(*) AS total_count FROM messages WHERE type LIKE '%$type%';"

fi