Sha256: 1bfafccb4042555d43662245afacc4f033349a0e6529f13adb802f552e8af10f
Contents?: true
Size: 1.11 KB
Versions: 32
Compression:
Stored size: 1.11 KB
Contents
#!/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 ${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
echo "Stream Type Summary"
echo "= = ="
echo
if [ -z $stream_name ]; then
psql $database -U $user -P pager=off -c "SELECT * FROM stream_type_summary ORDER BY stream_name, message_count DESC, type;"
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 stream_type_summary WHERE stream_name LIKE '%$stream_name%' ORDER BY stream_name, message_count DESC;"
psql $database -U $user -P pager=off -c "SELECT COUNT(*) AS total_count FROM messages WHERE stream_name LIKE '%$stream_name%';"
fi
Version data entries
32 entries across 32 versions & 2 rubygems